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.
Remove Completion Time From the SSMS Messages Tab
To remove completion time from the Messages tab in SSMS, clear one check box in the options. This post gives the exact steps for SSMS 22, explains why no T-SQL setting controls the line and says why old query windows keep showing it. It also shows how to print a time yourself, when a script needs one.
SQL SERVER – Installation Error: 25641- For target, “package0.event_file”, the parameter “filename” passed is invalid. Target parameter at index 0 is invalid
While installing SQL Server 2012 in a client environment, they faced an interesting error about for target. Here is the information that is taken.