471,049 Members | 1,401 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Why is it called Stored Procedure instead of Stored Sets?

Since RDMBS and its language SQL is set-based would it make more sense
to call a given stored process "Stored Sets" instead of current
theorically misleading Stored Procedure, as a measure to prod
programmers to think along the line of sets instead of procedure?

Jul 23 '05 #1
4 1147
You are not storing a set; you are storing a procedure which hopefully
works on a set. A stored procedure is a chunk of logic, not of data.
I vote that the name is right. Not that your or mine opinion matters
on this. MS and other vendors made their naming decision years ago and
I cannot see any of the major RDBMS vendors chaning their terminology.

IMHO -- Mark D Powell --

Jul 23 '05 #2
A stored procedure contains procedural code, not declarative set-based
code. Although the individual statements in the proc may or may not be
set-based ones.

--
David Portas
SQL Server MVP
--

Jul 23 '05 #3
"A stored procedure is a chunk of logic, not of data. "
TUS (Totally Unnecessary Statement).

What's inside that chunk of code could be procedural or could be
set-based. I was thinking loud or talking loud for that matter, not
intended to call for a change of its naming convention.

Jul 23 '05 #4
They are procedural; a stored set is a table.

Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Mónica | last post: by
8 posts views Thread by Thomasb | last post: by
6 posts views Thread by Wojciech Wendrychowicz | last post: by
1 post views Thread by peaceburn | last post: by
reply views Thread by SOI_0152 | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.