Collection of Articles and Posts on SQL Server , SQL Server Professional must read these Articles and Posts, these also includes some questions mostly ask by interviewer,

SQL Interview Questions and Answers


Post Views: 1,601  Here is some important SQL Interview Questions and Answers, these SQL Interview Questions and Answers may be help in your interview round.   SQL Interview Questions and Answers   What are difference between DELETE & TRUNCATE commands? Delete command removes the rows from a table based on the condition that we can write WHERE clause […]

What are difference between the temp table and table variable in SQL Server?

Post Views: 891  Temporary Variables: 1) The temp table can be created using the #sign and table name. — Create Temporary TableCREATE TABLE #Employee (Id INT, Name VARCHAR(50)) –Insert Two rows INSERT INTO #Employee VALUES(1,’Ram’) INSERT INTO # Employee VALUES(2,’Karan’) –Retrieve the records from temp table SELECT * FROM #Employee –DROP Temporary Table query DROP […]

All Rights Reserved 2019 | DesignzRush (OPC) Pvt. Ltd.