This procedure is useful to find the dependents on a particular column in a table and deletes the dependents like 'Index','Relation ships'.This is developed in Sql Server 2005
2007-06-01 (first published: 2006-03-10)
212 reads
Alphanumeric and Special Character Validation=========================================/*Function name: fn_ValidateStringDescription : This function is used to validate whether the given string contains Alphanumeric character and some special character’s ‘@’ ,’(‘, ‘ )’, ‘_’, ‘-‘Parameters: 1) @InputString varchar(25) Accepts the string, which we need to validate 2) @Type int = 0 validate the string for only alphanumeric characters i.e […]
2006-07-26 (first published: 2004-09-15)
1,657 reads
2006-03-16 (first published: 2004-09-29)
220 reads
This scripts adds the users to the specified Windows NT Group.This will be helpful if we want to give the access to group of users to a sql server, which is runing with Windows Authentication. Create a NT group and give the access on SQL and run this script it adds the user into the […]
2005-10-10 (first published: 2005-09-15)
496 reads
This scripts creates a view which will returns all the indexes and columns covered in the index for all the tables in a database.It returns only the user created indexes. Removes the statistics created on table (where indid > 0).
2005-08-24 (first published: 2005-08-23)
207 reads
This Procedure is used to generate the datadistionary for a database.It gives following columns : table_id, table_name,column_order,column_name, column_description Usage: Create the Procedure in the database where the datadisctionary need to be generated.Call : Execute Generate_getDataDictionary Return the result in Tabular format.
2005-08-12 (first published: 2005-08-05)
562 reads
This Script is used to validate the given string is password complince(i.e Strong Password) or not.Allows [A-Z] or [a-z] or [0-9] or [,(,~,!,@,$,%,*,{,},?,),].String need to have one character, 1 number and 1 specified special character.
2004-09-16
568 reads
Alphanumeric and Special Character Validation=========================================/*Function name: fn_ValidateStringDescription : This function is used to validate whether the given string contains Alphanumeric character and some special character’s ‘@’ ,’(‘, ‘ )’, ‘_’, ‘-‘Parameters: 1) @InputString varchar(25) Accepts the string, which we need to validate 2) @Type int = 0 validate the string for only alphanumeric characters i.e […]
2004-09-14
1,124 reads
I’ve been doing storage load tests for SQL Server for a long time, both...
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
I have an app that has an address field on the customer and the...
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
How do I easily get the next 12 sequence values from a sequence object?
See possible answers