How can i change the column name.
Answer Posted / naren
update tablename set newcolumn name where old column name
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the security model used in sql server 2005?
What are constraints?
What is open database communication (odbc)?
How is sql used in sql server?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
How to use order by with union operators in ms sql server?
When do you think a developer should use sql server-based cursors?
How to return the date part only from a sql server datetime datatype?
What is openxml in sql server?
Explain the commands in sql server?
What is a mixed extent?
How to change the system date and time from SQL Plus Terminal ?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are the different sql server versions?
How to rebuild all indexes on a single table?