Interested to Buy Any Domain ? << Click Here >> for more details...
How can i change the column name.
- 13 Answers
- 23040 Views
- HCL, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / y.narendra kumar
This example renames the contact title column in the
customers table to title.
EXEC sp_rename 'customers.[contact
title]', 'title', 'COLUMN'
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Define primary key?
What are the disadvantages of using the stored procedures?
How to choose all records from the table?
What is data source in connection string?
Do you know exporting and importing utility?
Can a rule be bound to any column of any data type?
What is role playing dimension with two examples? : sql server analysis services, ssas
What does set rowcount do?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
How we create SQL Server 2005 Reporting Services ? Give me Sample
What do you mean by cardinality?
Explain timestamp datatype?
What is normalization and what are the advantages of it?
What stored procedure would you use to view lock information?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
