Answer Posted / abc

SELECT distinct column_names INTO temp_table FROM main_table
drop table main_table
sp_rename temp_table,main_table

How to enter unicode character string literals in ms sql server?

1081

---

How can we rewrite sub-queries into simple select statements or with joins?

984

---

What is PROJECTION Operation?

1028

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

930

---

What are the aggregate and scalar functions?

1071

---

What stored by the msdb? : sql server database administration

1009

---

Will sql server 2005 allow you to reduce the size of a column?

995

---

How do you send email on SQL Server?

1068

---

What are the types of indexing?

1084

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

973

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

1151

---

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

992

---

What is postgresql server?

1009

---

What are the advantages of using third-party tools?

998

---

How to generate create view script on an existing view?

992

---