GO vs Semicolon(; ) Terminator, Batch Terminator vs Statement Terminator, , Tech Point Fundamentals

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 SEMICOLON (; ) 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