Script to Generate Execution Permission to all Sprocs
This script generates script to give permissions to Particular user(s) to give exectue permission. This can be changed to give permission to tables, views also.
2002-05-09
219 reads
Scripts
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,226 reads
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
165 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
339 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
140 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
744 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
923 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,986 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
758 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
729 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
BCA KCU SCBD No. telp:087757645171
Whatsapp:087757645171 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal...
BCA KCU A. YANITelepon 083179431638
WhatsApp083179431638Jl. A. Yani No.656-658, Cicaheum, Kec. Kiaracondong, Kota Bandung, Jawa Barat 40282
BCA KCP Wahid Hasyim No.Telpon 087781685647
Whatsapp 087781685647 Jl. K.H. Wahid Hasyim No.82, RT.15/RW.3, Kb. Sirih, Kec. Menteng, Kota Jakarta...
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers