Answer Posted / harsh v m

Sonia, clear your doubt here.

AS keyword is used for aliasing some existing column name
for our convenience.But the column name doesn't change @
database.

But incase of renaming a column the change is reflected @
database n it's usually done if we wish changing property
of a particular column.

sp_rename 'tablename.oldcolumnname','newcolumnname'->This
actually works out for Sql 2000.ALTER TABLE key doesn't
help.

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

884

---

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

936

---

Explain insert into select statement?

899

---

Can a database be shrunk with users active?

1063

---

What stored procedure would you use to view lock information?

903

---

What is deploy, process and build? : sql server analysis services, ssas

1034

---

Which tcp/ip port does sql server run on? How can it be changed?

976

---

What are sql azure firewall rules?

106

---

Can a table have 2 primary keys?

931

---

What is database replication?

1077

---

How to defragment indexes with alter index ... Reorganize?

1025

---

What are the different normalization forms?

1047

---

Can group functions be mixed with non-group selection fields in ms sql server?

890

---

Where are full-text indexes stored?

945

---

How to see existing views in ms sql server?

988

---