Answer / Rashme Paisal

"To transfer an existing table from one schema to another schema in MS SQL Server, you can use the sp_renamedbed system stored procedure. Here's an example:n`EXEC sp_renamedb @oldname=N'OldSchema.TableName', @newname=N'NewSchema.TableName'; "

What are various limitations of the views?

1 Answers  

---

Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,

---

How to delete existing triggers using "drop trigger"?

1 Answers  

---

What is @@Identity in sql?

1 Answers   Cap Gemini,

---

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

---

How to replace given values with null using nullif()?

1 Answers  

---

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

---

Can you type more than one query in the query editor screen at the same time?

1 Answers  

---

what is normalization? : Sql server database administration

1 Answers  

---

How to use "begin ... End" statement structures in ms sql server?

1 Answers  

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1 Answers  

---

Write a program to fetch first 10 records from a file?

1 Answers   Amdocs,

---