How use inner join in sql server?

0 Answers  

---

how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,

---

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

---

Describe triggers features and limitations?

0 Answers  

---

When cursors are useful?

0 Answers  

---

---

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

---

Can sql servers link to other servers like oracle?

0 Answers  

---

How can we Use Linked Server? Uses of Linked server

1 Answers   IBM,

---

Why de-normalization required?

0 Answers  

---

What is difference between cte and view?

0 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,

---

Define synonym?

0 Answers  

---