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
333 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,216 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
937 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,057 reads
When changing the default language of a server it is neccessary to run sp_defaultlangauge against any existing logins. The reason is default language only effects any new accounts created after this change is made. This script is designed to help you quickly make the adjustment for all existing accounts. Note: this has been tested under […]
2002-05-09
127 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,354 reads
This UDF parses a comma delimited string and returns a table with the parse strings as rows. Usage: select * from fn+PareseString('12,13,14,67')Will return a table with the following rows12131467Can be modified to have an additional parameter for the type of delimiter.
2002-05-07
908 reads
This script gives the count of records of each user table in the current database along with the table name.
2002-05-07
736 reads
Here is as sample of implementing cursor.In some cases my tests showed that this approach performs better than native cursors in SQL Server.All you have to do is move the dataset into a temp table with a new Identity column and then use a simple loop to extract the data as you would do normally […]
2002-05-06
1,978 reads
This script shows how to get names of all stored procedures called from inside of specified stored procedure
2002-05-02
721 reads
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Comments posted to this topic are about the item Create an HTML Report on...
Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...
This is a topic to test whether reply notifications are working or not.
What does a slipstream installation mean?
See possible answers