select top 10 ra from photoobj

select top 10 ra from [photoobj]

select top 10 ra into mydb.test from photoobj

select * from mydb.test

drop table test

select top 10 ra into test from photoobj


-- the names with L should be executed in the long Queue

create function X(@in bigint,@mul bigint) returns bigint BEGIN return @in*@mul END

create function XL(@in bigint,@mul bigint) returns bigint BEGIN return @in*@mul END

create procedure mproc as BEGIN select top 100 mydb.X(objid,3) as X ,objid into GM from target.galaxy END

create procedure mprocL as BEGIN select top 100 mydb.X(objid,3) as X ,objid into GM from target.galaxy END

exec mydb.mproc

drop table GM

exec mydb.mprocL

drop table GM

drop procedure mproc

drop procedure mprocL

drop function X

drop function XL
