simple query

Question

how to save data in strore prosedure

Saurav Kumar · Answer

To save data using a Stored Procedure in SQL Server, you first create the procedure in your database, then call it from your application (like ASP.NET Core or C#) with the required parameters. Example ?? Step 1: Create the Stored Procedure in SQL Server CREATE PROCEDURE SaveEmployeeData @Name NVARCHAR(50), @Email NVARCHAR(100), @Salary DECIMAL(10,2) AS BEGIN INSERT INTO Employees (Name, Email, Salary) VALUES (@Name, @Email, @Salary); END; Step 2: Call it from C# (ADO.NET Example) using (SqlConnection con = new SqlConnection("YourConnectionString")) { SqlCommand cmd = new SqlCommand("SaveEmployeeData", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", "John"); cmd.Parameters.AddWithValue("@Email", "john@example.com"); cmd.Parameters.AddWithValue("@Salary", 55000); con.Open(); cmd.ExecuteNonQuery(); } That’s it — your data gets saved in the table through the stored procedure. Stored procedures are more secure and efficient than inline SQL because they help prevent SQL injection and improve performance by caching execution plans.

Sandhiya Priya · Answer

How to save data using a stored procedure in SQL Server (the logic is similar in Oracle too). I’ll give an example step by step. 1. Create a Table First, you need a table where you want to save data. Example: CREATE TABLE Employees ( EmployeeID INT IDENTITY(1,1) PRIMARY KEY, Name NVARCHAR(50), Age INT, Department NVARCHAR(50) ); 2. Create a Stored Procedure to Insert Data A stored procedure allows you to encapsulate the SQL INSERT logic. CREATE PROCEDURE sp_AddEmployee @Name NVARCHAR(50), @Age INT, @Department NVARCHAR(50) AS BEGIN -- Insert data into the table INSERT INTO Employees (Name, Age, Department) VALUES (@Name, @Age, @Department); END 3. Execute the Stored Procedure You can call the procedure and pass the values to save data. EXEC sp_AddEmployee @Name = 'Sandhiya', @Age = 25, @Department = 'IT'; After this, a new row will be saved in the Employees table. 4. Optional: Check the Data To make sure the data is saved: SELECT * FROM Employees; Summary: Create the table where data will be saved. Write a stored procedure with parameters for the data. Use INSERT INTO inside the procedure. Execute the procedure with values to save the data.

simple query

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)