I created a stored Proc:
Create PRocedure InsertTBL_Supplier
(
@SupplierNumber nvarchar(50),
@SupplierName nvarchar(50),
@Address nvarchar(50),
@ContactNumber nvarchar(50),
@ContactPerson nvarchar(50)
)
AS
BEGIN
INSERT INTO TBL_Supplier
(SupplierNumber,
SupplierName ,
Address,
ContactNumber ,
ContactPerson )
VALUES ('10000','JenRoses Shop','Pasig City','09159675567','Dara Lim'),
('20000','Lawren FlowerFave','Makati City','5564818','Aiden Lee'),
('30000','FLowers&Scents','Marikina City','7280823','Dennis Park'),
('40000','Pretty Flower Spot','Pasay City','09276543789','Joshua Tan'),
('50000','Flower Tour','Quezon City','7280978','Marcus Cho')
END
but i dont know how to execute it, I used exec InsertTBL_Supplier
but i need to execute it without supplying any values...
Do you think it is possible???
Thank you, any help is appreciated...