Viewing 15 posts - 31 through 45 (of 152 total)
Sergiy (9/23/2016)
Smendle (9/23/2016)
I bolded and italicized the key word in the OP question
How do I initialise a sql variable to 0 in stored-procedure ?
Maybe the correct answer is "You...
September 24, 2016 at 5:14 am
This:
CREATE STORED PROC usp_MYPROC @MYVAR INT=0
Is NOT the same as either of these:
DECLARE @MYVAR INT;
SET @MYVAR = 0;
DECLARE @MYVAR INT = 0;
Lynn Pettis
but @MYVAR as a parameter can be...
September 23, 2016 at 11:04 am
Sergiy (9/22/2016)
Smendle (9/22/2016)
Eirikur Eiriksson (9/22/2016)
For a variable inside the procedure use this😎
DECLARE @MY_INT_VAR INT;SET @MY_INT_VAR = 0;
i could be confusing this with a .NET programming environment but doesn't that initialize...
September 23, 2016 at 5:23 am
Marios Philippopoulos (6/3/2010)
I tried using sp_configure and looking online, but, apparently, this is not as easy as...
September 22, 2016 at 2:32 pm
datsun (9/22/2016)
Gail,I can't tell if the XACT_ABORT is On or Off.
But the way to replicate auto rollback is this way:
This is probably not what your wanting but I don't...
September 22, 2016 at 1:07 pm
🙂
thanks for all the replies I am smiling now because of you guys(or gals)!
This is also why simple questions don't always have simple answers esp. for SQL.
So my question now...
September 22, 2016 at 12:12 pm
How to initialise a sql variable to 0 in stored-procedure which would work both in SQLServer 2005 & 2008 ?
The part I bolded above provides a default value for...
September 22, 2016 at 11:23 am
Eirikur Eiriksson (9/22/2016)
For a variable inside the procedure use this😎
DECLARE @MY_INT_VAR INT;SET @MY_INT_VAR = 0;
i could be confusing this with a .NET programming environment but doesn't that initialize the variable...
September 22, 2016 at 10:41 am
Michael L John (9/8/2016)
tshad (9/8/2016)
Just having a unique id to have one is not normally useful. What does it...
September 8, 2016 at 1:36 pm
Barcelona10 (9/8/2016)
Hi all,Recently following message appears in SQL Error log.Any ideas?
'Unsafe assembly 'microsoft.sqlserver.mpusqlclrwrapper, version=10.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil' loaded into appdomain 271 (mssqlsystemresource.dbo[runtime].352)
SQL Server 2008 R2
Thank You advance
I need to know...
September 8, 2016 at 1:21 pm
benkraiemchedlia (9/7/2016)
I have a SQL Server 2008 in Server 1 , where I have a job of loading flat file in Table.
the flat file which is a zip is...
September 7, 2016 at 10:13 am
Scott In Sydney (9/7/2016)
What I really need is a way to drop...
September 7, 2016 at 9:53 am
tmiller 90290 (8/31/2016)
September 1, 2016 at 7:17 am
It doesnt need sysadmin, but you do need to give the account you setup in SSRS configuration manager access to the virtual directory for the web service calls that SSRS...
August 29, 2016 at 8:17 am
I would try 2 things at this point.
1. Try using a password like 12345 (I know same as your luggage, haha never heard that one before) some FTP sites will...
August 29, 2016 at 5:26 am
Viewing 15 posts - 31 through 45 (of 152 total)