Topics
Started by
Posts
Last post
Please take a look at my code below. I want to get all the matching rows from the student table (wh…
2 replies
Hello everyone, I have been caught off guard with this problem that SQL Server automatically trunca…
9 replies
Does anyone have a method of selecting the first xxx chars until a space is encountered? For exampl…
2 replies
Hi there, I am having trouble for running dynamic SQL with performance issue. I have a loop which …
9 replies
This should be an easy one for the pros in here. Bear with me, I'm still learning the ropes: If I …
8 replies
I am counting the non-null values of a column. Normally that could be done by a GROUP BY clause. Bu…
3 replies
What this does. Someone asked at another forum if there was a way to replace multiple spaces in a s…
3 replies
How does a Query analyzer communicate with a remote sql server? I mean what are the steps in the pr…
2 replies
I want to get the result of a following query to a stored procedure variable. How do i get it. Que…
7 replies
I've developed a procedure the compiles and yet doesn't set the local variables when reading throug…
1 replies
Has anyone else come across this? I found a REPLACE command that wasn't working as it should, or a…
2 replies
Hi, I have the following INSTEAD-OF trigger on my view: CREATE TRIGGER [TR_Testing_I] ON dbo.VIE…
10 replies
one of my scheduled job is failed.I want to find the reason behind the failure,where should i see t…
1 replies
I am having trouble understanding several issues regarding Local Temporary Tables. Perhaps you can…
2 replies
Can someone refresh me the differences between using 'truncate' and 'delete from' especially on dea…
9 replies
Viewing 15 topics - 14,626 through 14,640 (of 17,082 total)
You must be logged in to create new topics.