Navigant
Essa empresa é sua?
Pergunta de entrevista da empresa 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
Resposta da entrevista
Sigiloso
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