writing an Dynamic query in sqlserver
- by prince23
hi,
DECLARE @sqlCommand varchar(1000)
DECLARE @columnList varchar(75)
DECLARE @city varchar(75)
DECLARE @region varchar(75)
SET @columnList = 'first_name, last_name, city'
SET @city = '''London'''
SET @region = '''South'''
SET @sqlCommand = 'SELECT ' + @columnList + ' FROM dbo.employee WHERE City = ' + @city and 'region = '+@region
--and 'region = '+@region
print(@sqlCommand)
EXEC (@sqlCommand)
when i run this command i get an error
Msg 156, Level 15, State 1, Line 8
Incorrect syntax near the keyword 'and'.
and help would great thank you
