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 according to you is the difference between mysql and sql server performance?

1145

---

What is set nocount on and what is set nocount off?

995

---

What are the types of user defined functions in sql server?

1098

---

How to execute stored procedure and set temp table in sql server?

1094

---

Can we write ddl in trigger?

970

---

How to assign new column names in a view?

960

---

What is a join in sql? What are the types of joins?

1191

---

What is a select query statement in ms sql server?

1132

---

When columns are added to existing tables, what do they initially contain?

1097

---

What are different types of raid configurations? : SQL Server Architecture

1134

---

Can you explain various data region available in ssrs with their use?

1022

---

Explain primary key in sql server?

1074

---

What is postgresql server?

1060

---

What are dml (data manipulation language) statements in ms sql server?

1026

---

What are the 7 disadvantages to a manual system?

1032

---