In order to be more precise. What is the definition of Statement, Function, Clause? How can I distinguish them? For my understanding Statements are the standard SQL Statements (select, insert, update, delete, create, drop, truncate...) and clauses are like switches for those statements (like ON EXISTING UPDATE). Functions could be standard SQL Functions (aggregate, string, datatype conversion....), or could be Sybase specific system procedures, but here what is the difference between procedures starting with xp or with sa or with sp Could you please correct me? |
Here's my point of view:
2
Volker is pretty much spot on. Re: or "xp_" for extented procedures xp - external procedures (procedures that interact with the external world, like the command shell, mail, environment, etc.). Statements generally fall into two categories, DDL - data definition language and DML - data manipulation language.
(24 Mar '20, 09:18)
JBSchueler
|