Hi Dear,
Please do change in your code as below
Stored Procuedure
ALTER PROCEDURE [dbo].[Tech_sup]
(
@Build_name varchar(max),
@Dept varchar(max),
@Floor_no varchar(50),
@Call_recvd varchar (max),
@Ext_no int ,
@Caller_name varchar(max) ,
@Call_assign varchar(max),
@problem varchar(max),
@ip varchar(20) ,
@Rec_Status int,
@prob_type varchar(50),
@id int output
)
AS
BEGIN
set @id = 0
INSERT INTO dbo.Tech_data (Build_name,Dept,Floor_no,Call_recvd,Ext_no,Caller_name,Call_assign,problem,ip,date_time,Rec_Status,prob_type)values (@Build_name,@Dept,@Floor_no,@Call_recvd,@Ext_no,@Caller_name,@Call_assign,@problem,@ip,getdate(),1,@prob_type)
set @id = Scope_identity()
END