Show Current Date-
Show Current Date Then Use-
SELECT GETDATE() AS CurrentDate
OutPut-
2016-06-08 12:11:00.083
More Format In Date Then Use-
Ex. 1:
SELECT CONVERT(varchar(20),GETDATE(),100) AS CurrentDate
OutPut-
...
Popular Posts
-
Microsoft had introduced ASP.NET MVC in .Net 3.5,since then lots of new features have been added.The following table list brief history of...
-
Types of list in html We define any defination and content in list form then we give order and unorder. Basically 3 types of lis...
-
The SQL LIKE Operator In this Article describe Like Operator. The SQL LIKE clause is used to compare a value to similar values usin... -
There are various positive points to Using MVC 1. TDD support out of the box as most of the design is based on interfaces. 2. SEO fr... -
INSERT INTO SELECT Statement In this article describe about Insert data one table to existing table The INSERT INTO SELECT stateme... -
Show Current Date- Show Current Date Then Use- SELECT GETDATE() AS CurrentDate OutPut- 2016-06-08 12:11:00.083 ...
-
Sql Select Query SQL Select all data from Table as you can see in my previous Article http://learningmvctutorial.blogspot.in/2017/0...
-
What is Group By clause ? In this Article Group by clause use in Select query in Sql Server when you fetch data with collection on b... -
Text Editing You can edit text easly in html using many predefine tags. HTML also defines special elements and tags for defining tex...
-
Advantages Faster development Unit of work pattern (context) Auto-generated domain objects that are usable small projects Lazy loadin...