Answer Posted / mohan

Constraint is nothing but set of rules or restrictions on a column,in order to achieve business requirements.

There are five types of constraints,
they are
1.primary key
2.unique key
3.not null
4.check
5.foreign key

These constraints also called data integrity constraints.

How to sort query output in descending order in ms sql server?

899

---

What is oltp (online transaction processing)?

948

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2179

---

How to Check if table exists in sql server?

1070

---

What is an indexed view?

915

---

What is difference between join and natural join?

894

---

What is the primary use of the model database?

1017

---

Which sql server table is used to hold the stored procedure script?

881

---

What do you mean by normalisation?

961

---

When you should use a low fill factor?

941

---

Name few endpoints exposed by ssrs 2012?

343

---

How do I manually uninstall an instance of sql server 2016?

959

---

What is the difference between sdf and mdf?

1229

---

Mention what are the different types of ssrs reports?

144

---

What is the use of sql profiler in sql server 2012?

839

---