INSERT INTO Athletics VALUES((100, 'Samuel', 'David', '1967-11-17', '23',1967-11-20); INSERT INTO Athletics VALUES((110, 'Mario', 'Cassius', '1967-11-13', '22',1967-11-20 ); INSERT INTO Athletics VALUES((104, 'Mario', Ace', '1967-12-31', '26',1967-11-20 ); INSERT INTO Athletics VALUES((123, 'Cristisno', 'Ronny', '1965-11-13', '28',1967-11-20 ); INSERT INTO Athletics VALUES((110, 'Harx', 'Wale', '1964-11-12', '20',1967-11-20 ); QUESTION Create a stored procedure named sp_InsertAthleteDetails, which enters details into the Athletics table by using 4 parameters for the first four columns in the Athletics table. Set No Count on.
INSERT INTO Athletics VALUES((100, 'Samuel', 'David', '1967-11-17', '23',1967-11-20);
INSERT INTO Athletics VALUES((110, 'Mario', 'Cassius', '1967-11-13', '22',1967-11-20 );
INSERT INTO Athletics VALUES((104, 'Mario', Ace', '1967-12-31', '26',1967-11-20 );
INSERT INTO Athletics VALUES((123, 'Cristisno', 'Ronny', '1965-11-13', '28',1967-11-20 );
INSERT INTO Athletics VALUES((110, 'Harx', 'Wale', '1964-11-12', '20',1967-11-20 );
QUESTION
Create a stored procedure named sp_InsertAthleteDetails, which enters details into the Athletics table by using 4 parameters for the first four columns in the Athletics table. Set No Count on.
A stored procedure in a routine which has sql statements and can be used to insert, deleted , modify or retrieve data from table.
Step by step
Solved in 4 steps
