Viewing 15 posts - 31 through 45 (of 156 total)
djj (10/3/2016)
So, I modified to...
October 12, 2016 at 9:22 am
venkyzrocks (9/26/2016)
I'm looking to call a web service (REST API/SOAP) doesn't matter through SSIS/Stored procedure. SSIS does have a web service call but it only accepts simple WSDL files...
September 28, 2016 at 7:01 am
thank you both for the clarification....
September 24, 2016 at 8:39 am
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
Viewing 15 posts - 31 through 45 (of 156 total)