How can i change the column name.
- 13 Answers
- 23929 Views
- HCL, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / desh deepak
sp_rename 'tablename.oldcolumnname',tablenamename.newcolumnn
ame
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
List out the different types of locks available in sql server?
What is the difference between upgrade and migration in sql server?
How do I create a trace in sql server?
What is the difference between for xml raw and for xml auto?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How do I start sql server 2017?
How to convert character strings into numeric values?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is a coalesce function?
Explain “row_number()” in sql server with an example?
Where can you add custom error messages to sql server?
what is spatial nonclustered index
How do I find query history in sql server?
Equi join and non equi join is possible with sql server?
