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.

How to enter comments in transact-sql statements?

947

---

How to create an index on an existing table in ms sql server?

981

---

What is temporary table in sql server? Why we use temp table?

957

---

How can change procedure in sql server?

1071

---

How can windows applications connect to sql servers via odbc?

1128

---

Explain the concept of recursive stored procedure.

965

---

How is a full-text index updated?

956

---

What is wrong with sql server client libarary dll, ntwdblib.dll?

1043

---

What is the difference between composite index and covering index?

954

---

How to modify existing triggers using "alter trigger"?

1020

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1333

---

What is the distinction amongst delete and truncate?

1071

---

Do you know what is similarity and difference between truncate and delete in sql?

1010

---

What are logical/boolean operations in ms sql server?

1050

---

How to execute a stored procedure in ms sql server?

1183

---