sql server 2008 - Must declare the scalar variable "@unwantedRows" -


Why is this question not working?

  Delete tblProduct from tblProductInner Join @Unvanced Rows On TblProduct.ProductId = @Unfortunately, Manufacturer;  

Where @ inventedRows is

  announcement @ unverified ROS table (Product Id INT, Product Name VARCHAR (50), Description VARCHAR (50), category VARCHAR (50), duplicate int);  

You can not use the variable name to join in this way.

Try:

Delete tblProduct from tblProductInner Join @Unvanced Fury as tblProduct.ProductId = u.ProductId;

Comments

Popular posts from this blog

paypal - How to know the URL referrer in PHP? -

oauth - Facebook OAuth2 Logout does not remove fb_ cookie -

wpf - Line breaks and indenting for the XAML of a saved FlowDocument? -