Sometimes an added measure of security can be achieved by using ports other than the defaults for server software. SQL Server allows you to specify which port you want it to run on; the default is 1433. Provided you can access your SQL Server through TCP/IP, the following connection string should help you connect to a different port (this example uses port 1510 on the local machine):
<%
cst = "Provider=SQLOLEDB;" & _
"Data Source=[x.x.x.x],[port number];" & _
"Initial Catalog=[dbname];" & _
"Network=DBMSSOCN;" & _
"User Id=[uid];" & _
"Password=[pwd]"
set conn = CreateObject("ADODB.Connection")
conn.open cst
...
%>
Notice that the IP address and port number are separated by a comma, and that TCP/IP is 'forced' by adding network=DBMSSOCN.
Performance of the SQL MERGE vs. INSERT/UPDATE
-
MERGE is designed to apply both UPDATE and INSERTs into a target table from
a source table. The statement can do both at once, or simply do INSERTs or
on...
No comments:
Post a Comment