Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


281: Recordset methods using new and updated information
Recordset methods using new and updated information on the use of SQL commands to add or update the information in the database is to facilitate the development of those who is loved most of the methods used, but when you have to carry out multiple ...

282: How to restore database?
How to restore database? To restore the database on the system are summarized as follows: In the SQL Server database, the system information stored in the system database, the main system database include: master-control of the whole user databas...

283: Access database operations strange phenomenon emerged in
Access database operations strange phenomenon appeared in the database I use Access2000, and system Win2000 Advance Server. Today debugging encountered the following strange phenomenon: 1. If the Access program to debug the program in open state (n...

284: BBS design based on MySQL's 1
BBS design based on MySQL's 1 1. System architecture: Modular thinking, is divided into 3 layers: a. Data storage layer: bbs use mysql to store all data, including user information, Article data, the user message, the user information system...

285: Migration from Oracle to SQLServer trap
Migration from Oracle to SQLServer in the trap to convert Oracle query SQL Server's time to take care of some particular issue of notes is not easy. We know, T-SQL is the language of SQL Server engine, and Oracle is the language engine PLSQL. Bo...

286: Data Protection Technology
Data Protection Technology IDC, one of the most important business is data management and protection of resources to meet the personalized needs of users. Therefore, the storage system is essential role, which will decide the services provided by I...

287: SQLServer-wide security planning Raiders (Part Two)
SQLServer-wide security planning Raiders (Part Two) Third, set the overall group security policy structure   next step is to determine what group the user should belong to. Typically, each organization or application of user data in accordanc...

288: Raiders wide security planning SQLServer (I)
Raiders wide security planning SQLServer (I) To improve the SQL Server 7.0 series of security mechanisms to achieve the process, Microsoft has established a flexible and powerful security management system, which users can access SQL Server and dat...

289: How to make MicrosoftSQLServer will not increase the log file?
How to make MicrosoftSQLServer will not increase the log file? How to reduce the MSSQL log file has been a recurrent problem, but the essence of the problem in many areas has been the answer, I will not repeat them here. Now we discuss the fundame...

290: Win9x platform SQLServer2000 performance and limitations
Win9x platform SQLServer2000 performance and limitations Many enterprises also use a variety of occasions, various versions of Windows 9x, therefore, in these circumstances the use of SQL Server 2000, we must first understand the performance of Win...

291: How to identify real and automatically create the index?
How to identify real and automatically create the index? Q: sysindexes I found a lot of index entries in the table is not created my own. I heard they are not the real index, but the SQL Server Query Optimizer statistics are automatically created. ...

292: Sql cursor and locking in the problem of
Sql cursor and locking in the problem of <% Cursor type Const adOpenForwardOnly = 0 Const adOpenKeyset = 1 Const adOpenDynamic = 2 Const adOpenStatic = 3 Locking type Const adLockReadOnly = 1 Const adLockPessimistic = 2 Const adLockOpti...

293: SQLServer and InnerJoin the OuterJoin
SQLServer and InnerJoin the OuterJoin Regularization in a database environment, we often encounter this situation: the necessary information is not on the same data table, at this time, you should use Join Of course, How to Join a different combin...

294: SQLServer stored procedure experience programming skills
SQLServer stored procedure experience programming skills MS SQL Server is now increasingly becoming the most important WindowNT above the operating system as a database management system, with the introduction of MS SQL Server2000, Microsoft's ...

295: How to use stored procedures instead of table variables
How to use stored procedures instead of table variables Q atrie560lcd: I would like to use stored procedures instead of table variable to the same table format for data of different changes, but I do not know how to do that. create procedure proc...

296: The existing Access database will be upgraded to SQL
The existing Access database will be upgraded to SQL A lot of Access and SQL Server developers are often faced with an Access database to upgrade to SQL Server databases. Because of the existing Access Upgrade Wizard, which will become the process ...

297: SQLServer connection ACCESS Database
SQLServer connection ACCESS Database Different database platform database is typically referred to as the interconnection of heterogeneous services, is now among the major database can be achieved such a heterogeneous interconnection, but the speci...

298: Use SQLServer Data Transformation Services Access database promotion
Use SQLServer Data Transformation Services Access database promotion Developers often use Access as a prototype or not to use Access to develop critical applications. However, with the growth of the company's business in order to solve the prob...

299: Preview version of Microsoft's push SQLServer2005
Preview version of Microsoft's push SQLServer2005 Microsoft recently launched a second technology preview version is similar to SQL Server 2005, which launched at the same time there is a for SQL Server 2000 and MSDE (Microsoft Desktop Engine) ...

300: Full access to SQL Syntax 3
Full access to SQL Syntax 3 Conditions ORDER BY statement This condition clause, usually combined with the SELECT statement is aimed at results of inquiries in accordance with the specified field to be sorted. SELECT fieldlist FROM table WHERE ...


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