Answer / sakthi

Primary key:
It is an unique identifier, it wont allow null value, in a
table there will be only one column as primary key.

Composite key:

It same as Primary key but combination of more that one
column.

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

0 Answers  

---

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

---

What is difference between rownum and rowid?

0 Answers  

---

How to set the current database in ms sql server?

0 Answers  

---

what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  

---

how can i store resumes in database?

3 Answers   HCL,

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

explain databases and sql server databases architecture? : Sql server database administration

0 Answers  

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

---

What is the main purpose of having conversation group?

0 Answers  

---

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

---