does does the "select * from deleted" work as a stored procedure in SQL?

can you post some code so we can get an idea of the procedure?

hey, yeah i think we do. what does SP stand for?

i have been going through the master database trying to see what all the tables do. like the system messges table has 4333 different kinds of sql messages that...

i wanted to see if database roles and server roles had a menu to do selection. ie any kind of control settings that use a GUI.

i am using Enterprise Manager, that must be the reason!

select qty from (select top 3 * from pubs.dbo.sales order by qty desc)

works without the a. so i get the idea. in this case you wouldn't have to qualify?

select * from (select top 3 * from pubs.dbo.sales) a

when i took off the a on this statment it put this in the place of 'a' = DERIVEDTBL

could you give a little more info on how the 'a' at the end works? i want to know whats going on with that.

thanks

well get this, i got the book yesterday for the class and it comes with a 60 day trial. but then it will not download, i put the cd...

this worked sorry, we just did it wrong. ok thanks again.

no that didn't work for us sorry. go any other ideas?

what is the " ) a" at the end of your statement?

thanks,

we will give that one a try

ah, yes, i created it in one database only, not in master. for now i want to use it in just one database. this is a great stored...