declare @results table (
    prac_id int,
    prac_name nvarchar(100),
    prace_surname nvarchar(100),
    prac_IDcard nvarchar(100),
    prac_workplace nvarchar(100)
);

insert @results
exec sp_msforeachdb N'
use [?]

if left(''?'',6) = 'CDNXL_' -- only execute the query against databases
begin                       -- that match the naming pattern
    select
        prac_id,
        prac_name,
        prace_surname,
        prac_IDcard,
        prac_workplace
    from prac_nag.[CDNXL_?]
    where prac_IDcard = @parameter;
end;
';

select * from @results;