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
855 reads
Script to sort by columns that may include NULLs
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
219 reads
Retrieve default value for parameter in procedure
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
341 reads
Script to retrive parameters for stored procedure
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,223 reads
Get all procs that are called from another procedure
This script shows how to get names of all stored procedures called from inside of specified stored procedure
2002-05-02
727 reads
Get stored procs that call a specified procedure
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,015 reads
Returning values of combining nulls and non nulls
This script shows how to retrieve combination of different columns that may have nulls.
2002-05-01
764 reads
Script to count the number of Yes/No in the string
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
546 reads
Quick update/insert into one table from another
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,208 reads
Error handling inside stored procedure
Following script gives an example how to handle errors inside stored procedure with returning information about type of error occured
2002-04-17
1,689 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers