0

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...

2
Contributors
1
Reply
7
Views
4 Years
Discussion Span
Last Post by pritaeas
0

but i need to execute it without supplying any values...

Then you have to remove the parameters from the stored procedure, or provide dummy parameters (empty strings). You can run it using:

CALL InsertTBL_Supplier
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.