That is invalid syntax. You are mixing relational expressions with scalar operators (OR). Specifically you cannot combine expr IN (select …) OR (select …). You probably want expr IN (select …) OR expr IN (select …). Using union would also work: expr IN (select… UNION select…)
The basic form is: This may not work if, for instance, you have a unique constraint on the columns and the insert violates this constraint. This assumes that you actually want to add the rows to the table. If you just want to see the results together: EDIT: The goal seems to be to add columns one tableB. … Read more
Check to see if your user is mapped to the DB you are trying to log into.
Assuming you’re intending to use Windows Authentication to impersonate the service account, you have to set up Windows Authentication in both IIS and ASP.NET. In IIS, make sure that the Windows Authentication module is added and enabled. Also make sure your application pool is running under a domain account, not a local account. In ASP.NET … Read more
The problem was that the ID column wasn’t getting any value. I saw on @Martin Smith SQL Fiddle that he declared the ID column with DEFAULT newid and I didn’t..
If you want to do it this way then this is the syntax you’re after; You don’t strictly need the BEGIN..END statements but it’s probably best to get into that habit from the beginning.