T-SQL
Transact-SQL
Transact-SQL
Transact-SQL (T-SQL) is the procedural SQL language used by Microsoft SQL Server
For Transact-SQL make particular note of the concepts behind SmartDB/PinkDB
Controlling output format
Controlling output format
When you run a query you will, by default get a rowcount at the end of the result set...
(50 rows affected)
To stop this appearing, use...
SET NOCOUNT ON
In SSMS you can choose whether output is returned in text format (Ctrl-T), grid format (Ctrl-D), or to a file (Ctrl-Shift-F). Or, click the icons on the ribbon...
Bibliography
Bibliography
https://www.red-gate.com/simple-talk/sql/sql-tools/the-ultimate-excuse-database/https://www.red-gate.com/simple-talk/blogs/weighted-randomization-in-t-sql/http://bradsruminations.blogspot.com/2009/08/all-any-and-some-three-stooges.htmlhttps://www.brentozar.com/archive/2021/05/signs-your-t-sql-might-fail-a-code-review/https://www.brentozar.com/archive/2022/05/the-6-year-old-t-sql-book-that-never-goes-out-of-style/
https://sqlperformance.com/2020/09/locking/upsert-anti-patternhttps://docs.microsoft.com/en-us/sql/t-sql/statements/set-nocount-transact-sql
Unicodehttps://stackoverflow.com/questions/10025032/what-is-the-meaning-of-the-prefix-n-in-t-sql-statements-and-when-should-i-use-it
SQL Server 2022https://chadbaldwin.net/2022/06/02/whats-new-in-sql-server-2022.html