Thursday, December 5, 2019

How to create stored procedure for insert data into table in sql server?


create procedure sp_InsertUserType(
@type_Name nvarchar(200),
@isActive bit )
as 
begin
INSERT INTO tblUserType(type_Name,isActive) VALUES(@type_Name,@isActive)
end
go


exec sp_InsertUserType 'Admin','true'

Featured Post

What is JavaScript? What is the role of JavaScript engine?

  The JavaScript is a Programming language that is used for converting static web pages to interactive and dynamic web pages. A JavaScript e...