Answer Posted / rajan nadal

In join method join the two table by Atleast one row
match enough to join that tables

but in union

union can be combine the two select satement in the table
here the two select stament table having same number of
column and and datatype then only combine the two select
statement.here union display distinct values but union all
display all the values

Explain what is table in a database?

1055

---

explain the delete statements in sql

1050

---

how does a local variable is defined using t-sql? : Transact sql

1004

---

What are the various restrictions imposed on view in terms of dml?

963

---

What is a system versioned table?

980

---

Is primary key a clustered index?

966

---

What is sqlservr exe?

975

---

What are the syntax and use of the coalesce function?

1202

---

What is cartesian join in sql?

1119

---

When should I use nosql database?

1006

---

The select into statement is most often used to create backup copies of tables or for archiving records?

1064

---

What is difference between cursor and trigger?

1073

---

Can there be 2 primary keys in a table?

995

---

What is example of database?

1054

---

How do I view a sql trace file?

1025

---