Click here to Skip to main content
15,851,902 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hi friends ,I m a beginner in Programming.I have some doubt

1)can we create a stored procedure which is not compiled?
2)can we create compiled queries with out using stored procedure?
3)DML operation is possible in view?

PLZ help
Posted

1)no
2)ya through user defined functions .....but most of the time we perfer store procedure not the function because udf acts for single item.well store procedure acts for group or can be single.

3)ya i not know much about it much i'm pretty sure we can update view(dml opertion)
 
Share this answer
 
Storedprocedure is compiled when it is run for the first time,
Then it is uses the cache for the next run. If you want to compile it on each call we could give WITH RECOMPILE option. This is will reduce the performance since the excution plan is created always.

For DML on views there are some restrictions please check
http://msdn.microsoft.com/en-us/library/ms187956.aspx[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900