Answer / Bablu Kumar

SQL limitations, such as constraints and data types, help ensure the integrity and consistency of the data stored in a database. They prevent invalid or inconsistent data from being entered and maintained within the database. Some constraints include NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT, and INDEX. These can be used to enforce rules on columns, tables, and relationships between tables.

What are trace files?

1 Answers  

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1 Answers   HCL,

---

What are scalar functions?

1 Answers  

---

What is data compression? : sql server database administration

1 Answers  

---

What are basics of policy management?

1 Answers  

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1 Answers  

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

---

How to list all triggers in the database with sys.triggers in ms sql server?

1 Answers  

---

What is triggers in ms sql server?

1 Answers  

---