Topics
Started by
Posts
Last post
@@ERROR only indicates an error has occurred. How do you capture the corresponding error string (w…
4 replies
Hi, I have Outlook 2000 installed on my IIS / SQL server and have two Outlook profiles configured t…
5 replies
I'm not sure of the best way to do this so I figured I'd ask here. Essentially, I need to check th…
12 replies
I have a VB program I wrote that loads databases using the bulk insert. Currently, if the user has…
3 replies
Hi everyone, I have an nvarchar(20) column containing a date and time in the format (DD\MM\YYYY HH:…
12 replies
Hello everyone, I'm attempting to perform an update on table a by joining table b. Now, table a ha…
5 replies
I am trying to create a script to remove unused columns in a large database. Doesn't alter table su…
2 replies
How can I get a distinct count of all records in a table without having to list every field in the …
8 replies
Hi, I have a product that is composed of several attributes, some simple, some complex.. Eg, CAR Sc…
2 replies
Can this query be executed more efficiently? The nested loop part of the plan executes 153 times: S…
4 replies
Hi, Can someone give some advice on how best to advance from beginner to advanced TSQL, given that …
8 replies
Executing "Select @@IDENTITY as id" after an INSERT seems to return NULL. I am using VBScript/ASP …
14 replies
What does 'DERIVEDTBL' mean in SQL statement?
3 replies
My Problem is I have a Table Which Strores TimeStamp From system date using Getdate() Function SQL…
5 replies
Hello everyone, I have a question in regards to how to calculate a percentage of counts between 2 t…
4 replies
Viewing 15 topics - 14,221 through 14,235 (of 17,082 total)
You must be logged in to create new topics.