Answer Posted / praveen kumar.dandu

suppose we had a table name emp and columns ename and sal.

<sql>alter table emp rename column sal to salary;


it wll rename the column sal to salary

Is t sql the same as sql server?

945

---

How to create indexed view?

1026

---

When do you think a developer should use sql server-based cursors?

1018

---

Can we store videos inside the sql server table?

945

---

Write a program to fetch first 10 records from a file?

987

---

What is implicit cursors?

1050

---

Explain external key management in sql server 2008

869

---

What Is Rdbms?

1129

---

How you provide security to cube? : sql server analysis services, ssas

950

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1124

---

Do you know concepts and capabilities of sql server?

1041

---

What is the syntax for encrypting a column in SQL Server?

1101

---

Explain the difference between cross join and full outer join?

963

---

Why I have to use stored procedures?

1017

---

How to insert multiple rows with one insert statement in ms sql server?

1102

---