Answer Posted / amit srivastava
create table stup(roll int,name varchar,marks int)
select * from stup
Alter table stup drop column marks
select * from stup
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is query optimizer in sql server?
How to convert numeric expression data types by assignment operations?
How do we know if any query is retrieving a large amount of data or very little data?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
How can you know if the row fetched from cursor is still valid in underlying table?
How to enter unicode character string literals in ms sql server?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is merge?
Write query to return all rows sql?
Explain the categories of stored procedure?
Can you explain important index characteristics?
What is join and name different type of joins?
What is key set driven?
What is the difference between mysql and sql server?
What is replication with database mirroring? : sql server database administration