Click here to Skip to main content
15,900,482 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
SQL
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)
Posted
Updated 16-Jun-13 23:55pm
v3

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900