Operand type clash: uniqueidentifier is incompatible with bigint

_{Tuesday, November 12, 2013 1:59 PM}

Hi ALL

CREATE PROC usp_DeleteEmployeeProfile(@EmployeeProfileID bigint)
AS
BEGIN
DELETE FROM EmployeeProfile
WHERE EmployeeProfileID= @EmployeeProfileID
END

Gives me error;

Msg 206, Level 16, State 2, Procedure usp_DeleteEmployeeProfile, Line 4
Operand type clash: uniqueidentifier is incompatible with bigint
..

Kindly help

_{Tuesday, November 12, 2013 2:12 PM ✅Answered}

BIGINT is 8 bytes, uniqueidentifier is 16.

They cannot convert to each other.

Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012

_{Tuesday, November 12, 2013 2:10 PM}

Hi,

What is the data type of the column EmployeeProfileID.

Vinay Valeti| If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer

_{Tuesday, November 12, 2013 2:12 PM}

I changed it with uniqueidentifier and it give me right result.

Like;

CREATE PROC usp_DeleteEmployeeProfile(@EmployeeProfileID uniqueidentifier)
AS
BEGIN
DELETE FROM EmployeeProfile
WHERE EmployeeProfileID= @EmployeeProfileID
END
GO

Thanks