Hi All,
Can I handle empty textbox that update or insert into SQL database via the stored procedure instead of adding line of codes in my project
CREATE PROCEDURE TblRegUpdRec
(
@FileNum int,
@Fname nvarchar(50),
@Sname nvarchar(50),
@Tname nvarchar(50),
@Lname nvarchar(50),
@DOB date,
@NatID int,
@SexID int,
@TelID int,
@Tel nchar(10),
@IntTelID int,
@IntTel nchar(10),
@AdrsCtryID int,
@AdrsStateID int,
@AdrLin1 nvarchar(Max),
@FileStatID int,
@MarStatID int,
@OcupID int,
@email varchar(50),
@SSnum int,
@Passnum int
)
AS
BEGIN
SET NOCOUNT ON;
UPDATE TblReg
SET Filenum=@FileNum, Fname=@Fname, Sname=@Sname, Tname=@Tname, Lname=@Lname, DOB=@DOB, NatID=@NatID, SexID=@SexID, TelID=@TelID, Tel=@Tel, IntTelID=@IntTelID, IntTel=@IntTel, AdrsCtryID=@AdrsCtryID, AdrsStateID=@AdrsStateID, AdrLin1=@AdrLin1, FileStat=@FileStatID, MarStatID=@MarStatID, OcupID=@OcupID,Email=@email, SSnum=@SS ...
Go to the complete details ...