Topics
Started by
Posts
Last post
Hi, I have a system whereby a user requests some consultancy on a certain day, the stored procedure…
2 replies
This procedure is useful to put it in scheduled job, then you'll get a fresh data table without mak…
4 replies
By: noeld
have a have a simple stored procedure i have made but i want it to be able to check if the input pa…
4 replies
By: sushila
Hi all, Does anyone know of a script I can run that can drop all the constraints in a database kind…
7 replies
By: matey
The companies system of record is a 1500+ table DB in 6.0 compliant mode on a SQL 2000 machine (MAS…
2 replies
hi, i want to query a table to get the value of a row, but if the row doesnt exist i want it to ret…
5 replies
Hi Everyone, I have written a stored procedure, which actually 1. selects data f…
1 replies
Would someone please guide me in the syntax for this. As you can hopefully see from my attempt I am…
5 replies
hi I would like to know how to find the no. of rows in a resultset of a query (Ex. SQLNumResultCol…
2 replies
How to convert smalldatetime values to mm/dd/yyyy without the time portion and without the unnecess…
5 replies
By: Sergiy
I have the following fields in table A: GL_ID|GL_Name_VC| Amount …
3 replies
Scenario 1 : I use temporary table to run my report. If the report was stopped by user inbetwe…
2 replies
I am working with a trigger that fires on an update. It's a single row update and I want to gr…
4 replies
I have the following fields in table A: GL_ID|GL_Name_VC | Amount &nbs…
3 replies
Hi All, Please help. I tried to build a sp so that user can pass-in database name and my sp w…
1 replies
Viewing 15 topics - 7,336 through 7,350 (of 17,082 total)
You must be logged in to create new topics.