Topics
Started by
Posts
Last post
I need to refresh a production table. If I run the following code, is there any chance that a user…
3 replies
Hi All This is pretty strange. Using Crystal reports with the ODBC setup as using the 'sa' account…
8 replies
Hi, in tsql there is a common format for datetime (regardless regional settings)? I use : 'mm/…
3 replies
I cannot figure out how to use a parameter within a qualified identifier to reference a column name…
19 replies
Hello all, Im working on a query to make db admin easier for me (ignore all the substrings!) select…
12 replies
Good day, I have been tasked with developing stored proc that will SMS the DBA's when a job fails. …
4 replies
I want to return a value (from a procedure) to it's calling procedure for error processing. Much li…
4 replies
Hi is there a way I can alter multiple columns in a single alter table query..? I.e. Alter table Te…
6 replies
dept_id dep_name member_name 1 prod mem1 1 prod mem2 1 p…
7 replies
The query, select * from tbl_ORD_CUST where c_order_id = x (ddl below) it's taking 4-8 seconds to …
10 replies
I need to add literal commas in the result output of Query Analyzer. Currently the resudlts are: 06…
14 replies
Hi, i need help on this.i have a query which is as follows QUERY SELECT count(Distinct…
10 replies
I have created an Audit table to store data from a base table whenever an insert or update or …
5 replies
I am getting this error while installing xp_smtp_sendmail. Can anybody try this? ODBC: Msg 0, Leve…
8 replies
When I try to use sp_MSget_jobstate to determine if a job is running, the variable returned by the …
2 replies
Viewing 15 topics - 5,476 through 5,490 (of 17,082 total)
You must be logged in to create new topics.