declare @Name nvarchar(200)
declare mycursor cursor for SELECT Name FROM Master..SysDatabases ORDER BY Name
open mycursor
fetch next from mycursor into @Name
while (@@fetch_status=0)
begin
if(substring(@Name,1,3)='POS')
BEGIN
print @Name
--USE @Name
--go
--select top 100 * from billsales
END
fetch next from mycursor into @Name
end
close mycursor
DEALLOCATE mycursor