MS SQL Differences for Dot net Interview
1. Difference between Primary key and Unique key. Primary Key Unique key to create unique identifier. to create uniqueness in a column. only one primary key allowed. multiple unique key allowed. don't allow null value. allow one null value. creates clustered index on a column. creates non clustered index on a column. 2. Difference between stored procedure and Functions. Stored Procedure Functions We can call function in SP. We can't call SP in Function. Can't call with Select statement. Can call with select statement. we can write DDL and DML commands in SP. We can write only Select statement in SP. Return value is optional. must Return a value. supports try catch. don't support try catch. supports truncation statements. don't support transaction statements. can have in...