T-SQL Exec statement syntax error

Question

Why is the first statement a syntax error?

-- this does not work: "incorrect syntax near the keyword 'system_user'"
exec dbo.spEmployee_GetRecords @pLoginName = system_user

-- this works
declare @p nvarchar(30);
select @p=system_user
exec dbo.spEmployee_GetRecords @pLoginName = @p

(SQL Server 2005 Express Edition)

dan radu · Accepted Answer · 2012-05-14 07:14:24Z

4

This is the syntax of EXECUTE. You can only pass values or variables, not functions or expressions. See EXECUTE on BOL.

answered May 14, 2012 at 7:14

dan radu

2,7824 gold badges20 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Torben Klein Over a year ago

You are right. The similarity to function calls in $(insert-any-programming-language) misled me. I wonder about the underlying design decision...

Collectives™ on Stack Overflow

T-SQL Exec statement syntax error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related