Script showing how to count the number of Yes /No answers in the string
Inspired by tip that didn't work on Microsoft website
/* *Script showing how to count the number of Yes /No answers in the string */ declare @yesno varchar(10) set @yesno ='YNNYNNYNNY' SELECT len( REPLACE(@yesno,'N',isnull(space(0),''))) 'Yes',len(REPLACE(@yesno,'Y',isnull(space(0),''))) 'No'
Ever need to write reports out to a folder? I have found that creating output files are SA-WEET! (and easy too) The sample script uses BCP to create an HTML file.This process works well for reports that need to be generated nightly and take too long to run in real time. Use an SMTP mail […]
2002-04-18
4,327 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
2002-03-27
2,845 reads
This short and simple script is a very fast way to count the rows in all your indexed tables. I ran it against a 2-gigabyte database containing large tables (some with over a million rows!), and it returned results in under a second.
2002-03-12
2,855 reads
It calculates log free space in mb and in percent for all databases, and also show the quantity of different objects for one databases.
2002-02-02
2,747 reads
