How can i change the column name.

Answer Posted / sonia

hi frnds, tell me one thing what is the difference b/w AS
keyword & sp_rename,AS is also used for reanme operation na.

Is This Answer Correct ?    3 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why are views required in the sql server or in any other database?

528


How to disable triggers using "disable trigger"?

549


What is the difference between join and inner join?

529


What is the syntax to execute the sys.dm_db_missing_index_details?

576


When does a workload on SQL Azure get throttled?

113






Why do we use trigger?

546


What is nolock?

546


How does index makes search faster?

591


What is change data capture (cdc) in sql server 2008?

558


How can you check the version of sql server?

551


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1844


How column data types are determined in a view?

526


How to use the inserted and deleted pseudo tables?

535


What is difference between delete & truncate commands?

538


What are synonyms?

519