Skip to navigation
How to give in a mssql query NULL other name
16.05.15
example: SELECT p.[mh2_code_price_list] ,p.[mh2_style_code] ,p.[mh2_from_qty] ,p.[mh2_price] ,ISNULL(s.av0_code, 'NEW_NAME') AS av0_code FROM [SL].[dbo].[mh2_price_list_ln] AS p LEFT JOIN [SL].[dbo].[av0_style] AS s ON p.mh2_style_code = s.av0_style
http://www.peter-urda.com/2010/11/handling-null-values-in-mssql-queries
Reply
Anonymous
Information Epoch 1778967668
Worse is better.
Home
Notebook
Contact us
