Script to match patterns thru reg. expressions
Script for finding matching patterns using regular expressions syntax.Created by Eva Zadoyenezadoyen@ssd.com06/20/2002
2002-06-20
838 reads
Script for finding matching patterns using regular expressions syntax.Created by Eva Zadoyenezadoyen@ssd.com06/20/2002
2002-06-20
838 reads
If you sort by in ASC order by column that may include NULLs and empty strings ( if type is varchar), the records with nulls will always appear before any others.This script will show how to chagne this pattern and move all records with NULLs to the bottom of your recordset
2002-05-23
209 reads
This procedure will return DEFAULT value for the parameter in the stored procedure. Usage: Use pubs go declare @Value varchar(30) exec _GetParamDefault 'random_password','@password_type',@value OUTPUT SELECT @VALUE Also accepts different versions, by default, if not specified, first version info retrieved. exec _GetParamDefault 'random_password;2','@password_type',@value
2002-05-10
320 reads
This stored procedure will retrieve list of parameters for specified stored procedure.To check similar names,like 'myproc_xxx', pass any char in the second parameter(optional).
2002-05-09
1,212 reads
This script shows how to get names of all stored procedures called from inside of specified stored procedure
2002-05-02
713 reads
This script will list all stored procedures that are calling the specified stored procedure. Also could be used to find procedures that contain any specified expression or words.
2002-05-01
1,003 reads
This script shows how to retrieve combination of different columns that may have nulls.
2002-05-01
753 reads
Script showing how to count the number of Yes /No answers in the string Inspired by tip that didn't work on Microsoft website
2002-04-26
534 reads
This script will show how quickly update records in one table with information from another or insert records if they are completely new.
2002-04-23
2,199 reads
Following script gives an example how to handle errors inside stored procedure with returning information about type of error occured
2002-04-17
1,681 reads
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers