employer cover photo
employer logo

Question d’entretien chez Navigant

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

Réponse à la question d'entretien

Utilisateur anonyme

15 août 2017

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