Viewing 15 posts - 14,566 through 14,580 (of 26,486 total)
Check Books Online for the sys.tables and sys.columns system tables.
June 19, 2011 at 6:35 pm
Tom.Thomson (6/19/2011)
Dave Ballantyne (6/19/2011)
Ok , so we all have differing opinions of Celko, but a response after three and a half years :crazy:
I don't think many threadizens will find...
June 19, 2011 at 3:49 pm
The help about is going to tell the version of the client tool while the @@version is going to tell you the version of the database server to which you...
June 19, 2011 at 3:30 pm
Attempting to use brain dumps to study for certification exams will cause you problems. What you really need to do is study and learn the concepts that are tested...
June 19, 2011 at 1:38 am
Sorry, but I'm confused as to what you are trying to accomplish. You provide some very basic table structures and sample data but you really to show what the...
June 19, 2011 at 1:36 am
If all you installed was the client (SSMS) then it is possible that it is connecting to a SQL Server 2005 server. You can use SQL Server 2008 client...
June 19, 2011 at 1:33 am
A few questions first. What is the problem you have encountered? What recovery model are you using for the database?
June 18, 2011 at 7:58 pm
Why are you using a full join instead of an inner join?
June 18, 2011 at 2:21 pm
It would help if you would provide the DDL for the tables (CREATE TABLE statements), sample data for each of the tables (a series of INSERT INTO statements), expected results...
June 13, 2011 at 11:56 pm
Please provide the DDL for the table(s) (CREATE TABLE stetment(s)), sample data for the table(s) (a series of INSERT INTO statements s for the table(s)), expected results based on the...
June 13, 2011 at 11:53 pm
Would help if you provided the DDL for the table (CREATE TABLE statement), sample data (series of INSERT INTO statements), expected results based on the sample data. You have...
June 13, 2011 at 11:50 pm
Syed Jahanzaib Bin hassan (6/13/2011)
then verify this back_set_id in the...
June 13, 2011 at 11:45 pm
Start by reading the first article I reference below in my signature block regarding asking for help and then follow the adive in the article. We need the table...
June 13, 2011 at 11:39 pm
Stefan Krzywicki (6/13/2011)
Brandie Tarvin (6/13/2011)
June 13, 2011 at 1:04 pm
Viewing 15 posts - 14,566 through 14,580 (of 26,486 total)