Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rama_kavuri
Starting Member
4 Posts |
 Posted - 2014-06-25 : 01:49:58
|
| in an interview i have said that the functions are executed at the clients memory and stored procedures are executed at he server sideas long back i have read these on the differences between function and procedures on a web site now when i browse it is not visible may be my search mistakescan any body correct this give the links where i can find these |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-06-25 : 02:04:25
|
| As far as i know,both the functions and stored procedures are objects created on the database,so it is server side.you can say any adhoc query or dynamic sql used within the application as cleint side.Javeed Ahmed |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-06-25 : 02:17:25
|
EVERYTHING that is defined as T-SQL is executed at server side.Microsoft SQL Serve works with sets and can return data from the server to the client during the batch (collection of statements).
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
rama_kavuri
Starting Member
4 Posts |
Posted - 2014-06-25 : 02:18:57
|
| as per my knowledge functions gets recompiled at the client memory what ever small or a adhoc query or dynamic sql and by the thanks for the reply |
|
|
|
rama_kavuri
Starting Member
4 Posts |
Posted - 2014-06-25 : 02:21:00
|
quote:
Originally posted by SwePeso
EVERYTHING that is defined as T-SQL is executed at server side.Microsoft SQL Serve works with sets and can return data from the server to the client during the batch (collection of statements).
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
do they have sql statments |
|
|
|
rama_kavuri
Starting Member
4 Posts |
Posted - 2014-06-25 : 02:21:58
|
quote:
Originally posted by SwePeso
EVERYTHING that is defined as T-SQL is executed at server side.Microsoft SQL Serve works with sets and can return data from the server to the client during the batch (collection of statements).
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
sorry i am not that much expertise |
|
|
|
|
|
|
|
|
Functions and Procedures