Often the RAND() function is predictable based on the seed. This stored procedure generates a pretty good random integer because the seed itself is quite unpredictable. You can’t put this in a UDF since it is indeterminate due to the RAND and GETDATE() functions used.
2006-09-15 (first published: 2006-09-06)
631 reads
Stored procedure to return the list of columns of the primary key for a table. The name of the column for the result set is the name of the primary key for the table.
2006-09-14 (first published: 2006-09-07)
719 reads
For those that do not have SQL 2005 Management Studio, this utility reads from or writes to the SQL Enterprise Manager configuration. It can handle a Server Group hierarchy up to 5 levels deep. Usage instructions are included in the script.Run with cscript.exe.NOTE: Server registrations using SQL (not Windows) authentication write out the password in […]
2006-09-13 (first published: 2006-09-12)
234 reads
Troubleshooting intermitten connectivity issues can be difficult. One approach is to repeatedly test connecting to SQL Server outside of an existing application in order to verify if a server-wide intermitten issue is occurring. This script is used to test remote connectivity to a SQL Server. The script loops in one minute intervals (adjust as needed). […]
2006-09-04 (first published: 2006-08-08)
1,446 reads
to get information about tables+columns+primarykeys+foreignkeys+identity, i firstly used SQL server built-in INFORMATION_SCHEMA.xxx. however, my company have various DBAs and each of them owns objects. when using INFORMATION_SCHEMA.xxx, it retrieves data based on current login (version 2005 resolves this schema v.s. object owner problem already... yeah) , which bring me a great trouble. if you want […]
2006-08-30 (first published: 2006-07-25)
588 reads
This Script is used to reset the Identity coloumn to whatever the value we required. We need to compile this procedure in the database where we required to ressed the Identity coloumns of every table. After compiling we need to execute this procedure with a parameter of integer value. Then it will reseed the Identity […]
2006-08-29 (first published: 2006-07-26)
218 reads
This is an algorithm from the september 1986 issue of Byte Magazine, in an article called Abstract Mathematical Art. It borrows from Tim Conways Game of Life to represent an algorithm by which a series of numerical values can attempt to replicate itself. It is deeply steeped in the philosophy of Caos Theory and Evolution, […]
2006-08-28 (first published: 2006-07-27)
351 reads
Inspired in the script submited by ramesh_kondaparthy , this is a set oriented solution for the same problem.Parameters: 1) @InputString varchar(25)Accepts the string, which we need to validate 2) @Type int = 0 validate the string for only alphanumeric charactersi.e Allows characters between [A-Z] ,[a-z] and [0-9] = 1 validate the string for alphanumeric and […]
2006-08-22 (first published: 2006-08-01)
4,096 reads
Trigger to insert date into table in the form of01/01/00 12:00:00instead of SQL standard date format2000-01-01 12:00:00.000This allows easily comparing to or updating based onOracle date formats or a readable format for the web.triggername - name of the triggerTABLENAME - name of the table that trigger is created onCOLUMNNAME - name of column in TABLENAME […]
2006-08-21 (first published: 2006-08-01)
490 reads
Script to Get Total Rows, space used and reserved (KB) of all tables
2006-08-18 (first published: 2006-08-01)
1,100 reads
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers