diff from joins and view

Hi,
Check this link:
db.grussell.org/slides/sql3.pdf

Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Jkdoss, if this helps please login to Mark As Answer. | Alert Moderator

Sql Views

http://sandeepmhatre.blogspot.com/2012/12/sql-views.html

Sandeep M,
Software Developer
Follow me on :
http://sandeepmhatre.blogspot.in

Jkdoss, if this helps please login to Mark As Answer. | Alert Moderator

hello kalidas.....
views and joins can't be compared as they are very different things
(ie you could have join inside a view)

A View is like your MS Access Query
it will spit out results such as
"Give me the names of everyone older than 30 that plays tennis" say

mark this if it helps u

Jkdoss, if this helps please login to Mark As Answer. | Alert Moderator

The different between a VIEW and a Stored Procedure
is that a View will only use the "SELECT" statement
you can't update or delete records with a View
(very simplistic answer there are other differences too)
mark this if it helps u

Jkdoss, if this helps please login to Mark As Answer. | Alert Moderator

Now join is a different thing all together
its a function used in a SQL Statement

SELECT blah blah FROM tblBlog, tblBlig WHERE .. .. etc INNER JOIN

(reason I am not giving you a more readable code is because I never user JOINS in any of my queries so I forgot the syntax! )

Jkdoss, if this helps please login to Mark As Answer. | Alert Moderator

and finally....
dbo is standard for database object.
much like you have say an Excel object
excel.application.forms .. etc

its just their standard object model.
the hierarchy can go even higher levels

something loosely like:

mssql01.databases.db_123.tables.[dbo].[tblPeople]

try and see what happens when you ommit dbo on your queries.
you still get the same result.

Mark this if it helps u

Jkdoss, if this helps please login to Mark As Answer. | Alert Moderator

so dont confuse with this
warm regards
ankit

Jkdoss, if this helps please login to Mark As Answer. | Alert Moderator

The Difference between View and Stored Procedure:

1) View use select Statments only but Joins all types of statements (select statements)
2) join select statements support.
3) view it wont occupy any database.
4) view cannot update ,delete statements..


hope this will help......

sriram

Jkdoss, if this helps please login to Mark As Answer. | Alert Moderator