Skip to content
Advertisement

SQL SP is not working giving error Column name or number of supplied values does not match table definition

Advertisement

Answer

You need to execute your variable using sp_executesql :

Note : Always qualify column names while using INSERT INTO . ..

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement