I'm not sure if this is possible but here what I'd like to do.
I need to write a stored procedure that takes in a single value (a SKU number). I have 8 tables in my database that all have a column called ItemSKU. I'd like to check all eight tables in one procedure and see if I can find a match to that single SKU number.
Is there a way I can check each table for a match and, if a match is found, stop the search and return the columns (name, price, stock) that I want?
Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed