SQL Table Operation Archives - SQL Authority with Pinal Dave

Featured Post: SQL Server Performance Tuning Practical Workshop – Forward Looking

What is the Difference between TRUNCATE and DELETE in SQL Server? – Interview Question of the Week #118

April 16, 2017SQL Interview Questions and Answers2 SQL Function, SQL Scripts, SQL Server, SQL Table Operation

PowerShell – Reading Tables Data Using Script

September 24, 2016SQL1 Powershell, SQL Server, SQL Table Operation

SQL SERVER – How to Add Multiple New Columns to Table with Default Values?

March 29, 2016SQL Tips and Tricks4 SQL Scripts, SQL Server, SQL Table Operation

MySQL – How to Drop Table If Exists in Database?

March 28, 2016SQLNo CommentsMySQL, SQL Table Operation

SQL SERVER – Practical Tips to Reduce SQL Server Database Table Size – Experts Opinion

November 30, 2015SQL3 Devart, SQL Table Operation

SQL SERVER – UPDATE FROM SELECT Statement with Condition

September 30, 2014SQL Tips and Tricks10 SQL Scripts, SQL Server, SQL Table Operation

SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 4

September 25, 2013SQL Tips and Tricks7 SQL Function, SQL Scripts, SQL Server, SQL Table Operation