I need Syntax information about CASE Statement.
CREATE PROCEDURE test
@flag varchar (20),
@FieldValues Varchar( 500 ),
TableName Varchar( 100 ),
FieldNames Varchar( 500 )
AS
BEGIN
SET NOCOUNT ON ;
CASE
WHEN @flag = 'emp' THEN
Tablename = 'dbo.emp'
FieldNames = 'code,name,addr'
END CASE;
END
Above is my code when i compile i m getting following error.]
Error: Msg 156, Level 15, State 1, Procedure test, Line 13
Incorrect syntax near the keyword 'CASE'.
Please help me in solving it.