Topics
Started by
Posts
Last post
I'm re-writing some sp's and have come across the following: SELECT …
2 replies
I am looking for suggestions as to how best to handle errors (i.e., data row not found; database co…
1 replies
I am not sure what the best forum is for my question, but here it is: If I am writing a SQL query (…
4 replies
Hi Folks, I am hoping someone can shed some light on a query I have where I am trying to loop throu…
2 replies
Hi, we have a dts package that moves data from one sql server to another sql server. Both of them h…
3 replies
Hey guys, i created a TSQL script which produced the result set described below. Pre…
4 replies
Is there a way to insert a carriage return within a line of tSQL, such as for an address: a.Address…
9 replies
Hi, we have a global temp table in one of our databases that was created long time ago. I read th…
11 replies
Hello, I have a table with sixty columns in it, five of which define uniqueness for the records.&nb…
10 replies
I have a trigger that will insert the inserted column(s) into another table. create table a (ID int…
7 replies
Dear Friends, I have a very long query which is nearly 200 lines of sql code. We have nearly 250 ta…
8 replies
Hi, i have a stored procedure which executes a job.how can i generate an error message…
6 replies
Hi Guys.. i'm trying to get an understanding of index Looking at the execution plan of a Qu…
1 replies
Hello everyone! I have an SQL 2K table and in a particular field I wish to delete the contents of s…
3 replies
Guys, I have a table case_num_seq select * from case_num_seq seq_cd currval incr _________…
4 replies
Viewing 15 topics - 4,696 through 4,710 (of 17,082 total)
You must be logged in to create new topics.