fhanlon, I tend to agree with that option and feel a bit more comfortable with that. Thanks all for your input, you all are awesome! Edited by - aurora01 on 11/21/2003 10:47:37 AM Edited by - aurora01 on 11/21/2003 2:10:16 PM
2003-11-21
I am amazed with how many people here have associated a clustered index with a primary key... That's the way the gui does it by default, but by no means does the clustered index have to be on a primary key. You can still have a primary key that isn't clustered on a table with […]
2003-11-21
quote: At the end of the script, the original writer needed to return all column values except one. SELECT * INTO #temp FROM tablename ALTER TABLE #temp DROP COLUMN unwantedcolumn SELECT * FROM #temp DROP TABLE #temp
2003-11-20
I suspect that the problems with triggers may be because prior to SQL 2000, if a trigger (on a table with IDENTITY) happens to insert a record into another table that also has an IDENTITY column, you could only get the value of the last identity value generated which, in this case, would be the […]
2003-11-20
If you're only returning one row, use a stored procedure with output parameters for the values you are fetching. This will be faster than using a recordset and will leave you with instantiated command parameters that you can use in HTML. --Jonathan
2003-11-19
You can set the default collation of a database when you create it. --Jonathan
2003-11-13
1 reads
Cheers Jonathan, I can build use this as a basis for my queries. ta, yogi
2003-11-13
how about this way: restore your db from [9:45AM - full db backup via Veritas to tape] with NOrecovery, file = ? restore your log from [9:46 AM - log backup via Veritas to tape] with NOrecovery, file = ? restore your log from [6:15PM - log backup to local disk ] with Recovery, STOPAT […]
2003-11-13
The change from central european summertime to winter-?!?, normal time. *?@x`*§% Frank http://www.insidesql.de
2003-10-28
Have you tried from a different machine to make sure it's not network load, server load, etc? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-09-04
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers