Updating multiple tables in mssql

To check that run# getsebool -a | grep httpd_can_network_connecthttpd_can_network_connect -- onand to enable them if they are not on, dosetsebool -P httpd_can_network_connect 1setsebool -P httpd_can_network_connect_db 1taken fromhttps://

form=1&topic_id=29646&forum=38&order=DESC&start=0 If someone encounters the interesting problem in which PHP can connect to a MSSQL server from the command line but not when running as an Apache module: SELinux prevents Apache (and therefore all Apache modules) from making remote connections by default.

Not only does the MERGE statement support the UPSERT concept, but it will also support deleting records.The term UPSERT has been coined to refer to an operation that inserts rows into a table if they don’t exist, otherwise they are updated.To perform the UPSERT operation Microsoft introduced the MERGE statement.Partitioning improves the manageability and availability of table as well as the performance of the queries running against this partitioned table.For example, as you can see below, the first row represents a single large table, which contains sales data for 2008, 2009, 2010, 20 whereas the second row represents a table with 5 partitions, each partition contains sales data for each year (even if you think a yearly partition is too large to manage, you can partition it on monthly basis, the choice is yours based on your requirements).With every new release of SQL Server, partitioning has reached new heights of improvement.


Leave a Reply