Forum Discussion
Joshua1627
Feb 08, 2024Copper Contributor
Must declare the scalar variable "@tableName".
i'm writing a stored procedure , to get all the tablename present only in table1. and not in table2 tableName is the column name . but i'm getting the below error "Must declare the scalar variable ...
olafhelper
Feb 08, 2024Bronze Contributor
Can't reproduce / confirm it, I don't get that error message with your code and reviewing the code, I can't see any failure.
Joshua1627
Feb 09, 2024Copper Contributor
not sure why is not working for me . can you help in creating an SP , that will check if the record is present only in table1 and not table 2 and print the output
if the output is null, it should print NULL , if the out put is list of records it should print those records
if the output is null, it should print NULL , if the out put is list of records it should print those records