Topics
Started by
Posts
Last post
Hi, can somebody tell me please what is wrong with this statement INSERT INTO …
6 replies
I updated our SQL Server with sp4 and then applied hotfix 2187 (the latest). However, I run queries…
1 replies
Hi, I am dynamically constructing the query and putting it in a variable called @Qry and finally ex…
10 replies
This looks like a promising bit of code, but I don't understand how to action it, I've run it in QA…
7 replies
How do I cast the figure 2000.00 to the integer 2000?
5 replies
I need to be able to interrogate the results of a "dbcc checkident" from a tsql procedure. I cannot…
3 replies
I am reading a text file into a temptable, then opening a cursor to read through the temptable. Whe…
8 replies
I need to update a tables modified_date column when a record is updated. If I do it in the AFTER UP…
11 replies
I have the following message when ask the property of the database, using Enterprise Manage: …
4 replies
Can we get the structure (column name & length) of records returned by SP ?
6 replies
Hi I have one table having orderdate and deliverydate Now i need to calculate Delivery performance…
15 replies
Hi Well I have a table employeemst which has the employeeid,employeename,salaray fields. Now I want…
1 replies
I am reading a temptable, and doing 2 inserts. In case of error, i want the 2 inserts to be undone,…
4 replies
Hi, I am tryng to get rid of temp tables in my script, but start getting different results as below…
1 replies
I had a query that was running very slowly and I couldn't figure out what was going on. Our n…
7 replies
Viewing 15 topics - 5,611 through 5,625 (of 17,082 total)
You must be logged in to create new topics.