sql server - SQL Function "declare scalar variable" -


i creating t-sql function, , got error:

must declare scalar variable @userid

code:

create function dbo.accountsoftheuser (@userid int) returns table  returns  (    select        dbo.accounts.account_id, dbo.accounts.account_name,        dbo.account_type.description, dbo.users.user_name, dbo.users.first_name,        dbo.users.midle_name, dbo.users.email, dbo.account_type.type_name           dbo.accounts     inner join       dbo.account_type on dbo.account_type.type_id = dbo.accounts.type_id     inner join       dbo.users on dbo.accounts.user_id = dbo.users.user_id          (dbo.accounts.user_id = @userid) ); 

create function dbo.accountsoftheuser (@userid int) returns table  return ( select dbo.accounts.account_id, dbo.accounts.account_name,        dbo.account_type.description, dbo.users.user_name, dbo.users.first_name,              dbo.users.midle_name, dbo.users.email, dbo.account_type.type_name dbo.accounts inner join             dbo.account_type on dbo.account_type.type_id = dbo.accounts.type_id inner join             dbo.users on dbo.accounts.user_id = dbo.users.user_id   (dbo.accounts.user_id = @userid)  ); 

Comments

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -