Answer Posted / shankar k

Constraint are used to table columns validations.
there are some constraints.

Primary key,
Foreign Key,
Not Null,
Check,
Unique Key,
default

How to trouble shoot if unable to connect SQL Server

1711

---

How to execute a sql statement using odbc_exec()?

775

---

How to edit table in sql server 2017?

690

---

What is application role in sql server database security? : sql server security

780

---

What is rank function?

816

---

What are the triggers in sql?

776

---

What factors you will consider calculating the storage requirement for that view?

736

---

What is the main difference between ‘between’ and ‘in’ condition operators?

823

---

Why do we need normalization?

693

---

Can coalesce return null?

757

---

What are the dis_advantages of stored procedures, triggers, indexes?

1975

---

What is a user-defined function in the sql server and what is its advantage?

845

---

How will you find out if there are expensive SQL statements running or not?

788

---

Explain what are the different index configurations a table can have?

880

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1770

---