Answer Posted / 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.

Which are the third-party tools used in sql server and why would you use them?

890

---

How to list all columns in a table using odbc_columns()?

969

---

How to find Duplicate Records In table?

1007

---

List out the difference between union and union all in sql server?

978

---

Which language is supported by sql server?

1004

---

Is the log file is a part of file group?

1027

---

Explain what is scheduled job and how to create it?

944

---

Where the sql logs gets stored? : sql server database administration

953

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1895

---

How can you check the version of sql server?

1086

---

Explain indexed views?

965

---

what's new in sql server 2016?

943

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1000

---

Can you explain different types of locks in sql server?

939

---

Do you know what are acid properties?

1063

---