SQL stored procedures Execute SQL dynamically

--according to the input person to get hours statistics information
ALTER PROC Proc_getworkhourbyempid
@key1 varchar (100),--keywords
@user_group1 varchar,--user groups
As
Begin
declare @SqlSelect nvarchar (+), @ParmDefinition nvarchar (max);
Set @SqlSelect = ' select * ' from User where 1=1 '--sql statement
Set @ParmDefinition =n ' @key nvarchar (ten), @user_group nvarchar (50) '; --Parameter declaration
If (@key1 is not null and @key1! = ")
Begin
Set @[email protected]+ ' and (Emp_name like @key or emp_number like @key or branch_name like @key) '
End

If (@user_group1 is not null and @user_group1! = ")
Begin
Set @[email protected]+ ' and user_grouping like @user_group '
End

--Execute SQL

EXEC sp_executesql @SqlSelect, @ParmDefinition, @[email protected],
@[email Protected]_group1
End

SQL stored procedures Execute SQL dynamically