Yes, lots of them. I am scared of SQL injection (https://xkcd.com/327/), but more than that, procedures make portability much easier. If I have done a good job, and...

This actually hAS a lot of problems. A table hAS to have a key, but what you posted hAS no key, and can never have a key. Essentially what you...

I am...

>> I understand and appreciate all of that but it still evades the basic question. How are the variables that are used to define the arguments for a stored procedure...

The bit and varying bit datatypes were deprecated in SQL: 2003 for good reasons. You can read some of this: https://www.simple-talk.com/sql/t-sql-programming/bit-of-a-problem/.

In the case of SQL Server. It is...

It is actually much...

Maybe I missed the question, but SQL/PSM is how the ANSI/ISO standards handle procedures and functions. Also triggers, God help us.

As an aside, the "parameter versus argument" distinction...

You can get a full or near full implementation of the PSM in DB2, PostgreSQL, MySQL, Mimer and a few other products.

The SQL/PSM was primarily written by a guy...

I think this is a false analogy. Numbers are numbers and your arguing the interface (infix versus RPN) somehow makes them different. I also think that cursor argument your client...

I attended an IBM briefing on analytic functions in version 11 of DB2 last week. Part of the presentation consisted of showing TBC analytic benchmarks, which are some pretty complicated...

Ignoring how accurate self-evaluation is (Dunning–Kruger effect), let us assume that you are good at language L1 as well as SQL. Within your shop, the CLRs are written languages L1,...

-1 is a wonderful answer. Mixed systems (those with more than one language embedded in each other) are always inefficient and a nightmare for anyone to read or maintain. Converting...

-1 is a wonderful answer. Mixed systems (those with more than one language embedded in each other) are always in efficient and a nightmare for anyone to read or maintain....