Answers for "create user defined table type in sql"

SQL
0

create user defined table type in sql

CREATE TYPE UT_Employee AS TABLE  
(  
Emp_Id int NOT NULL,  
EmployeeName nvarchar(MAX),  
EmpSalary varchar(50),  
StateId varchar(50),  
CityId varchar(50)  
);
CREATE PROCEDURE USP_Insert_Employee_Infi(@Employee_Details [UT_Employee])  
AS  
BEGIN  
  
INSERT INTO dbo.Employee  
(  
Emp_Id,  
EmployeeName,  
EmpSalary,  
StateId,  
CityId  
)  
SELECT * FROM @Employee_Details  
END;
Posted by: Guest on June-21-2020

Code answers related to "create user defined table type in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language