You have run the following code:

create table Bob
(MyID...

Which of these will return a "1"?

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