ALTER PROCEDURE [dbo].SP_CREATEDEVMASTER
(
@SLNO bigint,
@SERIAL_NO nvarchar(30),
@DEVICE_NO nvarchar(6),
@MODELCODE int,
@WARRANTY nvarchar(3),
@STCODE int,
@REMARKS nvarchar(100),
@PROCESSOR nvarchar(10),
@RAM nvarchar(10),
@HARDDISK nvarchar(10),
@DEVCODE int,
@FLG_TYPE bit,
@PRICE money
)
AS
SET NOCOUNT OFF;
INSERT INTO [TBL_DEVMASTER] ([SLNO], [SERIAL_NO], [DEVICE_NO], [MODELCODE], [WARRANTY], [STCODE], [REMARKS], [PROCESSOR], [RAM], [HARDDISK], [DEVCODE], [FLG_TYPE], [PRICE]) VALUES (@SLNO, @SERIAL_NO, @DEVICE_NO, @MODELCODE, @WARRANTY, @STCODE, @REMARKS, @PROCESSOR, @RAM, @HARDDISK, @DEVCODE, @FLG_TYPE, @PRICE);
SELECT SLNO, SERIAL_NO, DEVICE_NO, MODELCODE, WARRANTY, STCODE, REMARKS, PROCESSOR, RAM, HARDDISK, DEVCODE, FLG_TYPE, PRICE FROM TBL_DEVMASTER WHERE (SLNO = @SLNO)