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.

What is sleeping status in sql server?

1013

---

How to write an inner join with the where clause in ms sql server?

1073

---

What is an execution plan? How would you view the execution plan?

1053

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

945

---

Explain sql delete command?

1028

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1019

---

What are the differences between triggers and stored procedures?

1038

---

How many types of local tables are there in sql server?

915

---

What is cte (common table expression)?

1015

---

What command is used to create a database in the sql server and how?

1160

---

What is function of CUBE ?

1013

---

What is report server project?

145

---

What is index in an assignment?

936

---

How is foreign key related to primary key?

953

---

What is the chart in report?

158

---