INSERT DATA USING Store Procedure in sql server

A stored procedure with SELECT, INSERT, UPDATE, and DELETE SQL statements. The SELECT SQL statement is used to fetch .sert Update Delete Operations Using Stored Procedure in SQL Server. Start the SQL Server and create a table. Now we need to insert the data in the table using the insert query. After inserting the data, now we will create the Stored Procedure.Introduction. Sample table. Simple INSERT Example. Verify Inserted Data. INSERT with variables. INSERT Stored Procedure. Auto Generate INSERT. INSERT with IDENTITY.

[rinkulsharma]

how to get system date and if i want to add 100 records how to create loop and for each entry diffrent id for example l_leg0001 l_leg0002 and so on till 100