Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
No Answer is Posted For this Question
Be the First to Post Answer
Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name
How do you find the error, how can you know the number of rows effected by last SQL statement?
What is set nocount on and what is set nocount off?
What is a Join and explain its types?
What is scan table/view and seek table/view when its occurs? : sql server database administration
What is sleeping status in sql server?
could u plz explain about joins and views?
Distinguish between commit and rollback?
Can binary strings be used in arithmetical operations?
Explain what is use of dbcc commands?
Do you know what is replace and stuff function in sql server?
Tell me what is the stuff and how does it differ from the replace function?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)