Viewing 12 posts - 121 through 133 (of 133 total)
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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
July 31, 2016 at 12:19 pm
. As a bit of a sidebar, the term "thunk" reminds me of the noise that performance frequently makes when an ORM incorrectly creates "interface code". BigGrin
I am...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
July 25, 2016 at 11:43 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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
July 23, 2016 at 3:03 pm
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 even weirder....
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
July 21, 2016 at 12:06 pm
how do you define the arguments of a stored procedure in ANSI/ISO? If by using variables, then that pretty much shoots portability in the face.
It is actually much...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
July 20, 2016 at 10:57 am
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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
July 19, 2016 at 7:59 am
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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
July 18, 2016 at 2:07 pm
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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
July 18, 2016 at 11:51 am
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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
July 17, 2016 at 7:12 pm
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,...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
July 14, 2016 at 10:52 am
-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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
July 13, 2016 at 9:07 am
-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....
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
July 12, 2016 at 7:18 pm
Viewing 12 posts - 121 through 133 (of 133 total)