Answer Posted / praveen kumar.dandu
suppose we had a table name emp and columns ename and sal.
<sql>alter table emp rename column sal to salary;
it wll rename the column sal to salary
| Is This Answer Correct ? | 5 Yes | 12 No |
Post New Answer View All Answers
What function does a database engine serve in the sql server?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
How to add a new dsn with the odbc driver for sql server?
What is the optimization being performed in oracle and SQL Server?
Write a SQL queries on Self Join and Inner Join.
How to link tables in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to insert data with null values?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
Describe how to use the linked server?
What is an indice?
How to check parameter value in stored procedure sql server?
mention different types of relationships in the dbms?
SQL Server Architecture ?
What is optimization and its types?