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 |
|
nicky_river
Yak Posting Veteran
55 Posts |
 Posted - 2010-10-16 : 04:11:04
|
| Hi,Does anyone know where are cursors stored in SQL server database ?andwhat is the difference between a view and trigger ? |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-16 : 05:00:11
|
| It's like asking where are loops stored in programming languages & as far as difference between view & trigger is concerned there has to be at least some similarities between them so that you can find the differences.If you need the definitions BOL is your best friend...PBUH |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-10-16 : 16:42:54
|
| wow...they are getting ready for a test or interview...They are ALL stored in the database and take up spaceNow, if you want to discuss where the results are store when called, they are also stored in memory......that is only when they are called..You also must understand that cursors are objects that must be destroyed...and will be when the thread is closed...Now...Can I get a biggie fries with that?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxWant to help yourself?http://msdn.microsoft.com/en-us/library/ms130214.aspx |
|
|
|
|
|
|
Regarding Cursors