Example of How to use set IDENTITY_INSERT
a Basic example of how to manipulate an IDENTITY COLUMN AN HOW TO STOP the automatic counting using SET IDETNTITY_INSERT
2002-07-18
698 reads
T-SQL
Get computer Net Name in T-SQL
procedure is an extended xp called xp_getNetName to get the computer network identifcation name
2002-07-18
764 reads
Getting Information if a file exists in SQL
THERE is an extended sp called xp_fileexists given a full path to a file Name information is a 3 Bit vector 0/1 if a file doesn't/does exist0/1 is given name is a directory0/1 if the parent directory exists
2002-07-18
1,077 reads
A simple CrossTab procedure
this procedure gets a tableName,X axis column, Y axis column and a Value and draw a Pivot table from the Original Table Script also include an How to Use section
2002-07-15
1,344 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
Generate Number Range 2
Alternate method for generating a rowset with all of the numbers in a specified range.
2002-07-11
412 reads
Concatenate Rows without a cursor
You might come accross a situation where you want to retrieve the values of all the rows concatenated and stored in one variable. Here is the solution. Lets say you have a table called tblCustomerOrders which has CustID and OrderID. You now want all the OrderIDs for a particular Customer to be stored in one […]
2002-07-02
1,071 reads
GetFileInfo2
An Improved version of GetFileInfo that now includes the space utilization of each datafile. Provides more detail per file. Predict when your files are going to grow!! Both data and log files. This script organizes information about the database files on the server. A cursor is used to get the information from each database. The […]
2002-06-28
552 reads
Querying Responses
Binary data can be stored as integers in a table. This article explains how to query an integer field to return the bits represented by the integer.
2002-06-28
4,637 reads
Function to return a delimited list as a table
This SQL2000 function accepts a delimited list of values as a string and the character you want to use as a delimiter.The function then splits these out and returns them as a table.The function assumes that the input string will contain unique integer values.Useage: - SELECT Id FROM fnSplit('1,2,3,4' , ',')
2002-06-27
580 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Is It Right Time To Do Wedding Udaipur Rajasthan ?
Udaipur, Rajasthan, is a popular wedding destination known for its regal palaces, serene lakes,...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...