Topics
Started by
Posts
Last post
I use dynamic SQL in stored procedure to calculate values and update a table SET @SQLStatement = 'U…
10 replies
We have a linked server at a remote location. SQL2K SP3. Local server SQL2K SP3. The IP connection …
6 replies
Hi friends I need some idea on following situation.i am wondering how achieve what i wanted. I hav…
8 replies
Hello, I have a field of type smalldatetime that I am trying to query, and for some reason, I can't…
3 replies
I am trying to create a stored procedure that will provide Salesman information by product and mont…
5 replies
Hi I am looking to Convert This PROCEDURE TO Dynamic SQL Basically I have two Different Enviro…
5 replies
I have an access 2000 program that links to tables in SQL server 2000. While the program is a…
4 replies
Hi, If I have 2 different queries that return a lot of rows, Is there any way that I can us…
7 replies
there is SP which lets to send email: EXEC xp_sendmail 'emailaddr', 'The master database is full.' …
12 replies
I have a table like this DATE &nbs…
1 replies
Does anyone know if there is a system function or stored procedure that given a value it will retur…
1 replies
Here is a code snippet from The Guru's Guide to Transact-SQL (p. 126): SELECT s.State, …
2 replies
Question: Is is not possible to add a FOREIGN KEY constraint on a local or global Temporary table? …
2 replies
If I have the need to create a new field for a table where records already exist, and that new fiel…
4 replies
Hi- I'm in the U.S. so I leave all the collation settings to the default. However, now I want to gr…
1 replies
Viewing 15 topics - 13,786 through 13,800 (of 17,082 total)
You must be logged in to create new topics.