Topics
Started by
Posts
Last post
Can some one optimize this query UPDATE T1 SET T1.COL1 = '1' WHERE T1.ID NOT IN (SELECT ID FROM T2 …
5 replies
Hi, I have a big problem: If I try to execute SET IDENTITY_INSERT as below, DECLARE @SqlCheckIdenti…
4 replies
Let's image... database DBr (Database runTime) and DBa (DBa has same structure as DBr). We wa…
6 replies
OK, here is one that has me stumped! I have a table that has a column of alpha-numeric reference co…
7 replies
Ok, we have 2 tables in SQL. and need to do this using procedure or straight SQL. Anyone can help?…
69 replies
Hello, [MS SQL 2000] Is there a way of finding which columns do not have any values contained …
3 replies
Does anyone have a good solution given this table: ID Name SortOrder -----------------…
23 replies
Hi I have a script which does the following IF Object_Id('#guk_temp_current_appointment_card_…
8 replies
Just a quickie really. Does anyone know the conversion from the format of the LSN given in DBCC LO…
1 replies
Hello, Hoping one of you tsql experts can give me some advice. I'm trying to put a query toge…
6 replies
Hello everybody Dou you recommend the use of the sentece GOTO in a store procedure? In my ca…
2 replies
Hi (SQL Server 2000) Another problem removing duplicates that I can't figure out how to do ! Table …
10 replies
Hi all, I understand that 1.Indexed Views 2. summary tables helps in faster response of the …
1 replies
I need to be able to add a char column that is filled with dollar amounts and also account for the …
7 replies
I have an asp.net vb page with 214 text boxes. I need to save the data from the textboxes to a tabl…
24 replies
Viewing 15 topics - 9,991 through 10,005 (of 17,082 total)
You must be logged in to create new topics.