Recommended 10 MSS special effects (collection)

This article mainly introduces the win2008 R2 WEB environment configuration Mssql Server 2008 R2 installation graphic tutorial and remote connection setting method. Friends in need can refer to Microsoft® SQL Server™ is used for e-commerce, business lines and data Database management and analytics system for warehouse solutions. It is a commercial database software owned by Microsoft. The latest version has been developed to SQL Server 2014, and Microsoft has launched Windows Azure SQL cloud database. The purpose of this tutorial is to guide you through the installation of Sql server 2008 R2, and give a rough explanation of each step. If you are not good at explaining it, please point it out so that we can make progress together. This server is a 1 yuan host from Tianyi Cloud. I bought it for everyone to use for tutorials. If you think it is good, please pay more attention to this blog. Installation steps 1. First, please restart the server before installing the database. I have unzipped the SQL ISO file in advance, so I double-click setup.exe and click "New installation or add to existing installation

1. win2008 R2 WEB environment configuration Mssql Server 2008 R2 installation tutorial and detailed explanation of remote connection setting method (picture and text)

Introduction: This article The article mainly introduces the Mssql Server 2008 R2 installation graphic tutorial and remote connection setting method for win2008 R2 WEB environment configuration. Friends in need can refer to the following

2. Configuring database connection and json conversion

Introduction: This article mainly introduces various methods of connecting to the database in ASP.NET The configuration method introduces MSSQL, Access, Oracle, SQLite, and MySQL database configuration in detail, which has certain reference value. If you are interested, you can learn more.

##3. What is PDO? Characteristics of PDO and how to install PDO

#Introduction: PDO is PHP Date Object ( PHP Data Object), which was released together with PHP5.1 version. Currently supported databases include Firebird, FreeTDS, Interbase, MySQL, MS SQL Server, ODBC, Oracle, Postgre SQL, SQLite and Sybase, etc., with PDO , users no longer need to use mysql_* functions, aco_* functions or mssql_* functions, nor do they need to encapsulate them into database operation classes. They only need to use the methods in the PDO interface to operate different databases. When choosing not

4.

SQL in MsSql to obtain all superior instance codes

Introduction: This article mainly introduces relevant information on SQL to obtain all superior implementation methods. Friends in need can refer to

5.

php to implement some Sample code sharing of small things

##Introduction: 1. PHP reads sql server varchar field data, select Incomplete results When Mssql_query() reads varchar type, it only takes 255 bytes of data by default. If the field exceeds this range, use CONVERT(TEXT, table.comment) to convert the field type to TEXT.

6.

Detailed introduction to the method of reading json data in C# using MSScriptControl

Introduction: The following editor will bring you an article on how to use MSScriptControl to read json data in C#. The editor thinks it’s pretty good, so I’ll share it with you now and give it as a reference. Let’s follow the editor and take a look.

7.

MySQL-Sample code to implement MSS master-slave replication (read-write separation)

Introduction: Previously, in the blog post "MySQL - MS Master-Slave Replication (Read-Write Separation) Implementation", we explained how Build a MySQL master-slave replication architecture in MS mode, that is, a MySQL master-slave replication architecture with one Master and one Slave. So, how to extend MS (one Master corresponds to one Slave) to MSSS... (one Master corresponds to multiple Slave) architecture? Now, I will show you how to set up MySQL master-slave replication in the MSS (one Master, two Slave) architecture. Others

8. php installs the dblib extension, Specific steps to connect to mssql

##Introduction: The following editor will bring you an article about installing dblib in PHP Extension, specific steps to connect to mssql. The editor thinks it’s pretty good, so I’ll share it with you now and give it as a reference. Let’s follow the editor and take a look

9. How to get the xml return structure of mssql

Introduction: The database adds for xml auto calling method SqlCommand SqlComm= new

10. In XPath query Specifying the axis (reprinted from the MSSQL manual)

##Introduction: The following example shows how to specify the axis in an XPath query. The XPath queries in these examples are specified on the mapping schema contained in SampleSchema1.xml. For information about this sample schema, see Sample XPath Query.

[Related Q&A recommendations]:

php - How to access the remote interface program on the XP system

python uses the MSScriptControl.ScriptControl plug-in to execute JavaScript and reports an error in AddCode.

How does mysql implement the if exists() begin...end function of mssql?

node.js - How to connect mssql with nodejs?

android - SMS content recovery

The above is the detailed content of Recommended 10 MSS special effects (collection). For more information, please follow other related articles on the PHP Chinese website!