Topics
Started by
Posts
Last post
Hi we have a few usp's that use xp_cmdshell to executes some proprietary software that relies on ac…
3 replies
Can I create a temporary table (not using dynamic SQL - due to visibility outside of execution of S…
10 replies
does the Number of declared variables in a trigger affect heavely the performance of the transact s…
2 replies
Hi I have two tables. Table A I3_rowid Envelopeno 1 1234 4 &nbs…
2 replies
Which query is better for performance? It's not readily apparent to me by looking at the Execution …
8 replies
I have copied a Table from a MS Access Database to a Table on a SQL Server 2000 Database. This tabl…
6 replies
How/Can you fall thru to a default join if an inner fails? I thought of creating temp table with al…
7 replies
Hi, I have the following table:- NameType Dog Pet Cat Pet Monkey Pet John Owner Jack …
1 replies
I have an update trigger on a table. The update trigger inserts a row into another table -- t…
2 replies
I have a requirement that states that I need to capture an audit history on updates to records. I h…
4 replies
I am trying to return rows that are 7 days past due. I tried the following: select ln…
4 replies
I have a monitor/notify requirement on a large production system. It needs to run just about non-st…
2 replies
Hallo everybody, i have an syntax error in this Statement. Server: Msg 156, Level 15, State 1, Line…
2 replies
Help... I was recently asked why you need to use the TOP n PERCENT when you want to use ORDER …
6 replies
I need to update several client databases. How do I check table x for a column z to deter…
1 replies
Viewing 15 topics - 8,656 through 8,670 (of 17,082 total)
You must be logged in to create new topics.