Viewing 15 posts - 2,761 through 2,775 (of 3,221 total)
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...
December 5, 2008 at 11:24 am
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...
December 5, 2008 at 11:01 am
Jeff
Pickle juice or formaldehyde? With or without pork chops?
Worked on that SP long before I hand the pleasure and enlightenment of reading your articles, and learning from them....
December 5, 2008 at 7:14 am
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...
December 4, 2008 at 3:20 pm
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
December 4, 2008 at 12:20 pm
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...
December 3, 2008 at 12:07 pm
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...
December 3, 2008 at 11:08 am
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...
December 3, 2008 at 6:38 am
Shine.mm If this copied correctly
(select filename from sys.sysfiles where fileid =1 and filename not like ''H:\MSSQL\'+@database_name+'\DATA\'+@database_name+'_Data.mdf''),
You have a EXTRA ' between like and and the drive letter H...
December 1, 2008 at 4:48 pm
Have you run Jack Corbett's code in SSMS?
select
account.nameof as account,
sum (entry.credit-entry.debit) as total
Into
...
November 29, 2008 at 12:06 pm
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...
November 29, 2008 at 9:48 am
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...
November 26, 2008 at 10:28 pm
The presentation of your question is rather vague, for example
storing this information in a column called request_date.
. Is this
column
an element of a SQL table, or...
November 26, 2008 at 6:38 pm
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...
November 21, 2008 at 9:17 am
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'...
November 20, 2008 at 10:53 am
Viewing 15 posts - 2,761 through 2,775 (of 3,221 total)