To pass a optional parameters to a stored procedure in SQL Server, declare the parameter with the default value.
Create Procedure proc_Test
@a int,
@b int =5 -- Provided with the default value.
as
begin
Select @a, @b
end
Note:
When using...
Often we will have a requirement like printing the Grid header in every page when it's printed out. You can do this using Javascript, by just changing the Grid Header row style to "display:table-header-group"
just give the below code in your page script section
function print_header()...