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

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.