Drop column from temporary table

Nov 24 2011 2:36 AM

How to drop column from temporary table ;;
i tried by this query ,but error message gives "Incorrect syntax near '@Temp"

my query is

alter table @Temp drop column id

Answers (1)

Query to show all stored procedure with their code

I need to rollback the particular transaction in sqlserver DB.