What is difference between views and stored procedures?

0 Answers  

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

0 Answers  

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

What is SubQuery in SQL Server 2008

0 Answers   HCL,

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

What is the use of floor function in sql server?

0 Answers  

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

What are the differences between triggers and stored procedures?

0 Answers  

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

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,

---

What is change data capture (cdc) in sql server 2008?

0 Answers  

---