Answer Posted / srinivas

Constraint are the rules enforced on data columns on table



Five type of constraints
Primary key
Unique Key
Foreign Key
Not Null
Check

What is the standby server?

682

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2032

---

What is sql server management studio? : sql server management studio

740

---

What is temporary table in sql server? Why we use temp table?

703

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

725

---

---

What are the differences between substr and charindex in sql server.

692

---

whats new about truncate in sql server 2008?

2225

---

Do you know what are the properties of the relational tables?

790

---

What is factless fact table? : sql server analysis services, ssas

761

---

How to execute a sql statement using mssql_query()?

714

---

What is use of @@ spid in sql server?

876

---

Explain “row_number()” in sql server with an example?

721

---

How does recursive cte works in sql server?

711

---

Is the log file is a part of file group?

725

---

What are the purposes of floor and sign functions?

731

---