Skip to main content

Handle Null Date values in Microsoft SQL Server

In an SQL Server View, a problem is that the DateTime field has many NULL values which is causing a problem with the parsing of the data in MSAccess.

How to I use CAST (or CONVERT) to handle Null Date values in my SQL Server view?

There is a way to use CAST or CONVERT similar to the nz type function in MSAccess to handle null date values but I can't remember the syntax.

What is happening now is that I get a data mismatch in my MSAccess function when it hits a Null Date value. Can I somehow use the ISNULL or ISDate function? I believe I need to somehow return "" instead of Null.


Read more »
Labels:

Comments

Post a Comment

Popular posts from this blog

What is .csp extension? C++ Server Pages

C++ Server Pages C++ Server Pages (CSP) is a Web Engine for advanced Web Application Development, that uses blended Markup Language / C++ scripts ( such as HTML/C++, XML/C++, WML/C++ etc.) Similar to ASP and JSP, it provides a great easiness in creating web pages with dynamic content, as well as complex business applications. However, instead of Java, Javascript or VBscript, it uses C++ . This brings some significant advantages: Incredibly high processing efficiency. Benchmarks have shown a range of 80 to 250 times higher processing speed than ASP. The use of pure C++ allows the use of tons of libraries that are currently available. It is important to notice that the libraries written in C++ are tens or hundreds of times more than in any other language. It is widely accepted that the most skilled programmers in the IT market are the C++ ones. However, CGI, ISAPI and other frameworks where C++ applies, do not provide the web developer with facilities for efficient app...
Post a Comment
Read more

Vertical Labels in iOS (using Objective-C)

View transformations are something you might wanna need to learn more about. While rethinking the iPad interface for his UTC Chart app, it occurred to mluton to use vertical labels. After a bit of research this is what he came up with. - (void)viewDidLoad { [super viewDidLoad]; NSString *string = @"Lorem Ipsum"; UIFont *font = [UIFont preferredFontForTextStyle:UIFontTextStyleHeadline]; UILabel *label = [[UILabel alloc] init]; label.font = font; label.text = string; CGSize size = [string sizeWithAttributes:@{NSFontAttributeName:font}]; label.frame = CGRectMake(40, 40, size.width, size.height); [label.layer setAnchorPoint:CGPointMake(0.0, 0.0)]; label.transform = CGAffineTransformMakeRotation((M_PI) / 2); [self.view addSubview:label]; } The frame and setAnchorPoint values can be modified to achieve desired positioning. He chose to bypass any potential autolayout/transform conflicts by creating the label progr...
Post a Comment
Read more