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
What is constraints and its types?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Explain about local stored procedure?
How many levels of sp nesting are possible?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Why are views required in the sql server or in any other database?
What are acid properties of transaction?
What is best institute to Learn DotNET And SQL in chennai?
What is the difference between deallocate cursor and close cursor?
What is the difference between varchar and varchar types?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is the difference between count and distinct count?
Where is localdb stored?
How to use copy and concatenate commands in SQL?