SQL

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

SQL Interview Questions and Answers

SQL

Post Views: 629  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: 372  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 […]

Tech Contents © 2016
Inline
Inline