Navigant
Is this your company?
Navigant interview question
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
Anonymous
SQL Features of SQL 2016 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