T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.
2019-12-10
1,215 reads
T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.
2019-12-10
1 reads
I had the opportunity of working on a project converting a postgres database to...
By Rayis Imayev
(2020-Apr-06) Traditionally I would use data flows in Azure Data Factory (ADF) to flatten (transform)...
By nelsonaloor
In our earliest post, we have discussed in detail about the factors that affect...
Good morning all I can no longer use the powershell command "read-sqltabledata" and the...
Hi All, I am having table where below list of columns OrderNo ActualHours...
Comments posted to this topic are about the item Who is the best person...
Ask SSC