GO vs Semicolon(;) Terminator | Batch Terminator vs Statement Terminator | #TechPointFundamentals

GO vs Semicolon(;) Terminator | Batch Terminator vs Statement Terminator | #TechPointFundamentals Agenda: -------------- Q01. What is the difference between GO and Semicolon(;) Terminator in SQL? Q02. Is GO terminator a SQL Keyword or SQL Command? Q03. When semicolon(;) terminator is mandatory in SQL? Q04. Can a MERGE statement exist without a semicolon(;) terminator statement? Q05. When GO terminator is mandatory in SQL? Q06. Can you use the TempTable and TempTable variables after the GO statement? Q07. Can you use a semicolon(;) after GO statement? Q08. Can you use any other word for batch separator in SQL? Q09. What will happen if you do not use the EXEC keyword before any system stored procedure? Q10. Can you use GO in a stored procedure, trigger, or View? SEMI-COLON (;) is mandatory: 1. MS SQL 2005: CTE and Service Broker Statements 2. MS SQL 2008: MERGE Statement 3. MS SQL 2012: THROW statement 4. EXEC command before the system stored procedu