Answer / g.ramesh

Inner Join is default type of join.
It produce result set, which contain's only matched rows.

Answer / prasanna

Inner joins use a comparison operator(like = or <>)to match
rows from two tables based on the values in common columns
from each table.It is a default type of join.
These includes Equi Joins and Natural Joins.

What is user defined stored procedures?

0 Answers  

---

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

---

where the connection string store in the database

0 Answers   HCL, Wipro,

---

What is the maximum number of index per table?

0 Answers  

---

What are tables in sql server?

0 Answers  

---

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

What are magic tables in sql server?

0 Answers  

---

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

---

Explain what is use of dbcc commands?

0 Answers  

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

---

What is use of except clause? How it differs from not in clause?

0 Answers  

---