What are the pre requisites?
- 1 Answers
- 4772 Views
- I also Faced
- E-Mail Answers
Answer / guest
I. to modify datatype of a column ?
ii. to add a column with NOT NULL constraint ?
To Modify the datatype of a column the column must be empty.
To add a column with NOT NULL constrain, the table must be
empty.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the types of SQL Statement?
What is prepared statement in sql?
What is sql select statement?
what is dbms? : Sql dba
What is the difference between left join and left outer join?
what are date and time intervals? : Sql dba
what is global variable in package
how to concatenate two character strings? : Sql dba
What is indexing in sql and its types?
What is a memo field?
Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.
Which tcp/ip port does sql server run?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
