Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


141: PAD capture DATAWINDOW
PAD capture DATAWINDOW Powerbuilder data window (DATAWINDOW) is that it's a major achievement. Use it to produce a good variety of different types of statements. And a variety of database connectivity and is also a considerable convenience. Bu...

142: FOXPRO with chapter one of decryption
FOXPRO with chapter one of decryption Database encryption and decryption technologies FOXPRO articles author: CCBZZP In real applications, data security is very important, especially as the confidentiality of banks and other very important sectors...

143: XPRO capital to achieve the conversion of RMB
XPRO capital to achieve the conversion of RMB FOXPRO conversion of RMB to achieve capital Author: CCBZZP FOXPRO statements in the realization of the function is very powerful, especially in the real application of the RMB will be frequently used ...

144: O] SQLServer2000 when database file how to restore damaged
O] SQL Server2000 database file when the how to restore damaged When the database file how to restore damaged Welcome to exchange with me: white enhydra_boy@tom.com Welcome to reprint, please retain this statement, thank you! SQL Server2000, if ...

145: The use of server connect to a server
The use of server connect to a server 1: implementation of a server stored procedure exec OPENDATASOURCE ( SQLOLEDB, Data Source = remote ip; User ID = sa; Password = password ). Database name. Dbo. Stored procedure name 2: insert another data...

146: Library screening procedures (3)
Library screening procedures (3) prompt prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++ ++++++++++++++++++++ prompt + 7.0 Sort Area Size + prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++ ++++++++++++++++++++ prompt ...

147: , The table structure details
, The table structure details SELECT Table Name = case when a.colorder = 1 then d.name else end, The serial number field = a.colorder, Field Name = a.name, ID = case when COLUMNPROPERTY (a.id, a.name, IsIdentity) = 1 then √ else end, Primary...

148: Library screening procedures (2)
Library screening procedures (2) Ttitle Off prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++ ++++++++++++++++++++ prompt + 3.0 Log Switch In the Last Day + prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++ ++++++++++++++...

149: Storage of XML documents as the standard
Storage of XML documents as the standard / *-- Save as XML Table / query XML stored as a standard document --* / / *-- Example call - Using SQL authentication with the situation winows exec p_savexml @ sql = regional data, @ fname = c: \ regio...

150: Library screening procedures (1)
Library screening procedures (1) Features: 1. Database of basic information display (time database, models, etc.) 2. The database structure information-DATABASE MAP (CONTROL FILE, REDO LOG FILE, DATAFILE, ROLLBACK SEGMENT) 3. A database of all s...

151: nSoftware solution "HowTo" series (index)
n Software Solutions How To Series (Index) Listen Software Solutions How To Series (Index) Listen SoftWare Solutions and author David Nishimoto covers 26 to the development and management of database (Oracle) the series of articles, including the ...

152: OMOUSTRANSACTION (Self-Government Services) Introduction
OMOUS TRANSACTION (Self-Government Services) Introduction Low based on some version of the ORACLE project, and sometimes a headache to encounter some problems., For example, would like to present an implementation of DML, composed of a number of tr...

153: Application of DESCRIPTOR
Application of DESCRIPTOR Dynamic SQL in the application of DESCRIPTOR Wang Hung The flexibility of dynamic SQL is well known, I would like to introduce a dynamic DESCRIPTOR application SQL: $ short b_num; $ char * command; $ char Sql [1024]; ...

154: PL / SQL tool
PL / SQL tool / * ligang1000@hotmail.com * / Functions: for by the current user has a backup all the PL / SQL objects (including TYPE, TYPE BODY, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY or JAVA SOURCE) Principle: A data dictionary USER_SOURCE...

155: EC under the informix introduced the idea of self-development tools
EC under the informix introduced the idea of self-development tools Preface WINDODS on the current programming tools with each passing day, new; UNIX, however due to the limitations of the use of its programming tools are very poor. Be done in the...

156: dBase
dBase From dBase files, import data to SQL database, very simple, direct use of the following statements: /*================================================ ===================*/ - If we accept the data into the table already exists insert into ...

157: Microsoft to give up more government departments to switch to Linux
Microsoft to give up more government departments to switch to Linux Germany to give up more than 500 government departments to switch to Linux, Microsoft Computer World Net, according to the Associated Press news reports, a senior German governmen...

158: Excel
Excel From the Excel document, import data to SQL database, very simple, direct use of the following statements: /*================================================ ===================*/ - If we accept the data into the table already exists inser...

159: The wording of various databases
The wording of various databases The various database fields to connect the written Following a brief introduction of the various database fields to connect the written db2 select dpt_no | | dpt_nam from db2admin.bsdptms select dpt_no CONCAT dp...

160: Off memory function of variables
Off memory function of variables The author in the development of application systems have been used in the on error statement FoxPro prepared a variable to determine the function of memory Exist (), very convenient and practical, to introduce to y...


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