Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


61: Asynchronous IO host Open
Asynchronous IO host Open I, like asynchronous IO (Aio) In Hp-ux, when using synchronous IO manner, which means that the next time before writing IO, IO must return to the previous "write completed successfully" message, we can see in th...

62: ------------- FlashbackQuery application of DML against misoperation
Application of the Flashback Query ------------- DML misoperation for the recovery of (1) New features of 9i Application Flashback Query ------------- misoperation for the restoration of DML Author: Liu Time :2003-12-29 mail: liuyingbo@126.com, ...

63: nSoftware solution "HowTo" Series 3: backup control file
n Software Solutions How To Series 3: backup control file Listen Software Solutions How To Series 3: backup control file Backup control file for the binary version: ALTER DATABASE BACKUP CONTROLFILE TO d: \ orant \ control_backup Backup control ...

64: nSoftware solution "HowTo" Series 2: stored procedure
n Software Solutions How To Series 2: stored procedure Listen Software Solutions How To Series 2: stored procedure Reference: Reference to the definition and use of the cursor Reference to the definition and use of function Stored procedure CR...

65: nSoftware solution "HowTo" Series 1: Paradigm Outline
n Software Solutions How To Series 1: Paradigm Outline Listen Software Solutions How To Series 1: Paradigm Outline General Outline the following paradigm usually means less out of the table is divided into two or more tables, small table in the d...

66: Precision data types
Precision data types / *-- Edit the custom data type precision sample Custom data types, once invoked, can not be modified and deleted, if we try to amend the accuracy of the data, this would be very cumbersome, the following examples demonstrate ...

67: Operation of a number of tables or columns
Operation of a number of tables or columns How at the same time or out on a number of operations Through the use of this stored procedure, you can easily have some of the database or all of the rules table, the field here for a variety of operatio...

68: transfer function of the log erver2000 - Description (1)
erver 2000's log shipping functionality - Description (1) Of SQL Server 2000 log shipping functionality - Description (1) Role changes, role reversal, as well as the location of monitoring server When shut down when the online database (which...

69: Detailed erverCHARINDEX and PATINDEX
erver CHARINDEX and explain PATINDEX SQL Server CHARINDEX and explain PATINDEX If you wrote a lot of procedures, you may occasionally encounter characters or character to determine whether channeling string included in the section of text, in this...

70: transfer function of the log erver2000 - Description (2)
erver 2000's log shipping functionality - Description (2) Of SQL Server 2000 log shipping functionality - Description (2) Role changes, role reversal, as well as the location of monitoring server Step 4: to inform the monitoring server roles ...

71: HENCRYPTION stored procedure
H ENCRYPTION stored procedure create PROCEDURE DecryptObject (@ objectName varchar (50)) WITH ENCRYPTION AS begin declare @ objectname1 varchar (100) declare @ sql1 nvarchar (4000), @ sql2 nvarchar (4000), @ sql3 nvarchar (4000), @ sql4 nvarcha...

72: erver2000 the log shipping functionality - set (1)
erver 2000's log shipping functionality - set (1) Of SQL Server 2000 log shipping functionality - set (1) Log transfer function can automatically copy the database transaction log files, and restore to the backup server (standby server) anothe...

73: .5 Database embedded JAVA Developer's Guide
.5 Database embedded JAVA Developer's Guide JAVA embedded database development ASE12.5 Guide Author: Time: April 2004 Platform Windows 2000 Server ASE 12.5 developer edtion for NT Statement Welcome to reprint, please retain this affirms ...

74: erver2000 the log shipping functionality - set (2)
erver 2000's log shipping functionality - set (2) Of SQL Server 2000 log shipping functionality - set (2) Gradually set up Primary Server in the set Standby Server and Log shipping 1, open Enterprise Manager, click the Tools Database Mainten...

75: What is meant by "using DataLink file"? What is a UDL file? How do I create?
What is the use of Data Link file? What is a UDL file? How do I create? New look: What is the use of Data Link file? What is a UDL file? How do I create? Address the topic: http://access911.net/index.asp?board=4&recordid=71FAB21E1ADCEAF3 Brie...

76: erver2000 the log shipping functionality - set (3)
erver 2000's log shipping functionality - set (3) Of SQL Server 2000 log shipping functionality - set (3) Change the configuration of log shipping You can use the database maintenance plan】 【Properties dialog box to change the log shippin...

77: erver2000 the log shipping functionality - set (3)
erver 2000's log shipping functionality - set (3) Of SQL Server 2000 log shipping functionality - set (3) Change the configuration of log shipping You can use the database maintenance plan】 【Properties dialog box to change the log shippin...

78: QLSERVER2000 database permissions specified list of objects?
QL SERVER2000 database permissions specified list of objects? A few days ago someone asked to see the possibility of convenient access to the specified SQL SERVER2000 object permissions and the permissions specified USER. I wrote a stored procedure...

79: e function usage
e function usage In the database development process, there is often need to convert the line out or go out to display the data conversion, and often we can not establish when the table structure shown in accordance with the requirements to save da...

80: QL into multiple files of data to SQLServer
QL multiple files to import data to SQL Server in the The use of T-SQL data into multiple files to SQL Server in the In our work, often need multiple files for input data to the table in SQL Server, and sometimes the same as or different from the ...


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