No announcements
Found 1000729 threads
-
1 VotesIf Execute SQL task return value is Null, then what value will be assigned to Variable?
thus, null shouldn't be used as a return value: "When used with a stored procedure, RETURN cannot return a null value.Answered | 5 Replies | 7521 Views | Created by Venkataraman R - Thursday, January 22, 2009 10:58 PM | Last reply by Duane Douglas - Saturday, January 24, 2009 6:50 AM
-
1 Votes
Fast Way to Verify No Variables Are NULL
But since your test is just looking at some variables, any simeple way of doing it is likely to be equally efficient or so close that the difference is impossible to measure.Answered | 4 Replies | 3317 Views | Created by Ryan0827 - Friday, June 10, 2011 7:41 PM | Last reply by Kent Waldrop - Friday, June 10, 2011 8:02 PM -
0 Votes
Difference - @var is null , @var = null
in simple way to remind if you want to set NULL value into variable use equal sign, while in condition use IS ...Answered | 4 Replies | 946 Views | Created by HarSan Online - Friday, May 29, 2015 3:20 PM | Last reply by HarSan Online - Friday, May 29, 2015 4:12 PM -
0 Votes
SSIS package returns nulls
I suspect it is ignore failure in your case, which is populating NULL value for non match.Answered | 7 Replies | 2884 Views | Created by Ven Raja - Wednesday, July 17, 2013 2:31 PM | Last reply by Rajkumar5055 - Thursday, July 18, 2013 4:28 AM -
0 Votes
Action returning multiple rows
I have managed to sort the issue by including the Hierarchy dimension in the where clause of the Action.Answered | 2 Replies | 806 Views | Created by kiran jack - Wednesday, December 16, 2015 7:22 AM | Last reply by kiran jack - Monday, December 28, 2015 11:08 AM -
0 Votes
SCVMM slow performing actions
>I can't see any problem on the setup, network connectivit is OK, servers has enough resources and I can't see any of these overloaded (cpu+mem) Have you checked the disk ...Answered | 4 Replies | 1481 Views | Created by Pep M - Sunday, June 5, 2016 8:11 PM | Last reply by Elton_Ji - Monday, July 4, 2016 2:53 PM -
0 Votes
If No Rows Are Returned From Query Do Variables Always Equal NULL in SELECT
If you do a SELECT <variable name> = <expression> From <whatever> and <whatever> returns 0 rows, the the value of <variable name> will not ...Answered | 7 Replies | 5718 Views | Created by Ryan0827 - Thursday, June 9, 2011 7:26 PM | Last reply by Kent Waldrop _ - Friday, June 10, 2011 11:23 AM -
3 Votes
Return all rows when variable is null
You can use an anchor date, like '19000101' or '99991231' when those variables are NULL.Answered | 4 Replies | 6779 Views | Created by dkingston - Wednesday, March 30, 2011 4:32 PM | Last reply by dkingston - Wednesday, March 30, 2011 7:34 PM -
2 Votes
return a variable
Apparently an organizer is also a member, not a totally different kind of entity as you have shown!Answered | 5 Replies | 1803 Views | Created by Dave Parker - Monday, December 31, 2012 6:54 PM | Last reply by --CELKO-- - Monday, December 31, 2012 9:17 PM -
2 Votes
How to check if string variable is null?
I agree that NULL and an empty string are completely different, but unfortunately there is no way to handle this type of logic within the package, differentiate ...Answered | 8 Replies | 12707 Views | Created by BorkaS - Friday, February 1, 2013 11:22 AM | Last reply by BorkaS - Friday, February 1, 2013 3:40 PM -
1 Votes
comparing variables to null
Instead, it seems (at least one) recommended way is to use coalesce when comparing values in a where clause and both the variable/parameter AND the column might be ...Answered | 10 Replies | 1458 Views | Created by shiftbit - Tuesday, March 12, 2013 5:31 PM | Last reply by Naomi N - Wednesday, March 13, 2013 1:14 PM -
0 Votes
Issue with Sum on Null variable
One of the columns could have a NULL value, however I want to add code so that if NULL set to 0.Answered | 4 Replies | 3712 Views | Created by Armela - Tuesday, April 14, 2009 9:31 PM | Last reply by Isham H - Wednesday, April 15, 2009 2:49 AM -
0 Votes
You are not authorised to perform this action
Users that access a forum they do not have access to see "You are not authorized to perform this action.Answered | 6 Replies | 15134 Views | Created by Jako G - Tuesday, February 8, 2011 2:28 PM | Last reply by Jako G - Tuesday, May 31, 2011 7:39 PM -
6 Votes
@@servername returning NULL
If it returns NULL then MSCRMAsyncService won't start, your method allows servername to be returned instead of NULL, therefore MSCRMAsyncService ...Answered | 12 Replies | 56761 Views | Created by SQL AB - Thursday, March 9, 2006 7:33 PM | Last reply by Ronak391 - Wednesday, November 21, 2012 11:55 AM -
0 Votes
Return Null
In the last else case it will produce NULL (default).Answered | 2 Replies | 4599 Views | Created by Milli_22 - Monday, February 22, 2010 4:13 PM | Last reply by Naomi N - Monday, February 22, 2010 4:19 PM -
0 Votes
Returns a null
All Unwanted nulls are being returned.Answered | 4 Replies | 2445 Views | Created by remdev59 - Wednesday, November 16, 2011 2:23 PM | Last reply by remdev59 - Wednesday, November 16, 2011 2:58 PM -
1 Votes
return null
@outputStuff ------------ NULL */Answered | 8 Replies | 4609 Views | Created by nofriends - Wednesday, February 25, 2009 8:16 PM | Last reply by nofriends - Thursday, February 26, 2009 9:07 AM -
0 Votes
Return variable problem
If you want to understand PowerShell as a language, I recommend Bruce Payette's book "Windows PowerShell in Action".Answered | 12 Replies | 3738 Views | Created by pbbergs [MSFT] - Friday, November 19, 2010 3:13 PM | Last reply by pbbergs [MSFT] - Monday, November 22, 2010 2:54 PM -
2 Votes
parameters return null
Try: ALTER PROCEDURE dbo.InsertStudent ( @StudentFirstName nvarchar(MAX), @StudentLastName nvarchar(MAX), @StudentNumber ...Answered | 5 Replies | 3592 Views | Created by mortaza.mkr - Sunday, May 6, 2012 10:13 PM | Last reply by mortaza.mkr - Wednesday, May 9, 2012 5:08 PM -
0 Votes
Repeating Code with different variables
Using scalar udf may hurt your performance.Answered | 2 Replies | 3522 Views | Created by zzpluralza - Wednesday, October 13, 2010 1:46 PM | Last reply by zzpluralza - Wednesday, October 13, 2010 2:10 PM - Items 1 to 20 of 1000729 Next ›
No announcements
