Viewing 15 posts - 45,796 through 45,810 (of 49,571 total)
Bear in mind that was a very simple 2 table database that I played with there. Don't assume that the 0% will apply to more complex DBs with more...
July 11, 2008 at 7:51 am
A time table - Physics 101, Lecture room 2B, 9am every monday.
Movie schedules. Movie X shows every day this week at 17:00, 20:30 and 23:00
A store list with their opening...
July 11, 2008 at 7:35 am
Michael Earl (7/11/2008)
However, use the JOIN keyword. The old syntax with tables spearated by commas and...
July 11, 2008 at 5:48 am
You can either drop the foreign keys, truncate the table and then recreate the foreign keys, or you can use DELETE FROM instead of TRUNCATE TABLE
July 11, 2008 at 3:25 am
Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.
No replies to this thread please, direct replies to:
http://www.sqlservercentral.com/Forums/Topic532206-147-1.aspx
July 11, 2008 at 3:24 am
Could you post the query that you are using?
July 11, 2008 at 1:54 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic532181-323-1.aspx
July 11, 2008 at 1:51 am
SQL 2000 has no built in encryption/decryption mechanisms.
p.s. SQL 2000 posts should go in the SQL 2000 forums
July 11, 2008 at 12:53 am
John Rowan (7/10/2008)
July 11, 2008 at 12:36 am
JeeKay (7/10/2008)
I did not say DELETE log file. What i said was to have that removed from the list of files when you attach it.
Apologies. I misread.
However, if the...
July 11, 2008 at 12:32 am
I've noticed a large number or issues reported on this update.
Not just failures to install, but problems with the SQL instances after the install.
There are some interesting...
July 11, 2008 at 12:22 am
Select into just creates a new table matching the number and types of the columns in the select statement.
It does not create constraints, indexes, defaults or anything else other...
July 11, 2008 at 12:19 am
Jeff Moden (7/10/2008)
July 11, 2008 at 12:16 am
Viewing 15 posts - 45,796 through 45,810 (of 49,571 total)