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 the difference between substr and charindex in the sql server?

498

---

What is the maximum size per database for sql server express?

552

---

What is sql server database?

492

---

What is rank function?

600

---

Can you get second highest salary from the table?

548

---

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

161

---

How adventureworkslt tables are related?

522

---

What is serializable?

660

---

Explain the concept of recursive stored procedure.

490

---

How to delete duplicate rows in sql server?

566

---

Describe the functionalities that views support.

647

---

What is acid mean in sql server?

566

---

Do you know what is sql service broker?

526

---

Do you know what is a linked server in sql server?

541

---

What is the default sql server instance name?

555

---