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.

what is macro?

5 Answers   Excel, Global Innovation, Wipro,

---

What is a view and what are its advantages?

0 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

---

What are audit control procedures?

0 Answers   Ernst Young, Thomson Reuters,

---

What are the main differences between #temp tables and @table variables and which one is preferred?

0 Answers  

---

What is "scheduled jobs" or "scheduled tasks"?

0 Answers  

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

What is self contained sub query?

0 Answers  

---

Is it possible to replicate data from sql server to oracle? : sql server replication

0 Answers  

---

How to delete an existing database user?

0 Answers  

---

how to change column into row in sql

4 Answers   ESS,

---