KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am trying to write a stored procedure to assist with development of our database, but I am having some trouble using it. For example: DECLARE @pID int; SET @pID = 1; EXEC WriteLog 'Component', 'Source', 'Could not find given id: ' + CAST(@pID AS varchar); This yields the error (on SQL Server 2005): Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '+'. Can someone explain to me why my syntax is incorrect, and the right way to solve this problem?
Tags (comma-separated)
Save Edits
Cancel