How to cast bigint to nvarchar in sql server - Solved

Hi developers, I am writing this blog for helping one of my internet friend who asked for my help.

I am sharing the query on which the error is occurring for future reference.

Example:

declare @EmployeeTransID bigint

set @EmployeeTransID=33234000234454

declare @EmployeeTransIDGUID nvarchar(50)

select @EmployeeTransID as EmployeeTransID

set @EmployeeTransIDGUID = N'IMGHUNT' + @EmployeeTransID

select @EmployeeTransID as EmployeeTransID, @EmployeeTransIDGUID as EmployeeTransIDGUID

Error:

Error converting data type nvarchar to bigint.

Solutions:

You need to typecast the bigint to varchar.

set @EmployeeTransIDGUID = N'IMGHUNT' + CAST(@EmployeeTransID as varchar(50))

Hope you find the article helpful & interesting.

For any query, comment us below.

Previous – How to: Start Reporting Services Configuration Manager

Next – Types of SQL Server Joins #1

Click imagination hunt to read latest blogs.

Posted By - +Manish Kumar Gautam +LIVE VIAR +ASP.NET SOLUTIONS 

Keep learning and sharing...