Generate Number Range 2
Alternate method for generating a rowset with all of the numbers in a specified range.
2002-07-11
412 reads
Scripts
Generating automatic select stmt for all columns
Here's how to use the derived table technique to generate an automatic script for selecting all columns in a table:
2002-07-11
508 reads
Get a summarized report of all DataBases options
This SELECT will give you a summarized report for the options selected for ALL the databases on your SQL Server. It's compatible with versions 7 and 2000.
2002-07-11
648 reads
Read a text file from SQL Server query analyzer
Here's a script that will read a text file from the Windows system into SQL Server
2002-07-11
1,108 reads
Finding the Nth Maximal Value
This procedure gets a tablename, column and an integer number N as parameters and finds the Nth maximum value of the column's value in a table for example : running it with 'products', 'UnitPrice' , 13 , @reswill get the 13TH largest value of unitprice from products is no such N exist an error message […]
2002-07-10
242 reads
Get SQL Server default collation
PROCEDURE used to find the server's default collation not shown in EM in servers properties
2002-07-10
1,106 reads
Locking Information - Simple SQL
Here's a simple SQL to give you locking information.The SQL tells you what resource type you are using, the object name, lock request mode, lock status, and also the calling program's name.And all this from a simple query on sysprocesses, and syslockinfo!
2002-07-10
666 reads
More Friendly version of sp_lock system sp.
This SQL Server stored procedure generates more readable output from the system sp_lock procedureinstead of getting object ids and session ids it returns the object name and user name
2002-07-10
1,017 reads
Procedure to export/import data using BCP
this procedure is an interface to bcp it gets database name,table name , file and path,,mode E/I for export/import and seperator character user and password and exports/imports text files from / to SQLSERVER
2002-07-10
1,415 reads
Summary of how to manage FULL TEXT indexing in TSQ
this script describes the steps neccessary to implement full text indexing in TSQL on your SQL SERVER systemCan be used programatically in tsql code
2002-07-10
720 reads
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
need help with assigning a value to a variable
Hi I am trying to assign the value of the variable using the output...
Merry Christmas 2025
Comments posted to this topic are about the item Merry Christmas 2025
The Reindeer Count
Comments posted to this topic are about the item The Reindeer Count
Question of the Day
The Reindeer Count
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers