Viewing 15 posts - 3,151 through 3,165 (of 6,036 total)
REPLACE(STR(quantity, 4), ' ', '0')
January 29, 2008 at 5:44 am
SQL Server will always take as much memory as you allow it to take.
It uses it to cache execution plans, returned resultsets, derived tables, etc.
It does not erase it until...
January 28, 2008 at 4:31 pm
I am hoping to rewrite all this into 1 stored procedure using derived tables.
Any reason for this?
January 28, 2008 at 3:52 pm
Just in case @TblName has space or another special charachter:
exec('Select * from ' + QUOTENAME(@TblName) )
January 26, 2008 at 4:35 am
Chirag (1/25/2008)
what about using transactions ? then you can use GOTO .
OP already answered this question/
"If quit command GO, I can't use DDL commands, like ALTER FUNCTION and others."
CREATE...
January 25, 2008 at 5:24 am
You must have missed parameter -b.
January 25, 2008 at 5:07 am
When you run same query second time SQL Server does not actually execute it, it uses resultset stored in cache.
Try to run
DBCC FREEPROCCACHE
after 1st execution and run query...
January 24, 2008 at 3:12 pm
Yes, I understand it must be time SQL Agent needs to record job/steps history.
But isn't it too long?
On none of other servers it takes more than 1 second, even on...
January 24, 2008 at 2:11 pm
DECLARE
@KOD_1 SMALLINT,
@KOD_2 SMALLINT,
@KOD_3 SMALLINT,
@KOD_4 SMALLINT
SELECT
Field1 ,
Field2 ,
Field3 ,
Field5,
Field6,
Field7,
Field8,
Field12,
DBO.Fn_Get_something(Field4,Field9,Field10,Field11)
FROM table1 DBG WITH (NOLOCK)
JOIN table2 POL WITH (NOLOCK)
ON Field3 = table2.someField1 AND DBG.teudat_zeut = table2.someField2
AND table1.someField3 = table2.someField3
AND table2.someField4 =...
January 24, 2008 at 12:48 pm
Did you try to run scripts from osql?
January 24, 2008 at 12:38 pm
Backup database and if error happens during deployment restore the copy from backup.
January 24, 2008 at 3:39 am
Loner (1/23/2008)
You can use global temp table ##temp. However you will need to delete it after you are done, otherwise it will stay in tempdb.
Problem is OP needs
a table...
January 23, 2008 at 4:42 pm
I don't see what's your problem.
As soon as you allow users to shift the columns you don't care about datatypes. They all gonna be displayed as strings anyway.
Then nothing stops...
January 23, 2008 at 2:29 pm
Jeff Moden (1/18/2008)
Delimiter of "," (including the quotes) is perfect for "real" CSV instead of "comedy separated values".
Delimiter of "," is as good as '[' + @TableName + ']'.
Works almost...
January 23, 2008 at 2:15 pm
lucky (1/23/2008)
Hello Brett,Instead of writing a stored procedure why don't you convert the same to a function and return the count of downloads.
Because it will do 2 queries against...
January 23, 2008 at 7:01 am
Viewing 15 posts - 3,151 through 3,165 (of 6,036 total)