SQL - Stored Procedures

 Stored Procedure is a prepared code that you can save and you can use that code over and over again.


example:

select * from tbemp;


Stored Procedure Syntax:

create PROCEDURE pro_name

AS

sql_query

GO;


Execute the Stored Procedure:

EXEC procedure_name;



Example:

CREATE PROCEDURE getAllEmployee

AS

select * from tbemp

GO;



DELIMITER $$

CREATE PROCEDURE `allEmp`()

BEGIN

select * from tbEmp;

END;


Excecution:

Exce getAllEmployee;  //MSSQL

call allEmployees();   // MYSQL




DELIMITER $$

CREATE PROCEDURE `allEmployeeDetail`()

BEGIN

select e.emp_id as ID, e.emp_dept as Department, e.name, s.student_email, s.is_active

from tbEmp e inner join stdn s

on e.emp_id=s.student_id

where s.password_hash!='';

END;



DROP PRocedure allEmployeeDetail;


call allEmployeeDetail();











Comments

Post a Comment

Popular posts from this blog

Java Script - Table of Content

 Table of Content 1. Introduction to JavaScript What is JavaScript? Evolution of JavaScript How JavaScript Works in Browsers Setting Up the Environment: Choosing a Code Editor (VS Code, Sublime, etc.) Running JavaScript in the Browser Console Setting Up Live Servers 2. JavaScript Fundamentals 2.1 Variables and Data Types Declaring Variables (var, let, const) Primitive Data Types (String, Number, Boolean, Null, Undefined, Symbol, BigInt) Type Conversion and Coercion 2.2 Operators Arithmetic Operators Logical and Comparison Operators Assignment Operators Conditional (Ternary) Operator 2.3 Control Flow Conditional Statements (if, else if, else, switch) Loops (for, while, do-while) Break and Continue 2.4 Functions Function Declaration and Invocation Parameters and Arguments Function Expressions and Arrow Functions Default Parameters 3. Working with the DOM 3.1 DOM Basics What is the DOM? Selecting Elements ( getElementById , querySelector , etc.) Modifyin...
Read more

Step-by-Step Guide to Create a Subdomain

To create a subdomain for a domain hosted on GoDaddy or different account but managed under a different account without transferring the domain, follow these steps: Step-by-Step Guide to Create a Subdomain 1. Understand Your Setup Domain Registrar: The domain is managed in a different account (e.g., Godaddy, or another registrar). Hosting Provider: Your hosting is in your GoDaddy account. Objective: Create a subdomain (e.g., sub.example.com ) and point it to your hosting server. 2. Access the DNS Management of the Domain Login to the account where the domain is managed. Navigate to the DNS Management or DNS Zone Editor of the domain. 3. Add an 'A' or 'CNAME' Record for the Subdomain 'A' Record Method: Add a new 'A' record in the DNS settings. Set the subdomain (e.g., sub ) in the Name/Host field. Enter the IP Address of your GoDaddy hosting server in the Value field. Save the record. 'CNAME' Method: Add a CNAME record in the DNS se...
Read more