Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @tab TABLE (nazwa varchar (100), ilosc int)
- DECLARE @nazwa VARCHAR(50)
- DECLARE @zapytanie varchar(1000)
- DECLARE @ile int
- DECLARE kursor cursor forward_only FOR
- select name from sys.objects
- where type = 'U'
- OPEN kursor
- FETCH NEXT FROM kursor INTO @nazwa
- while @@FETCH_STATUS = 0
- BEGIN
- SET @zapytanie = 'SELECT '''+@nazwa+''', '+'Count(*) FROM '+ @nazwa
- INSERT INTO @tab (nazwa, ilosc)
- EXEC (@zapytanie)
- FETCH NEXT FROM kursor INTO @nazwa
- END
- close kursor
- DEALLOCATE kursor
- select * from @tab WHERE ilosc > 0 ORDER BY nazwa
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement