Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


221: SqlServer used to solve difficult problems warnings
Sql Server to use the alert to solve difficult problems If you are using Microsoft Sql Server in alarm (Alerts) encountered a problem, please see this article for possible solutions. 1. Check whether you use the latest Sql Server service pack Thi...

222: Enterprise Edition installation SQLServer2000 Guide
Enterprise Edition installation SQLServer2000 Tutorial Microsoft SQL Server 2000 is the latest version of the large database server, the performance indicators in all aspects of the trend of catch-up Oracle databases. After SQL Server 6.5 and 7.0 ve...

223: MySQL-based design of 2 of the BBS
MySQL-based design of 2 of the BBS 4. User Module Design For the bottom of the database, call the C API function mysql for database changes, the internal preservation Certain state variables (such as user name, or left to be completed on the firs...

224: VB application to access methods of SQLServer
VB application to access methods of SQLServer Introduction Microsoft Visual Basic (referred to as VB) as an object-oriented visual programming tool with easy to learn, flexible and easy to facilitate the expansion characteristics. And Microsoft to ...

225: In SQLServer running on the computer where the virus scanning software
In SQLServer running on the computer where the virus scanning software Q: What if I need to have SQL Server running on the machine running virus-scanning software so that we will not affect the performance? A: The answer to that question depends o...

226: View user's use of data access control
View user's use of data access control Q: My Microsoft Access 2000 back-end applications from the SQL Server 2000 database into the data. Access In order to prevent users to see SQL Server 2000 all the data in the table, I would like to use a b...

227: Updates will be listed in a table to another table
Updates will be listed in a table to another table Q: How to use an UPDATE statement in Table B, Table A three out updated list of the three? A: on this issue, you can use the powerful relational algebra. The code on this page explains how to use ...

228: SQLServer2000 will use existing code as a Web service provider
SQLServer2000 will use existing code to use as a Web service provider. NET distributed applications to establish Steve Kirk and Priya Dhawan Microsoft Developer Network Abstract: This article describes how to use Microsoft SQL Server 2000's X...

229: A cheap backup mechanism SQLServer database
A cheap backup mechanism SQLServer database ---- Now many companies are using MS Windows NT as a platform, SQL Server database for the background to build enterprise Intranet, the popularity of the mature technology that can effectively help compan...

230: SQLServer2000 how to access the database through HTTP
SQLServer2000 how to access the database through HTTP Microsoft SQL Server 2000 is one of the new features to support XML, so users can directly access through the HTTP functionality with XML Database SQL Server2000. Method described below. System...

231: sqlserver on how to use function Getdate ()
sqlserver on how to use function Getdate () create view v_getdate as select getdate () [output] go -------------------------------------------------- ------------- create function f_getdate () returns datetime as begin declare @ n datetime...

232: Six SQLServer7.0 database data movement method
Six SQLServer7.0 database data movement method My work is a database administrator to maintain multiple servers in the database, often a server in a database moved to another server, the mobile data experience, some experience, would like to share....

233: Faster using OLEDB to replace the ODBC link
Faster using OLEDB to replace the ODBC link Still in the use of ODBC system DSN to connect the database or document it? Please use the faster technology OLEDB provider to replace the DSN to connect database, do not have to beg your ISP (or your dat...

234: SQLServer analog processing functions of the two dates
SQLServer analog processing functions of the two dates / / In PHP is very inconvenient to deal with dates, such as the difference between two dates for the month? How to do? / / File Name: date.inc.php3 / / In the use of these two functions befor...

235: The correct configuration and use of SQLMail
The correct configuration and use of SQLMail Costs of the effort some time ago, and finally fixed the SQL mail configuration and use. Finishing out _Rambo want me to share the relevant documents. I would I configure SQL mail to describe the proce...

236: Deletion of the duplicate records (SQLSERVER)
Deletion of the duplicate records (SQLSERVER) Following the deletion of duplicate records on a set out of the question. There are two duplicate records within the meaning of, first, not repeat the record, that is, all fields are duplicate records,...

237: NTServer4.0 for LAN / LAN router
NTServer4.0 for LAN / LAN router ---- 1. Connect the two TCP / IP network ---- Two TCP / IP network connection between the NT Server 4.0 can be done by the IP router to complete, that is a host on the network B network with the main machine commun...

238: ServerApplicationError detailed solutions
ServerApplicationError detailed solutions Introduction IIS5 the HTTP 500 Internal Server Error is wrong, we often encounter one of the main error is the performance of procedures can not browse ASP static HTM page but will not be affected. In addi...

239: SQLServer to use Named Pipes visit
SQLServer to use Named Pipes visit 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 ...

240: SQLServer7.0sa account password attacks
Account password SQLServer7.0sa attacks affected version: SQL Server 7.0 Description loopholes Use a very simple strategy, it can change the SQL 7.0 server SA (system administrator) password. MS SQL Server 7.0 in the use of master.mdf landing sy...


Page 12 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]