Tutorials to .com

Tutorials to .com » Database » Sqlserver » Microsoft SQL Server Tutorial

Microsoft SQL Server Tutorial Articles


661: Use ADO to connect to the SQL Server behind a firewall
1. Firewall must be configured to allow port 1433 for the introduction of the port, as well as for the out-port 1024-65535 2. Connection string must specify the SQL Server address: IP address, DNS server host name or the name of the document 3. Co...

662: The use of SQL Server Import and index Microsoft Word documents
Q: I need to import Microsoft Word document to SQL Server and index these documents in order to query the relationship between the use of these documents. How to import and index documents then? Answer: SQL Server allows you to import Word document...

663: SQLDMO control the use of SQL Server
Talk nonsense, come to the question on the advantages and disadvantages of MS SQL Server features something to discuss later. Microsoft's program for external services to access MS SQL Server provides a powerful COM interface, the adoption of t...

664: The use of the extended stored procedure SQLSERVER remote backup and recovery
I was recently in the framework of procedures for the company (in data-oriented application system) do the data management module, the module is relatively simple demand: the backup, recovery and clean-up log. Basically, the software company to C / ...

665: Calculated using the Transact-SQL for SQL Server number of processors
Q: How to use Transact-SQL programming approach to determine the SQL Server I have a number of computer processors? A: The following statement will return the information you need: EXEC master .. xp_msver N'ProcessorCount ', N'Process...

666: The use of Named Pipes Access SQL Server
First, the meaning of the default SQL Server installation is configured to allow the client to TCP / IP protocol to access, users need to know SQL Server account password to access, this is not safe, because many of the WEB program is a direct conne...

667: MS SQL Server access through registry
Xp_regread to extend the use of stored procedures to access the registry and xp_regwrite. For example: <% Dim cnn Dim rs dim strSQL Set cnn = Server.CreateObject ( "ADODB.Connection") cnn.Open "provider = sqloledb; data sour...

668: At the same time, access and SYBASE database SQL SERVER
---- For a system administrator to manage a network at the same time a number of database servers or the Internet is a distributed network of many different database server, first of all at the same time to solve the access to the database server co...

669: ODBC connections through an example SQL SERVER
ODBC connections through an example of a SQL SERVER <? $ connection = odbc_connect ( "mydata", "userid", "passwd"); $ query = "select * from tab_1 where no> 0"; $ result = odbc_do ($ connection, $ qu...

670: SQL Server through the ISA proxy configuration instructions
Preface C / S development, the development of many tools to develop high efficiency, the disadvantage of generally two-tier system, web-based applications in wide area when it is difficult to guarantee security. B / S application development appro...

671: HTTP access through the SQL Server 2000
First, the establishment of access to SQL Server 2000 through the virtual directory in the HTTP access to SQL Server 2000 database, you must set up an appropriate virtual directory. Tools focus on the use of SQL Server Manager IIS virtual directory ...

672: The maintenance of SQL Server database
This part will introduce you to any maintenance of your database. The first school, you have to learn how to set up Alerts, how to learn how to back up your database. Finally, we will introduce the SQL Server Databases Maintenance Plan Establish Al...

673: No image to upload component database SQLSERVER
Components in the absence of test I have just upload successful, so we work together to provide code-sharing. / * Addemployee.asp * / <html> <head> <title></ title> <meta http-equiv="Content-Type" content=&q...

674: Summary of SQL Server connection failed error and solution
In the use of SQL Server, the user encountered the problem is to connect up to fail. Generally speaking, there are two ways to connect SQL Server, first use of SQL Server comes with the client tools such as Enterprise Manager, Query Analyzer, Profil...

675: Lower case to upper case the amount of [SQL SERVER]
Original work in SQL 2000 there are some problems. Correct errors and run through the SQL 2000. /************************************************* ******* Author: (wleii165@yahoo.com) Version: 1.0 Creation Time: 20020227 Modified: Functions: l...

676: SQLSERVER2000 database repair experience
************************************************** ******************* Author: Huangshan mail: leimin@jxfw.com version: 1.0.0 date :2004-1-30 (For a reprint, please indicate the source!, If there are problems please send MAIL to me :-)) ******...

677: Also the lock on the SQL SERVER
Usually in our database to add, modify, delete, query time if we are not dealing with a number of users when dealing with a timely single, Basically, we need not consider the general database and table lock deadlock like the situation, but if we ar...

678: Odbc even a page of type mssql
<! -. Net -> <? class Pages ( var $ cn; / / connect to database cursor var $ d; / / connection data table cursor var $ result; / / results var $ dsn; / / dsn source var $ user; / / user name var $ pass; / / password var $ total; / ...

679: ADO with SQL Server database management and equipment
Microsoft SQLServer is commonly used in small-scale network database management systems in the world. This web-based database-oriented applications are more and more web-based database applications that the normal operation of the system is generall...

680: COM automatically extend the service to use SQL Server functions
SQL Server's T-SQL programming language in the data storage and recovery of a powerful, but with the SQL Server database systems other than the functional aspects of weak interaction. However, we can be SQL Server's built-in COM automation e...


Page 34 of 39
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]   [38]   [39]