can we give the identity for existing column of the table?
(already table contains 10(1-10) unique randam records)
Answer Posted / pravati
ALTER TABLE Tablename
ADD oldcolumnname newcolumnname
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to add the custom code in Report?
Difference between LEN() and DATALENGTH() in sql server ?
What does normalization do to data?
explain databases and sql server databases architecture? : Sql server database administration
Write a sql query to delete duplicate records from a table called table1
How optimize sql query with multiple joins in sql server?
What are data regions?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
Explain different types of self contained sub query?
SQL Server Architecture ?
Can group by be used without aggregate functions?
Can sub report data source be different from that of the parent report?
What are the differences between clustered and non-clustered index?
Tell me what is de-normalization and what are some of the examples of it?
What is the difference between DataRow.Delete() and DataRow.Remove()?