2020-01-03
761 reads
T-SQL
2019-12-31
795 reads
Do You Have REFERENCES?
The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include foreign key constraints in the database design instead. In this article, Joe Celko talks about the history of references in SQL and the options available today.
2019-12-27
2019-12-24
899 reads
2019-12-19
231 reads
T-SQL script to purge all the tables including foreign key references
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,221 reads
T-SQL script to purge all the tables including foreign key references
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
Using All Your Tools
Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.
2019-12-07
290 reads
2019-12-06
709 reads
2019-12-03
1,148 reads
Blogs
SQL Prompt and SSMS 18.5
By Steve Jones
I downloaded SSMS 18.5, as there were a lot of fixes in here and...
Jupyter Book Challenges in ADS
By Steve Jones
I was excited to try the Jupyter Book feature in the March Azure Data...
Join me (virtually) in Adelaide!
I will be presenting a session to the Adelaide SQL Server User Group on...
Forums
Implementing Reporting Application Enhancements with No Downtime
Comments posted to this topic are about the item Implementing Reporting Application Enhancements with...
ADF Triggers
Comments posted to this topic are about the item ADF Triggers
In varchar column add numbers and show strings
Below is the sample data create table temp (userid int , rid varchar(10), value...
Ask SSC