4 ms·
"T-SQL" - in reality, everyone just refers to it as SQL Server even though it's obviously not a language. I find this syntax super helpful: DECLARE @someName
by throw1234651234 6y ago
"T-SQL" - in reality, everyone just refers to it as SQL Server even though it's obviously not a language.
I find this syntax super helpful:
DECLARE @someName AS VARCHAR(100)
SET @someName= 'Bob'
When coupled with SPs and Functions, you can write some fairly readable logic in SQL. I am completely against this for most applications, but when you need it, it helps.
- dvdkon 6y agoOh, alright. I know T-SQL and have actually missed variables in PostgreSQL before. Just please don't shorten it to "SQL", it's only one dialect of many.
- dragonwriter 6y ago> have actually missed variables in PostgreSQL before You can just use a DO-block with plpgsql (or any other installed procedural language) code to make variables available in Postgres. T-SQL just somewhat elides the distinction between declarative and procedural code. https://www.postgresql.org/docs/current/sql-do.html https://www.postgresql.org/docs/current/sql-do.html