Forum Replies Created
Viewing 15 posts - 2,506 through 2,520 (of 3,543 total)
-
RE: Moving Database with more than 16 Files to another drive !!Urgent!!
Another way is to BACKUP the db and use RESTORE ... WITH MOVE
-
RE: Difference Desktop & Standard Edition?
When a SQL7 db is attached to SQL2K it is converted, the same is true of restoring a db from a backup.
A SQL2K database cannot be attached to SQL7.
I have...
-
RE: Card Deck Simulation
Alternatives to Kenneth's
select number
from master.dbo.spt_values
where type ='P'
and number between 1 and 52
order by newid()
select top 5 number
from master.dbo.spt_values
where type ='P'
and number between...
-
RE: Stored Procedure is not working in .net application
Correct me if I am wrong, but I thought Parameters had to be added in order of SP... -
RE: Stored Procedure is not working in .net application
The error is a result of passing and empty string to a int parameter (int,smallint,tinyint). .NET will not convert empty strings to integer.
As an additional note you are implicitly converting...
-
RE: Question of the Day for 14 Oct 2004
Gosh, don't we all take these things a bit too seriously. Probably
Bragging...
-
RE: Question of the Day for 14 Oct 2004
How can a question like this get through QA ? Wow a volunteer for QA !!!
-
RE: Question of the Day for 14 Oct 2004
Well, Kelvin, you sure know how to kill a lively debate stone dead.
You are correct of course.
-
RE: EXEC & sp_executesql
I agree with you Scott, plan reuse in this scenario is probably minimal, I just answered the questions stated without commenting on the usage.
Again, not in this case, but sql...
-
RE: Width for Procedure Parameters
From BOL
varchar[(n)]
When n is not specified in a data definition or variable declaration statement, the default length is 1. When n is not specified with the CAST function, the default...
-
RE: Scan And Seek(Index/table)
Table Scan
SQL processes all rows in the table looking for a match
Index Scan
SQL processes all rows in the index looking for a match
Index Seek
SQL processes the leaf layers and leaf...
-
RE: date calculations
or
WHERE DATEDIFF(day,RemovedDate,GETDATE()) < 7
-
RE: EXEC & sp_executesql
As written you must use
EXEC sp_executesql
or do you mean that the sql works with EXEC but not sp_executesql ?
Trigger, yes sp_executesql will cache query plans but if I remember...
Viewing 15 posts - 2,506 through 2,520 (of 3,543 total)