Tutorials to .com

Tutorials to .com » Database » Microsoft SQL Server Tutorial

Microsoft SQL Server Tutorial Articles


1: A safe and stable database SQLSERVER
A safe and stable SQL SERVER Database 1, first of all you have to confirm your identification model: WIN NT authentication mode or mixed mode of it, which mixed-mode, including WIN NT authentication mode and differential mode SQL SERVER steps in th...

2: Experience
Experience A successful management system is determined by: [50% + 50% of business software] formed, while another 50% of the success of the software [25% of the database + 25% of the programs] of the composition, the database design good or bad is...

3: uard configuration StepbyStep
uard configure Step by Step link: http://www.eygle.com/ha/dataguard-step-by-step.htm 1. the primary node back up and generate the standby database control file to set the primary node to force Logging mode (for bi-directional switch, the proposed s...

4: uard configuration StepbyStep
uard configure Step by Step link: http://www.eygle.com/ha/dataguard-step-by-step.htm 1. the primary node back up and generate the standby database control file to set the primary node to force Logging mode (for bi-directional switch, the proposed s...

5: tybuffer
ty buffer In fact, everyone v $ bh to this view may have been getting short shrift. We look at this view, the main field Description: STATUS VARCHAR2 (1) Status of the buffer: FREE - not currently in use XCUR - exclusive SCUR - shared current ...

6: Do not, upload ago, at the client to determine the size of image files
Do not, upload ago, at the client to determine the size of image files Was previously collected TIPS, recently used in the project, and it may be helpful. "! - Taken from the 51js -> <script> var img = null; function s () ( if (...

7: (Primary, intermediate, advanced)
(Primary, intermediate, advanced) Operational data: SQL Operational data: SQL n SQL-based n Intermediate SQL n Senior SQL ========================================= =============================== n SQL-based ¨ ¨ SQL Introduction ¨ ¨ using ...

8: (Primary, intermediate, advanced)
(Primary, intermediate, advanced) Operational data: SQL Operational data: SQL n SQL-based n Intermediate SQL n Senior SQL ========================================= =============================== n SQL-based ¨ ¨ SQL Introduction ¨ ¨ using ...

9: (Primary, intermediate, advanced)
(Primary, intermediate, advanced) Operational data: SQL Operational data: SQL n SQL-based n Intermediate SQL n Senior SQL ========================================= =============================== n SQL-based ¨ ¨ SQL Introduction ¨ ¨ using ...

10: (Primary, intermediate, advanced)
(Primary, intermediate, advanced) Operational data: SQL Operational data: SQL n SQL-based n Intermediate SQL n Senior SQL ========================================= =============================== n SQL-based ¨ ¨ SQL Introduction ¨ ¨ using ...

11: (Primary, intermediate, advanced)
(Primary, intermediate, advanced) Operational data: SQL Operational data: SQL n SQL-based n Intermediate SQL n Senior SQL ========================================= =============================== n SQL-based ¨ ¨ SQL Introduction ¨ ¨ using ...

12: End SQLSERVER database to the local directory
End SQL SERVER database to a local directory / * Database backup stored procedures * / / * Support for backup data from the server to the local machine * / - Author: yoncen CREATE PROCEDURE up_dbbackup ( @ backup_db_name VARCHAR (128), @ file...

13: How to obtain all the SQLServer server LAN
How to obtain the LAN to all SQL Server servers PAN id = ArticleContent1_ArticleContent1_lblContent> How to obtain the LAN to all SQL Server servers Literature reference sources: Delphi-depth exploration of I've always wanted in my applic...

14: On the lock SQLSERVER
On the lock as we embark on SQL SERVER database, add, modify, delete, query time, if we are not faced with multiple users to also keep the stand-alone processing time, Basically, we need not consider the general database, table locking, and deadloc...

15: Public class Connect SQLSERVER
Public class Connect SQL SERVER >************************************************* ************************************************** ** / / Start date: May 27, 2002 / / End date: May 27, 2002 *************************************************...

16: Lowercase
Lowercase And 7.0 in the sql2000 query statement to distinguish between uppercase query methods - sql2000, will use the following method. - Field name is added collate Chinese_PRC_CS_AS_WS - Case-sensitive, the whole method of half-width charact...

17: File management module to achieve multi-level classification technology cascade delete files
File management module to achieve multi-level classification technology cascade delete files ERP based on the file management module to achieve multi-level classification technology cascade delete files The stored procedure to achieve a multi-leve...

18: crosoftSQLServer the log file will not increase
crosoft SQL Server's log file will not be increased Description: how to make the Microsoft SQL Server 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 ha...

19: -SQL access to the current connected client IP and machine name
-SQL access to the current connected client IP and machine name /************************************************* ************************************************** ************** SP is to return the following to all client IP and HOSTNAME, can b...

20: Some of the concept of (model and database design b)
Some of the concept of (model and database design b) Some of the concept of database design (database design mode and b) ;) Exchange opinions please! -------------------------------------------------- ------------------------------------------ F...


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