Login
Home
KB
Snippets
Current Articles
|
Archives
|
Search
16
Replace Null or Empty Value with String
posted on September 16, 2014 06:28
Select ISNULL(NULLIF(GIBS_FBLineItems.ReportType, ''), '--Undefined--') as ReportType from GIBS_FBLineItems
Posted in:
SQL Scripts
,
SQL Server 2008 R2
,
Stored Procedures
Actions:
E-mail
|
Permalink
|
Comments (0)
Related Articles
SQL Timeout on Custom DNN module
Try running . . . . exec sp_updatestats;
Alter Table - Setting a Column Default Value
ALTER TABLE MyTableName ADD CONSTRAINT DF_MyTableName DEFAULT GETDATE() FOR MyColumnName
Formatting a Short Date in SQL using Convert Function
To format a short date like MM/DD/YY try the following: select CONVERT(VARCHAR(8), GETDATE(), 1) as MyShortDate For a complete guide to ...
Post Rating
1
2
3
4
5
Comments
There are currently no comments, be the first to post one!
Post Comment
Name (required)
Email (required)
Website
Notify me of followup comments via e-mail