Topics
Started by
Posts
Last post
I would like to truncate a large table (12 million rows) but retain the current value of the identi…
1 replies
I have a business rule that I want to impliment in the database, since people make direct changes t…
3 replies
Guys, We are currently running SQL 7.0. The issue i have is, we have two identical tables A and B…
2 replies
I need to broken down the report by regions and sales. I know how to get this done in Access, but S…
3 replies
Hi, I tried to run the following query against several remote SQL2K boxes, SELECT a.name FROM OPENR…
2 replies
all , i have this proc "sp_send_cdontsmail" in my master db and when i run it from QA it seems to w…
9 replies
Is it possible to change the "Batch Separator" value from T-SQL? This "Batch Separator" value can b…
3 replies
Is there a restriction on how you use Input Parameters? The following code tells me I have to decla…
4 replies
HI Guys, Following is the VB Part. Function getSalesByPayment(pCompanyId As String, pDeptcode As S…
5 replies
I have a backup of database( named Payroll), this database is running on my sql server, How can i …
2 replies
Hi, Is there a way to open and run a file from within Query Analyzer? In Oracle, using SQL*Plus, th…
2 replies
Hello, How are you today? I have a crosstab report which allow users to search on Country and a dat…
6 replies
Can anyone direct me how to execute a DTS package from a stored procedure? Thanks, fryere fryere
14 replies
Recently, someone posted a way of getting a returned value from dynamic sql but I cannot find it. F…
4 replies
I need to update a field in a table with an id (or count of) values in another field. For example I…
3 replies
Viewing 15 topics - 14,986 through 15,000 (of 17,082 total)
You must be logged in to create new topics.