on 08-09-2015 6:28 AM
We can achieve everything through information views, then in which scenarios we will create stored procedure?
Thanks
No, you can't. And in these cases you use stored procedures.
Keep in mind that scripted calculation views are also just stored procedures.
- Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am not sure what you are really asking here.
There is a lot what you could do with SQL or the semantics that information views provide.
But sometimes writing procedural code is clearer or more efficient or easier or all of the just mentioned things together.
It's another tool in your toolbox.
Sometimes you like to have a chisel even though you could whack a hammer against your screwdriver...
- Lars
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.