Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...
This is an attempt at making a slightly dynamic query to modify in bulk a CMDB at work. Using SQL Server 2008. I'm trying to update a column with a specific value. I want the table, the column and the ...