Techaray

Shailendra Saxena's Technical Blog

Using Case in Sql Server when Date is Null

clock October 28, 2013 05:03 by author ShailendraSaxena

Using Case in SQL server when Date is null

 

CASE WHEN mst.ms_termdt IS NULL
    THEN  DATEDIFF(HH,mst.ms_tscheddt,getdate())
    ELSE DATEDIFF(HH,mst.ms_termdt,getdate()) END AS Time_From_Install
FROM tblmaster mst



What is Web API

clock October 9, 2013 22:39 by author ShailendraSaxena
What is Web API Web API is lightweight.Highle interoperable and works on HTTP.It can be used by the range of lceints like mobiles,iphones tablests etc. It has featrues like routing,controllers action results, filter etc. WebAPI is an ideal platform for building pure HTTP based services where the request and response happens with HTTP protocol. The client can make a GET, PUT, POST, and DELETE request and get the WebAPI response appropriately. The WebAPI is • An HTTP Service • Designed for broad reach • Uses HTTP as an Application protocol, not a transport protocol


Search

Calendar

<<  June 2017  >>
SuMoTuWeThFrSa
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

Archive

Tags

Categories


Visitors

FlagCounter

Flag Counter

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2017

Sign In