Answer Posted / om

the alter command is used to do modification at column level . so in order to change the name of a column we need to use alter .

command:- alter table (table name) rename (old column name) to (new column name)
note :- dont put brackets its just for u to understand

What is correlated subquery in sql server?

1072

---

What is the index requirement in SQL Azure?

98

---

How to return the second 5 rows in ms sql server?

1058

---

Explain the xml support sql server extends?

1040

---

What are the types of joins in sql?

1126

---

List out what other servers you can use with ssrs?

139

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2076

---

What methods do you follow to protect from sql injection attack?

1028

---

Do you know exporting and importing utility?

1039

---

How to transfer an existing table from one schema to another schema in ms sql server?

981

---

Is the primary key column of a table an index in ms sql server?

962

---

Explain the concepts and capabilities of sql server?

974

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1594

---

How do I edit a procedure in sql server?

957

---

How many database files are there in sql server 2000?what are they?

1051

---