Re: Views vs Stored Procedures, whats the difference?

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

The difference between a view and a stored procedure is exactly what the names say. With a view, you can define a select-query that retrieves specific information from one or more tables (a stored select-statement). A stored procedure can do much more: it can run multiple sql-commands, has control-of-flow statements and accepts parameters. Also, giyf: http://www.google.be/search?q=view+vs+stored+procedure

Stevel
.

Relevant Pages

  • Re: Views vs Stored Procedures, whats the difference?
    ... I develop both applications and databases. ... Working with Microsoft C#.NET and Microsoft SQL Server 2000 Production and 2005 Test Environments. ... and put it into a stored procedure? ... By contrast a procedure is a server side extension of your client application. ...
    (comp.databases.ms-sqlserver)
  • Re: Using DBI to retrieve exit code of stored procedure
    ... I'm using DBI to connect via ODBC to Microsoft SQL Server 2000. ... > I wish to execute a stored procedure and return the exit code of the stored ... The stored procedure only returns 1 numerical value. ... -- (Posted from an account used as a SPAM dump. ...
    (comp.lang.perl.misc)
  • Re: Accepting wildcards like % in input parameters of stored procedures
    ... the wildcards on the client and pass the whole search value as parameter, ... if you concatenate it in the stored procedure: ... For many applications I have used a screen drop down with values like ...
    (comp.databases.ms-sqlserver)
  • Re: Quick code to execute an SQL stored procedure.
    ... requirement in my MFC version 6 program to execute a stored procedure. ... The database is Microsoft SQL Server 2005. ... I know the server name, database name, login and password. ... How exactly do I execute the stored procedure? ...
    (microsoft.public.vc.mfc)
  • Re: Accepting wildcards like % in input parameters of stored procedures
    ... the wildcards on the client and pass the whole search value as parameter, or if you concatenate it in the stored procedure: ... For many applications I have used a screen drop down with values like ...
    (comp.databases.ms-sqlserver)