Navigant Interview Question: SQL Features of SQL 2016 Trig... |

Interview Question

Dot NET Developer Interview

SQL Features of SQL 2016 Triggers Joins-Inner,Outer,Left

  Outer,Cross delete vs truncate Ranks Dense Stored procedure and functions Identity, Scope_Identity Primary and unique key (how many we can have) Clustered and Non-clustered working in temp tables local and global varibales Union and Union all removing duplicates in a table CTE-advantages table varibales pivot tables creating temp tables

Interview Answer

1 Answer



 Features of SQL 2016

 Joins-Inner,Outer,Left Outer,Cross
 delete vs truncate
 Stored procedure and functions
 Primary and unique key (how many we can have)
 Clustered and Non-clustered
 working in temp tables
 local and global varibales
 Union and Union all
 removing duplicates in a table
 table varibales
 pivot tables
 creating temp tables

Interview Candidate on Aug. 14, 2017

Add Answers or Comments

To comment on this, Sign In or Sign Up.