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-
...
Wednesday, 15 November 2017
Monday, 16 October 2017
Except vs NotNull in Sql Server
EXCEPT & INTERSECT command in SQL Server
EXCEPT
In this Article EXCEPT command use to commind two queries and find dinctinct records.
EXCEPT returns any left query values which are not exist in right query.
You can use Except command and easily find distinct value of one table when you want filter...
Sunday, 1 October 2017
Sql Commands
Sql Select Query
SQL Select all data from Table as you can see in my previous Article
http://learningmvctutorial.blogspot.in/2017/03/sql-select.html
Insert Query
In SQL Server you can use Insert data in table help of Insert Query
Syntax
INSERT INTO TableName(ColumnName1,ColumnName2,ColumnName3) VALUES(@value1,@value2,@value3)
...
Sunday, 24 September 2017
INSERT INTO statement in SQL
INSERT INTO SELECT Statement
In this article describe about Insert data one table to existing table
The INSERT INTO SELECT statement selects data from one table and inserts it into an existing table.
Example
In this article...
Sql Like Operator
The SQL LIKE Operator
In this Article describe Like Operator.
The SQL LIKE clause is used to compare a value to similar values using wildcard operators.
The LIKE operator is used to search for a specified pattern 'start letter...
Thursday, 21 September 2017
Html Formatting
Text Editing
You can edit text easly in html using many predefine tags.
HTML also defines special elements and tags for defining text with a special meaning.
Using those type of Formatting elements like-
<b> - Use this element to bold text
<strong> - This is also same bold tag but give Important text
<i> - Use...
Wednesday, 20 September 2017
SQL Group By Clause
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 basis particular unique field then use Group by Clause.
Group by clause with where condition and...
