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...
Monday, 16 October 2017
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)
...
