Re: Views vs Stored Procedures, whats the difference?

On 27 Jan 2006 06:19:03 -0800, mooreit wrote:

>The purpose for my questions is accessing these technologies from
>applications. I develop both applications and databases. Working with
>Microsoft C#.NET and Microsoft SQL Server 2000 Production and 2005 Test
>Environments.
>
>What is the purpose of a view if I can just copy the vode from a view
>and put it into a stored procedure?
>
>Should I be accessing views from stored procedures?
>
>Should I use views to get information? and Stored Procedures for
>Inserts, Updates and Deletes?
>
>What are the performance differences between the two?
>
>Thank you for any and all information.
>
>SBProgrammer

Hi SBProgrammer,

I wrote about the differences between stored procedures and views ten
days ago. Here's a link to the article on Google (warning - long URL,
might wrap)

http://groups.google.com/group/microsoft.public.sqlserver.newusers/browse_frm/thread/b20d4abdede81ada/75cc4092b8603807?lnk=st&q=view+stored+procedure+author%3Ahugo+author%3Akornelis&rnum=1&hl=en#75cc4092b8603807

--
Hugo Kornelis, SQL Server MVP
.

Relevant Pages

  • Views vs Stored Procedures, whats the difference?
    ... I develop both applications and databases. ... Microsoft C#.NET and Microsoft SQL Server 2000 Production and 2005 Test ... What is the purpose of a view if I can just copy the vode from a view ... Should I be accessing views from stored procedures? ...
    (comp.databases.ms-sqlserver)
  • Re: Migrating away from MS-Access
    ... Even .net applications can be better prototyped in access first. ... move the backend to sql server but do this in a smart way. ... You raised a few questions, which I beg to ask, im short on time at the moment...I havent looked at reporting services before...the current vb.net app thats attacheddoesnt use stored procedures its just hardcoded sql statements. ...
    (comp.databases.ms-access)
  • Re: Accesing data from many applications.
    ... applications that are developed in house. ... Do you know if in sql server I can restrict wich applications can be ... I assume here that your applications are not using stored procedures, ...
    (microsoft.public.sqlserver.security)
  • RE: Long Object Names
    ... Migrating Oracle Databases to SQL Server 2000 ... This article is for developers of Oracle applications who want to convert ... their applications to Microsoft SQL Server 2000. ...
    (microsoft.public.sqlserver.programming)
  • Re: errors calling linked oleDB server stored procedures
    ... You could have a try on registering COM in SQL Server. ... SQL Server provide such stored procedures to call ... instance of Microsoft SQL Server. ... which is used to set a property of an OLE object to a new ...
    (microsoft.public.sqlserver.programming)