Click here to Skip to main content
12,696,493 members (30,854 online)
Rate this:
 
Please Sign up or sign in to vote.
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 11-Jun-12 22:49pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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)
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

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[^]
  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.170118.1 | Last Updated 31 Aug 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100