diff from joins and view

Posted by Jkdoss under Sql Server on 12/17/2012 | Points: 10 | Views : 831 | Status : [Member] | Replies : 8
Hi all

explain diff from view and join in SQL ?


Thanks in advance
kalidoss j

KALIDOSS


Responses

Posted by: Naraayanan on: 12/17/2012 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Sandeepmhatre on: 12/17/2012 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Ankitsrist on: 12/18/2012 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Ankitsrist on: 12/18/2012 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Ankitsrist on: 12/18/2012 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Ankitsrist on: 12/18/2012 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Ankitsrist on: 12/18/2012 [Member] Starter | Points: 25

Up
0
Down
so dont confuse with this
warm regards
ankit


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

Posted by: Sriramnandha on: 5/12/2013 [Member] Starter | Points: 25

Up
0
Down
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

Login to post response