Viewing 15 topics - 270,196 through 270,210 (of 284,146 total)
Topics
Started by
Posts
Last post
Hi I currently use COALESCE while updating tables so that if the input parameter is NULL(defaulted)…
4 replies
My DBA team just discovered that as long as developers have EM loaded to their desktops they can st…
1 replies
Hello, I have a Stored Procedure set up to take a single parameter which represents a numeric ident…
2 replies
We have a small group of users (4) that use MS Access 2000 to run queries on our MS SQL 2000 SP3 se…
6 replies
I am trying to run a stored procedure that sends the results through the sp_sendmail stored procedu…
1 replies
Hi all, As you know, the following statement assigns QUESTID to @myID. 1. select @myID = QUESTID fr…
4 replies
I have a problem with a join of 3 tables. The tables are described below Master (table name) alias …
4 replies
Hello, I have a fairly simple SP set up to accept a single parameter value, but I need a default va…
8 replies
If you have a SELECT stmt with a DISTINCT keyword, are the combination of all columns referenced di…
2 replies
Using SQL Server 2000, the documentation says (that's for the XOR but same goes for the AND, OR and…
2 replies
Named Pipes or TCP/IP Sockets used for client to connect to SQL Server in local area network envir…
13 replies
When I run sp_who2, the disk I/O value is 157369 for msde. Does it mean the Disk I/O is high? How t…
4 replies
Hello everyone, I have a process that sends me the results of a query using xp_sendmail. However, w…
5 replies
I’m having problems understanding the relationship between checkpoints, buffer cache, dirty pages a…
7 replies
Question: what is the 'N' for in the where clause for this query? SELECT CustomerID, CompanyName, C…
8 replies
Viewing 15 topics - 270,196 through 270,210 (of 284,146 total)