Topics
Started by
Posts
Last post
Hi all, Please give me a hand. I have a table like this Customer_NameShip LocationShipper …
9 replies
Hi, Is there any way to achieve the above? eg, if i want to see all the user sprocs that contain th…
5 replies
Here is the problem, I pass a parameter to my sp. That param is a varchar that contains a comma se…
16 replies
Hi, I want to perform some union operation between 2 tables. for example from Northwind database…
4 replies
Hi, I need to sum some columns of tinyints. These columns contain 1 or 0. My Query SET DATEFORMAT D…
3 replies
I have a VB application as an interface to my SQL database. For a report, I'm running a stored pro…
10 replies
I was writing a script to find discrepancies between 2 tables with identical schemas. I wasn't find…
2 replies
Hi, I am having a problem with rolling back transactions in my database. I want to update a couple…
2 replies
/* I want to select a "pretty" description of a decimal numeric. "Pretty" = No trailing zeros …
4 replies
I have been looking for an alternative to using a cursor for a query I have been tasked with. I use…
1 replies
Indexproperty Function has this tow parmaters that can be suplied to It IsPageLockDisalowed and IsR…
1 replies
I have a stored procedure that is designed to return XML as its result. The stored procedure uses d…
3 replies
Hello Forum Gurus! Stuck coming up with a usefully simple solution to an update problem. Table has …
5 replies
I'm looking for some ideas on some queries that I have to write that are in a way, dynamic. My tabl…
6 replies
Hi, I have a sproc: begin tran while <condition> update sometable if @@error <>…
5 replies
Viewing 15 topics - 14,086 through 14,100 (of 17,082 total)
You must be logged in to create new topics.