TextToDecimal

SUMMARY:This UDF script takes a text value(nvarchar) and returns a decimal(18,6) number. If the text value can't be interpreted as numeric, the UDF returns NULL.-----------------------------------------------USAGE: SET @MyDecimal = dbo.TextToDecimal('-$123,456.73')@MyDecimal will now be -123456.730000SET @MyDecimal = dbo.TextToDecimal('-$123,4560.73') --bad number format@MyDecimal will now be NULL------------------------------------------------------DESCRIPTION:The ISNUMERIC function incorrectly returns 1 (True) for many non-numeric text values. Even […]

Add users to Windows NT Group

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 […]

You have this:

CREATE PROCEDURE procTestCounter
@CTR INT= 0
AS
DECLARE...

Random numbers

DECLARE @myString varchar(100)
SET @myString =' ONLYTWELVE ' +space(2)+Replicate(10,' ')
SELECT...

What does the following produce?

DECLARE @val CHAR(20)
SET @val...

List of Indexes and indexed columns in a Database

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).

What does the following produce?

DECLARE @val CHAR(20)
SET @val...

Another data dictionary

Pulls relevant information including col. names, keys, and the description (if the description field is filled out).This makes a good source for a data dictionary report.

Script to Generate DataDictionary for Database

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.