Answer Posted / henry

Constraints are used to restrict or protect the data and
accessing from the table
There are 5 types of constraints available,
That,
1.Primary-which is not allowed duplication and Null values
2.Unique-Which is also Not allowed duplication But It is
allowed one single null values
3.Foreign - Which is allowed duplication and Null values.
But It refers Value from primary Key table to its own table
Value.
4.Check Constratints
5.Not null

What are scalar functions?

946

---

What is the difference between executequery () and executeupdate ()?

963

---

Explain “@@rowcount” and “@@error” in sql server?

1000

---

Can a synonym name of a table be used instead of a table name in a select statement?

973

---

Tell me what are the essential components of sql server service broker?

884

---

What structure can you implement for the database to speed up table reads?

1154

---

What do you understand by hotfixes and patches in sql server?

909

---

What is #temp and @table variable in SQL server?

1024

---

What program is used to store the data source file?

903

---

What objects does the fn_my_permissions function reports on? : sql server security

990

---

Is it possible to call a stored procedure within a stored procedure?

913

---

Explain the steps needed to create a scheduled job?

881

---

What are the disadvantages of using querystrings to send data from one page to another?

928

---

Explain the difference between HTTP and HTTPS in database?

973

---

How to insert new line characters into strings?

932

---