29. SQL Stored Procedures in SQL | CREATE PROCEDURE Statement | SQL

[@shankarkr1603]

Can we use it in databricks?

[@learnbydoingit]

Yes select sql and do practice

[@udittiwari8420]

IN MSQL WORKBENCH THE GIVEN QUERY IS NOT WOKRING

[@udittiwari8420]

THIS WORKED FOR ME -MYSQL WORKBENCH -- one paramter DELIMITER $$ CREATE PROCEDURE emp_sp1(dept_id INT) BEGIN SELECT * FROM employees WHERE employee_id = dept_id; END$$ DELIMITER ; -- calling S.T CALL emp_sp1(1); -- Replace 1 with the desired employee_id DROP PROCEDURE IF EXISTS emp_sp1;

[@learnbydoingit]

Yes procedure creation syntax is little bit different in MySQL and SQL server ...do Install SQL server for practice

[@udittiwari8420]

@@learnbydoingit accha okay