Answer Posted / aravindu chowdary

CONSTRAINTS:
*It is a rule (or) restriction ,which is enforced during a
creation of table.
*constraints raises automatically at the time of
inertion,updation,deletion.
*constraints there are 3 types
1.Domain Integrity
* Not null:Donot allow null value.
* check: Limits the range of values or domain, checks
the values which a col can have
2.Entity Integrity
* Unique key:donot allow duplicate values, but allows
one null per col.Can have multiple unique constraints on a
table





* Primary key : Ensure no duplicate data and not allow
nulls.

3.Refrential Intrgrity
*Forgien key:Referntial integrity b/w 2 tables, one
table col values based on other table col values

What is SQL Azure Data sync?

105

---

Define magic tables in sql server?

571

---

What is ddl and dml commands?

513

---

How connect excel to sql server?

509

---

How to list all dsn entries on your local machine using odbc_data_source()?

558

---

---

What does Master database contains?

630

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

1542

---

How to Update from select query in sql server?

550

---

Can you explain what is the use of custom fields in report?

603

---

Explain about extended stored procedure?

490

---

Explain transaction isolation levels in sql server?

551

---

What is the difference between join and inner join?

539

---

What is a recursive stored procedure in sql server?

571

---

Where is trigger in sql server?

543

---

Can you import Microsoft Excel data to SSRS?

89

---