Navigant Interview Question: SQL Features of SQL 2016 Trig... | Glassdoor.co.in

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
Answer

Interview Answer

1 Answer

0

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

Interview Candidate on 14-Aug-2017

Add Answers or Comments

To comment on this, Sign In or Sign Up.