what is mean by constraints in sql?

5 Answers   Granada, IBM,

---

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  

---

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

---

What is extended stored procedures?

0 Answers  

---

What is replication with database mirroring? : sql server database administration

0 Answers  

---

What is normalization? What number of normalization shapes are there?

0 Answers  

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

What is a Trace frag?Where can we use this?

1 Answers  

---

What is acid properties?

0 Answers  

---