Call vs Query vs Transaction

Can someone give me a good description of what a Call, Query, and Transaction are?  I cannot find anything that really tells me what the difference is
Who is Participating?
brejkConnect With a Mentor Commented:
Call - I think this is a synonym of stored procedure execution (stored procedure is a named set of SQL or CLR code stored on the server and called by users using EXECUTE statement).

Query - my definition is the following: query is a SQL statement (some people use the word "query" only when they are talking about SELECT statement).

Transaction - is a set of operations (SQL statements) executed as a whole (it means that when something goes wrong in transaction the whole transaction is rolled back - there are no changes in a database).

I hope my definitions will give you some light on the matter.
David ToddSenior DBACommented:

A transaction is SQL has a very specific meaning - see here for instance:

Can you give us some more background on how those words have been used, in where you need the clarification?

All Courses

From novice to tech pro — start learning today.