Posts
689
Comments
563
Trackbacks
1
<< Debugging Local Web Services | Home | Adobe Creative Suite 3 - Internal Error 2739 >>
T-SQL: Null in views

If you define a null in a view for a column (so, you always want to pass null for whatever reason), if you don't cast it, it will default to an int data type.

To get around it, do something like:

cast(isnull(columnName, 0) as varchar(8)) as columnName

posted on Monday, April 09, 2007 3:01 PM
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 4 and 5 and type the answer here: