Answer / ravikiran

Constraints are the mechanisms used by the sql server to
control unwanted or invalid data flow into a table.

Joins are the queries used to combine the rows from two or
more tables.

Answer / monal

Constraints are restrictions to make sure that data entered
in a table must meet certain crietria. You can put
constraint at either table level or column level. There are
5 types of constraints. Primary Key, Foregin Key, Unique,
Check and NOT NULL.

Joins are used to combine rows from one or more table. One
table using Self Join and More tables using inner join,
outer join, cross join.

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

---

What is page in sql server?

0 Answers  

---

can you any body tell me the difference between candidate key and primary key

4 Answers  

---

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

---

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

---

---

How do I start sql server agent automatically?

0 Answers  

---

What is simple indexing method?

0 Answers  

---

how can we know that how many users are connected in perticuler server??????

2 Answers  

---

what are constraints? : Sql server database administration

0 Answers  

---

What is raiseerror? What is raiseerror?

0 Answers  

---

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

---

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  

---