Asp.net programming we consider all important topic for knowledge about controls,web Services, JSON, Ajax, database, and interview related Question. In this Asp.net and sql server tutorial blog we give many examples of jquery as like How Play YouTube Video in Your Asp.net Website by URL, How to Play YouTube Videos in Asp.net by using Jquery , Jquery Change div background on mouseover in asp.net , JQuery UI Datepicker (Calendar) etc.

Wednesday, November 13, 2013

Sql Query for asp.net Programming

Sql Query for asp.net :

 some time some sql Query is very important for sql programmer and asp.net programmer .it is very easy but logical .in this post we describe some ,and thing its use full for programming .
1          1 .  ) Compare date in SQL data base to current date by sql query

           select ManagementID, from [abc] where CONVERT(nvarchar(10),date,103)=convert(nvarchar(10),GETDATE(),103)       


·         2. )  Get only date form SQL  data base which is store in to date data type


asp.net Programming

·        


                          Select convert(date,GETDATE(),103)as a from [table name]


·         3 .) Select current date form sql query

     select convert(date,GETDATE(),103)as a



·         4 .) select current date time by SQL Query