Isaac
asked on
T-SQL error
I get the following error when i execute my stored procedure:
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---
Msg 2739, Level 16, State 1, Procedure sp_insUserInfo, Line 0
The text, ntext, and image data types are invalid for local variables.
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---
Stored Procedure:
USE [helpDesk]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_insUserInfo]
-- Parameters for 'tbl_user'
@personnel_id int,
@fname varchar(50),
@lname varchar(50),
@username varchar(50),
@pwd varchar(50),
@role_ID int,
@email_addr varchar(50)
AS
DECLARE @dte_added datetime
DECLARE @rec_id int
DECLARE @ticket_request text <-- What can I use in place of "text"
DECLARE @ticket_dte datetime
DECLARE @subject varchar(50)
DECLARE @tick_status varchar(10)
SET @ticket_request = NULL
SET @ticket_dte = NULL
SET @subject = NULL
SET @tick_status = NULL
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET @dte_added = GETDATE()
INSERT INTO tbl_user(personnel_id,fnam e,lname,us ername,pwd ,role_id,e mail_addr, dte_added) VALUES(@personnel_id,@fnam e,@lname,@ username,@ pwd,@role_ ID,@email_ addr,@dte_ added)
SET @rec_id = SCOPE_IDENTITY()
INSERT INTO tblTicket(personnel_id,tic ket_reques t,ticket_d te,subject ,tick_stat us) VALUES(@rec_id ,@ticket_request,@ticket_d te,@subjec t,@tick_st atus)
return @rec_id
END
GO
Thanks.
--------------------------
Msg 2739, Level 16, State 1, Procedure sp_insUserInfo, Line 0
The text, ntext, and image data types are invalid for local variables.
--------------------------
Stored Procedure:
USE [helpDesk]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_insUserInfo]
-- Parameters for 'tbl_user'
@personnel_id int,
@fname varchar(50),
@lname varchar(50),
@username varchar(50),
@pwd varchar(50),
@role_ID int,
@email_addr varchar(50)
AS
DECLARE @dte_added datetime
DECLARE @rec_id int
DECLARE @ticket_request text <-- What can I use in place of "text"
DECLARE @ticket_dte datetime
DECLARE @subject varchar(50)
DECLARE @tick_status varchar(10)
SET @ticket_request = NULL
SET @ticket_dte = NULL
SET @subject = NULL
SET @tick_status = NULL
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET @dte_added = GETDATE()
INSERT INTO tbl_user(personnel_id,fnam
SET @rec_id = SCOPE_IDENTITY()
INSERT INTO tblTicket(personnel_id,tic
return @rec_id
END
GO
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks you guys
ASKER
That's the exact procedure.
It's just supposed to insert data into a table.
Sounds like something is wrong. I like to read your insight.