Posted on this site on 4/28/2004 may be exactly what you are looking for.

http://www.sqlservercentral.com/Forums/Topic113227-5-1.aspx

For a great many additional references, put into the Seach window on this page "xp_fixeddrives" for further...

Suggest using SSMS - change query output to "File" and then invoking sys.sql_modules. Although not completely programmatic. Sys.sql_modules could be invoked via C#, VB, dot net routines and...

Jeff

Worked on that SP long before I hand the pleasure and enlightenment of reading your articles, and learning from them....

This will list all tables and all columns in each table (And the gods of T-SQL preserve me - it uses a cursor - not the best practice, but I...

Refer to Books On Line (BOL)ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/15f1a5bc-4c0c-4c48-848d-8ec03473e6c1.htm

and

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/7a60ba81-b2cb-4798-9de4-767247c4c39d.htm

Hopefully this should give you sufficient guidance to do what you want to do

Refer to Books On Line (BOL) ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/717bcc19-9f86-4dcf-82cd-bc65a18fac6a.htm

where you will read:

The INSERT statement adds one or more new rows to a table. In a simplified treatment, INSERT has the following form:

INSERT...

Please refer to Books On Line (BOL) ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/edc46c29-51e0-4407-94a3-e68fd658ec3c.htm which states:

A table can have only one PRIMARY KEY constraint, and a column that participates in the PRIMARY KEY constraint cannot accept...

Introduced in SQL Server 2005, the Surface Area Configuration allowed you to enable or disable features which granted access to SQL Server components and configuration options.

Beginning in SQL Server...

Shine.mm If this copied correctly

You have a EXTRA ' between like and and the drive letter H...

Have you run Jack Corbett's code in SSMS?

select

account.nameof as account,

sum (entry.credit-entry.debit) as total

Into

...

Suggest reading Books On Line (BOL)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/1e068443-b9ea-486a-804f-ce7b6e048e8b.htm

Scroll half-way down the help file page and find

Temporary Tables

You can create local and global temporary tables. Local temporary tables are visible only in the...

Might I ask as to why you appear to be wanting to create table structure which is not normalized? For example with your tables DBX and ZipCodeAssoc

you could extract...

The presentation of your question is rather vague, for example

. Is this

an element of a SQL table, or...

Smunson:

think bitbucket's attempt will fall short whenever the same account number dials the same phone number once on one day, once the next, and then twice on another...

Using SSCrazy data you might want to try:

SELECT 1, 4026146434, '2008-11-17 17:01:27.023' UNION ALL

SELECT 2, 4026115201, '2008-11-19 17:01:27.023' UNION ALL

SELECT 1, 4026146434, '2008-11-19 17:01:27.023' UNION ALL

SELECT 3, 4026782001, '2008-11-19 17:01:27.023'...