Answer / Neeraj Chaudhary

Constraints in SQL Server are rules that are defined to enforce data integrity. Different types of constraints include: CHECK CONSTRAINTS - enforce user-defined conditions, UNIQUE CONSTRAINTS - ensure uniqueness of a column or group of columns, PRIMARY KEY CONSTRAINTS - define the primary key for a table, FOREIGN KEY CONSTRAINTS - establish relationships between tables and ensure referential integrity.

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1 Answers  

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

---

What is the process of normalization?

1 Answers  

---

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

---

SQL Server Architecture ?

1 Answers   IBM, Sapient,

---

What is coalesce and check constraint in sql server?

1 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1 Answers   United Healthcare,

---

What will happen if a column containing char type data is changed to the nchar data type?

1 Answers  

---

What do you mean by data integrity?

1 Answers  

---

What is an inner join?

1 Answers  

---

Can we move Resource database from one path to another? If yes,How can we?

1 Answers   Wipro,

---

Explain about integration services of Microsoft SQL server?

1 Answers  

---