Answer / prasanthi

Check Constraint:

The CHECK constraint is used to limit the value range that
can be placed in a column.

not null constraint:

if we give not null constraint to any column it will not
accept null values.

Unique Conatraint:

Unique key is similar to primary key but it accepts one
null value.
For o column Setting Unique key+Not NULL we can make
Primary Key.

Answer / chaitu

These are contraints

query processing

0 Answers  

---

What is use of dbcc commands?

0 Answers  

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

How to add code to the existing article (using improve article)?

0 Answers  

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

---

CREATE a table from another table

2 Answers  

---

State the difference between union and union all?

0 Answers  

---

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

---

What stored by the msdb?

0 Answers  

---

Explain error and transaction handling in sql server?

0 Answers  

---

What is sql server profiler trace data file?

0 Answers  

---