Testing all procs before upgrading to Compatibility Level 90
You can use this script to check if any procs will break under compatibility level 90.
2012-03-08 (first published: 2008-01-29)
4,014 reads
Luiz Barros
Find and Replace a String in the Whole Database
Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database.
2011-10-27 (first published: 2008-02-08)
3,385 reads
Change column type on constrained columns
Use this proc if you need to alter a column that is part of a primery key
2008-02-04 (first published: 2007-12-10)
1,096 reads
Blogs
Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers
By Devin-Knight
Welcome back to my Power Platform Quick Tips series! In this second episode we...
Simple-Talk Article…Understanding Azure Storage Options
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...
T-SQL Tuesday #120 – Recap
The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Sql to update active row
I have below two tables EMpbasetable: Skey,EmployeeNumber,Startdate,EndDate,Active 3,123,2019/06/10,2019/10/27,0 4,123,2019/10/28,4712/12/31,1 EmpIncTable: Skey,EmployeeNumber,Startdate,EndDate 9,123,2019/06/10,2019/10/17 10,123,2019/10/18,4712/12/31 My...
HTML page execute a procedure
I have zero front end coding skills; last time I worked with any code...
Ask SSC