How to start and end transact-sql statements?

0 Answers  

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

0 Answers  

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

0 Answers  

---

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

---

What are .mdf files?

0 Answers  

---

---

If user is owning any SQL Objects, can we drop that user

0 Answers  

---

How do I manually uninstall an instance of sql server 2016?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,

---

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

---

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

---

can we have a nested transaction? : Sql server database administration

0 Answers  

---