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

