Views in SQL Server

A view is a virtual table that consists of columns from one or more tables. Though it is similar to a table, it is stored in the database. It is a query stored as an object. Hence, a view is an object that derives its data from one or more tables. These tables are referred to as base or underlying tables.

You are working with SQL Server 2005 and...

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