April 14, 2011

To Pass default value to Stored Procedure parameter

CREATE PROCEDURE [dbo].[spGetBulkSearchData]
(
@POLNUM NVARCHAR(4000),
@FDATE DATETIME,
@TDATE DATETIME,
@ATT INT=0
)

No comments:

Post a Comment