This Table Creation puzzle asks for an explanation before you run its code. I suggest examining the batch separators carefully.
MySQL OUT Parameter: IN, OUT and INOUT in Stored Procedures
A MySQL OUT parameter lets a stored procedure hand a value back to the caller through a variable. This post tests IN, OUT and INOUT on a small table, shows the error you get when you pass a literal, and compares the syntax with SQL Server.
How to Know If Index is Forced on Query? – Interview Question of the Week #246
Question: How to Know If Index is Forced on Query?
Answer: Let me tell you a brief story so you understand the context of the question.
Box Selection in SSMS: Four Edits With the ALT Key
Box selection in SSMS selects vertical text: hold the ALT key and drag the mouse across the text. This post shows four edits that the box makes quick: typing on many lines at once, deleting a column, pasting a column into a column, and moving lines with the arrow keys. Each result is a query that runs.
Select Vertical Text in SSMS: Alt Shift and Arrow Keys
To select vertical text in SSMS, hold Alt and drag with the mouse, or hold Alt and Shift and press the arrow keys. This post explains what a vertical selection does, how to edit many lines at once and how to turn a pasted column into an IN list. It also shows a T-SQL alternative for long lists.
SCHEMABINDING View: What You Can Change in the Table
A SCHEMABINDING view locks the columns it uses and leaves the other columns of the table free. This post tests which changes SQL Server blocks, shows the messages and lists the bound columns with a query. It also shows how to change a bound column inside one transaction.
What is SCHEMABINDING in SQL Server Views? – Interview Question of the Week #245
SCHEMABINDING keywords prevent tables used in the views to make any such modifications that can affect the view’s definition.







