Topics
Started by
Posts
Last post
Is there another way to create a script to perform a Rebuild Index on System Tables without using s…
1 replies
where can i see my triggers.In stored procedues list or some where else
4 replies
I need to execute a dynamic command against different DBs. So for normal stuff I'd USE DB1 COMMAND …
4 replies
Hello All, To sum it up: I am trying to condense the values which are in 6 different recordsets in…
6 replies
Here is part of my sp; Select DisplayName= Case @SortOrder when 1 then Cast(CSI.CSICode a…
2 replies
Hallo friends How can I find the first date of current week. Eg Today is '2003-05-14' First date of…
2 replies
Just wondering if there is any difference (performance or so) between memory table and temporary ta…
1 replies
Running this dynamic sql construct gives me an error because somehow it does not accept my variable…
2 replies
error 7405 - set ansi_nulls true for database and still getting the error when trying to created st…
1 replies
When I try to put my SQL into a Stored Procedure I get this error (see the attachment). My SQL exec…
1 replies
I have a stored procedure and it's scheduled to run for every 15 mins.And its working fine.But now …
2 replies
I want to lock down a table during 2 separate sequential SQL statements (insert, update - respectiv…
3 replies
Hi All, This will probably be an easy one. Im trying to select data within data i.e. I have a colum…
4 replies
I would select a field value by the position of the column in the table inserted and delete, becaus…
1 replies
Hi, I'm looking for a way to defer constraint checking until a commit in SQLServer 2000. In theory …
1 replies
Viewing 15 topics - 15,346 through 15,360 (of 17,082 total)
You must be logged in to create new topics.