| Subject | Result: [firebird-support] SELECT COUNT(*) FROM :PARAMTABLE - |
|---|---|
| Author | Tanz Anthrox |
| Post date | 2004-02-12T13:40:30Z |
CREATE PROCEDURE SP_SERVERISTATISTIK
RETURNS (
TABLOAD VARCHAR (50),
KAYITSAYISI BIGINT)
AS
begin
for
SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE
(RDB$RELATION_NAME NOT LIKE 'RDB$%')
and
(RDB$VIEW_SOURCE IS NULL)
INTO
:TABLOAD
DO
BEGIN
execute statement 'SELECT CAST(COUNT(*) AS BIGINT) FROM ' || TABLOAD
INTO :KAYITSAYISI;
suspend;
END
end
RETURNS (
TABLOAD VARCHAR (50),
KAYITSAYISI BIGINT)
AS
begin
for
SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE
(RDB$RELATION_NAME NOT LIKE 'RDB$%')
and
(RDB$VIEW_SOURCE IS NULL)
INTO
:TABLOAD
DO
BEGIN
execute statement 'SELECT CAST(COUNT(*) AS BIGINT) FROM ' || TABLOAD
INTO :KAYITSAYISI;
suspend;
END
end