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,212 reads
Scripts
Table of Numbers
A user-defined function that returns a table of numbers between a and b (using the most efficient way I can think of).e.g. select * from table_of_numbers(1, 4) gives a table with rows 1, 2, 3 and 4.
2002-05-09
146 reads
UDF to convert Seconds to DDD:MM:MM:SS Format
This function takes a number of Seconds in BIGINT format and calculations and displays that in a DDD:HH:MM:SS format.I wrote this because I needed to work out the duration between two datetimes and required the result to be displayed in a Report (VARCHAR (12)) format from a Select statementTo Use:SELECT dbo.csp_SecondsToDaysHoursMinutesSeconds(DATEDIFF(SS, , )) AS DurationFROM […]
2002-05-09
320 reads
Update existing user accounts default language.
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
122 reads
Count of records of all tables in current database
This script gives the count of records of each user table in the current database along with the table name.
2002-05-07
731 reads
User defined function to parse delimited strings
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
891 reads
Cursorless Cursor
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,962 reads
Get table sizes and rowcounts in MB (for VLDB)
This simple script is based on sp_spacedused, but returns values for all user tables in the database, with information in MB instead of the usual KB - which is useful for large databases. Simply run it in query analyser against the database concerned
2002-05-03
730 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
713 reads
2002-05-01
413 reads
Blogs
Master the Foundational Basics
By Brian Kelley
It tells us to take the time to master the foundational basics of whatever...
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Forums
How to write this query?
Hi everyone I have two tables storing stock prices. Each table comes from a...
ssrs order of operation question
hi i need "sample size" in my report's 4th data region which is a...
Query Network Protocols from T-SQL or PowerShell
Hello experts, I want to be more organized about the SSL certificates we have...
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers