Convert integers from decimal to binary display.

This script converts numbers from decimals to their binary equivalent.

You are a teacher that has computerized all...

Generate script for extended properties

The stored procedure generates insert script for table and column extended properties in the current database. The generated script checks whether a property exists, if it exists, drop it first. The stored procedure assumes table owner is dbo. It can be easily changed to other users.

Tables with Identity Columns

Run this script on the Database where you are trying to identify Tables with Identity columns.SQL SERVER 2000 SP3a

What does this query likely give me?

select
datepart(qq,...

Quick Propercase Function

This is my attempt to improve the performance of propercasing a string of text in SQL server. I have run this against several other "looping constructs" - and it is significantly faster.

There are tables A and B that are...

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