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
551 reads
Scripts
Calculate row length of table(s)
This procedure will be useful for developers/ database designers / DBAs to find the rowlength instantly.To find the row length of a user table, just copy this script into Query analyser and pass the table name for which you want to find the rowlength. @TabName is the table name parameter, if we donot provide this […]
2002-04-25
2,919 reads
Take a Cold Backup without shutting down SQL.
Set the Autoclose database option to True and perform a cold backup of your data files without even shutting down the SQL Server Services.
2002-04-25
957 reads
Detect SQL Server Instances using reg.exe
Detect SQL Server Instance(s) using reg.exe from the resource kit, just pass the host name! (and make sure reg.exe from the resouce kit is in the ../tools/bin directory. SS2k Only.Enjoy!
2002-04-23
1,067 reads
DTS-Less and Jobless Approach to Table Freshness
How about getting the data when the table data is first queried? The following script checks to see if the specified table (@MyTable) has been updated today. If so, just return the data found. If not, then get the data from a "fresher source". Great for ASP that performs table reporting and needs "baked daily" […]
2002-04-23
1,564 reads
Employee Email Addresses Function
This function provides easy email address creation from employee's LastName, First name.Enjoy!!
2002-04-23
1,337 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,217 reads
Generate Delete Stored Procedure
This procedure will generate a delete stored procedure against a provided table and column name in your database. It will search for foriegn key constraints and create a delete statement for each one found in the database. The procedure has three parameters:@table_name nvarchar(128) = the name of the source table@column_name nvarchar(128) = the name of […]
2002-04-22
295 reads
List Network Share Directories Quickly
Need a quick way to list shared folders? Do it in one call. Great for ASP page popups and user drop-down lists.Let's say that you want to display a list of projects, just call usp_GET_ProjectFolder and VIOLA! Only works with 2k; however, can be ported to ss7 if the udf is ported to a proc […]
2002-04-22
363 reads
Report table and column-level extended properties
SQL Server 2000's extended properties provide an easy way to store your data dictionary documentation within the database itself. This stored proc provides an easy way to extract all the table and column-level descriptions from those system tables for reporting purposes. This procedure can easily be modified to provide additional information to suite your needs. […]
2002-04-22
261 reads
Blogs
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Forums
ALAMAT KANTOR BCA KCP Sidareja Telp:083831618008
WhatsApp:0838-3161-8008 Jl. Jenderal Ahmad Yani No.40, Cikalong, Sidareja, Kec. Sidareja, Kabupaten Cilacap, Jawa Tengah...
Alamat Kontak Bank BCA KCP Cimahi Telp:08218154392
WA CS:08218154392 Jl. Raya Cimahi No.533, Karangmekar, Kec. Cimahi Tengah, Kota Cimahi, Jawa Barat...
Alamat Kontak Bank BCA KCU DAGO Telp:08218154392
WA CS:08218154392 Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung, Jawa Barat...
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers