Fragen im Vorstellungsgespräch bei Navigant: SQL Features of SQL 2016 Trig... | Glassdoor.de

Frage im Vorstellungsgespräch

Dot NET Developer-Vorstellungsgespräch

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
Antwort

Antwort im Vorstellungsgespräch

1 Antwort

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

Bewerber im Vorstellungsgespräch am 14.08.2017

Antwort oder Kommentar posten

Um dies zu kommentieren, bitte anmelden oder Konto anlegen.