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;user defined function sql
Collation is defined as a set of rules
that determine how data can be sorted
as well as compared. Character data is
sorted using the rules that define the
correct character sequence along with
options for specifying case-sensitivity,
character width etc.Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
