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
Post a Comment