One thing that many people may do is disable a trigger temporarily to make changes without the trigger causing an issue. This is a simple way to quickly get all the triggers states in a database, so you can verify is it enabled or disabled.
2002-05-12
503 reads
With this store procedure you can send a parameters like 2379.56 and it will return the word value "TWO THOUSAND THREE HUNDRED SEVENTY NINE AND 56/100".
2002-05-10
695 reads
This UDF will parse a string delimited by the character you specify and return the value in the n-th position you requested.Example:select dbo.fn_parse('this string', ' ', 1) --> 'this'select dbo.fn_parse('this string', ' ', 2) --> 'string'select dbo.fn_parse('this string', ' ', 3) --> NULLselect dbo.fn_parse('this string', ' ', 2) --> ''
2002-05-10
508 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
347 reads
SFormat is UDF function that can convert seconds to HH:MM:SSEx:1- Select dbo.SFormat(130) will return 00:02:102- Select dbo.SFormat(dbo.test.Duration) as Dur (to be used with tables). where 'Test' is table name and 'Duration is a field(int).
2002-05-10
454 reads
Rather than invent (or learn) a whole new set of tools to preserve and version all DDL underneath our databases, we decided to use SourceSafe (something we're already using for all other source code). -- We've developed this VBscript to run nightly; it recreates object-level DDL in a given database and compares each object's script […]
2002-05-09
162 reads
This script gives the count of records of each user table in the current database along with the table name. This script eliminates the need of going through all the tables and counting them. Works on SQL 2000 (For SQL 7.0 - use 'rows' instead of rowcnt).
2002-05-09
2,374 reads
This script gives the count of records of each user table in the current database along with the table name using a single SQL Statement. It has been tested on SQL 7 and SQL 2000
2002-05-09
949 reads
Like the replace function, but can replace more than 1 value at a time.e.g. select dbo.multiple_replace('hello', 'e', '1', default) gives 'h1llo'. Equivalent to: select replace('hello', 'e', '1')e.g. select dbo.multiple_replace('hello world', 'e;w;ld', '1;2;END', default) gives 'h1llo 2orEND'e.g. select dbo.multiple_replace('hello world', 'e$w$ld', '1$2$END', '$') gives 'h1llo 2orEND'
2002-05-09
470 reads
This function was written to supplant cumbersome age-at calculations. To execute, simply set a local INT variable equal to the output of the function. For example, the following, given my birthdate, computes my own age: DECLARE @age_at INT SET @age_at = dbo.f_age_at ('2/16/1954', GETDATE ())
2002-05-09
1,071 reads
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Comments posted to this topic are about the item Backing Up a DMK
Comments posted to this topic are about the item The Quiet Part
Comments posted to this topic are about the item BIT_COUNT in SQL Server
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers