No announcements
Found 3053496 threads
-
0 Votesis it possible to replace ISNULL with some other data types?
Yep.. so far as other type can be implicitly converted to first datatype.Answered | 7 Replies | 1059 Views | Created by Baraiya Kirit - Friday, June 27, 2014 6:10 AM | Last reply by Kalman Toth - Friday, June 27, 2014 11:55 AM
-
0 Votes
Can the rowversion data type be replaced by isolation levels?
The article show you some exersize on the issue.Answered | 6 Replies | 1579 Views | Created by LorenZ_DA - Friday, September 5, 2014 10:15 PM | Last reply by Jesús López - Monday, September 8, 2014 5:37 PM -
0 Votes
isnull variation
I'm not sure what you are trying to do, from what you said it won't return any rows because the ISNULL replaces any NULL values in FIELD2 with 0 and as you said it has NULLs and so ...Answered | 3 Replies | 1399 Views | Created by District9 - Thursday, April 25, 2013 11:35 PM | Last reply by Naarasimha - Friday, April 26, 2013 1:45 AM -
0 Votes
Bug in isnull() function
This is mainly an issue for us because we are migrating from Sybase to SQL Server - the isnull function in Sybase behaves just like it does in SQL Server when dealing with numeric datatypes ...Answered | 4 Replies | 7371 Views | Created by David Solomon - Metis - Thursday, November 17, 2011 7:32 PM | Last reply by Ray Rankins - Thursday, November 17, 2011 9:16 PM -
1 Votes
ISNULL -- Sort Of
If there is more than one COLUMN (or even if there is only one), you can use an aggregate FUNCTION: SELECT ISNULL(MAX(a), 'whateveriwant'), ...Answered | 11 Replies | 4535 Views | Created by Jay Mazz - Tuesday, August 4, 2009 10:07 PM | Last reply by Brian Tkatch - Wednesday, August 5, 2009 12:09 PM -
1 Votes
isnull function on numeric fields
Hi, The replacement value should be the type that is implicitly convertible to the type of check expression.Answered | 4 Replies | 10246 Views | Created by PHounshell - Monday, August 10, 2015 3:46 PM | Last reply by Sethu Madhavan R - Tuesday, August 11, 2015 6:34 AM -
1 Votes
ISNULL not work
Provide a screenshot of the data returned SELECT *, LEN(value1), len(value2) from ...Answered | 8 Replies | 2532 Views | Created by SQLServerLearning - Wednesday, April 11, 2012 2:31 PM | Last reply by SQLServerLearning - Wednesday, April 11, 2012 3:14 PM -
0 Votes
How to replace content in text data type?
The data is maintained in text data type column.Answered | 3 Replies | 2423 Views | Created by Lakshmi Narayana A - Wednesday, March 26, 2014 9:14 AM | Last reply by Visakh16 - Wednesday, March 26, 2014 9:57 AM -
1 Votes
ISNULL(DISTINCT...
Not sure exactly what you are looking for, perhaps something like Select Distinct IsNull(MyColumn, 'n/a') From MyTable If not that, could ...Answered | 5 Replies | 8603 Views | Created by PSULionRP - Monday, March 11, 2013 5:31 PM | Last reply by PSULionRP - Monday, March 11, 2013 5:55 PM -
1 Votes
IsNull From Multi Column
Could you please analyze the execution plan and share if possible?Answered | 7 Replies | 931 Views | Created by deppsos85 - Wednesday, May 13, 2015 10:06 AM | Last reply by SQLZealots - Wednesday, May 13, 2015 12:10 PM -
1 Votes
ISNULL Confusion
Aplogies SQLUSA, I've missed some of your posts where you've gone back and edited them to provide an answer.Answered | 34 Replies | 6607 Views | Created by Ye11ow - Thursday, February 25, 2010 1:22 AM | Last reply by Ye11ow - Tuesday, March 2, 2010 2:35 AM -
0 Votes
Derived Column transform to check ISNULL on multiple columns?
yes, i already thought about that, but i have a case where i have a lot of other derived columns (some based on package variables), and was hoping to have all the ...Answered | 4 Replies | 5079 Views | Created by wdww - Friday, May 31, 2013 6:48 PM | Last reply by wdww - Friday, May 31, 2013 7:56 PM -
1 Votes
SQL : Concat with ISNULL
One more solution, based on the assumption that the data type is int: SELECT 9999*10000 + isnull(colA, 0) Erland Sommarskog, SQL Server MVP, ...Answered | 5 Replies | 1732 Views | Created by kkran - Wednesday, July 29, 2020 10:37 PM | Last reply by Erland Sommarskog - Thursday, July 30, 2020 9:27 AM -
2 Votes
ISNULL not working???
If you want to extract NULL components, you need to run this: SELECT ISNULL(Component,'UNKNOWN') FROM Components WHERE Component IS ...Answered | 6 Replies | 10955 Views | Created by soldierfc - Tuesday, December 13, 2016 2:53 PM | Last reply by spaghettidba - Tuesday, December 13, 2016 4:01 PM -
0 Votes
ISNULL Function
CASE WHEN could also behave like ISNULL, like others said, you could firstly set another parameter to check either it passes down the Date, Null or nothing, then ...Answered | 21 Replies | 1455 Views | Created by Richard I Evans - Tuesday, May 19, 2020 3:07 PM | Last reply by Jeff Williams 3188 - Wednesday, May 20, 2020 9:19 PM -
0 Votes
ISNULL not working in my derived column
ISNULL([1]) ?Answered | 7 Replies | 1863 Views | Created by Basti087 - Thursday, May 7, 2015 10:37 AM | Last reply by RyanAB - Monday, May 11, 2015 2:01 AM -
0 Votes
Replace foreach with Parallel.ForEach - some questions
I'm working now on some app which read/parse data from stream.Answered | 1 Replies | 5978 Views | Created by BDA DVB - Sunday, November 14, 2010 1:19 AM | Last reply by Jaki Chan - Sunday, November 14, 2010 9:58 AM -
2 Votes
Is It Possible to Test for Data Type in an Expression?
However, it looks like it is not possible to check the data type programmatically.Answered | 6 Replies | 1568 Views | Created by Adam Quark - Tuesday, December 10, 2019 5:51 PM | Last reply by Adam Quark - Tuesday, December 17, 2019 1:02 PM -
0 Votes
isnull is not working in sql server
Are you sure its actual NULL and not string NULL ('NULL') Try this too select ISNULL(NULLIF(price,'NULL'),0) price from ...Answered | 2 Replies | 1370 Views | Created by sheshagiripattar - Tuesday, October 21, 2014 7:17 AM | Last reply by Visakh16 - Tuesday, October 21, 2014 7:30 AM -
0 Votes
Wanted to replace some values in other sheets
You can do a loop if it is the same cell on all other sheets, or name the cells individually if different cells are used.Answered | 1 Replies | 416 Views | Created by Firoj Awate - Tuesday, March 8, 2016 6:34 AM | Last reply by AndyColRomsey - Tuesday, March 8, 2016 10:56 AM - Items 1 to 20 of 3053496 Next ›
No announcements
