Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


41: MSDE engine soft data
MSDE engine soft data Microsoft Data Engine MSDE Create an overview of the application developer is faced with a choice: in a large number of database options, should choose what kind of technology? In the choice of a prior database technology, de...

42: And lock (b)
And lock (b) Schematic affairs Services to ensure data consistency and recoverability. The working principle of affairs as shown in Figure 1. Figure 1 Schematic affairs Services start some firms have been operating in the transaction log writes....

43: And lock (a)
And lock (a) Brief Relational database has four distinct characteristics, namely, security, integrity, and monitoring of concurrency. The security of the database is to ensure the security of the database data to prevent unauthorized users can mod...

44: The entire 2
The entire 2 Basic performance tuning 2 Basic Performance Tuning Part 2 With Roger Sanders Xiao Ao paste translation Bird of paradise, original works of free space Bird of Paradise © 2002-2005 All rights reserved free space Reprint reque...

45: QL statement Thoughts
QL statement Thoughts ************************************************** ******** Author: Huangshan mail: leimin@jxfw.com version: 1.0.0 date :2004-1-30 (For a reprint, please indicate the source!, If there are problems please send MAIL to me ...

46: Some ideas (from the demand to the database design)
Some ideas (from the demand to the database design) Some of the concept of database design (from the demand to the database design) Done a number of projects, database design and summarizes the relevant information, it is as a picture upload, data...

47: PLUS application AUTOTRACEREPORT
PLUS application AUTOTRACE REPORT SQL * PLUS in the application of AUTOTRACE REPORT Author: Liu Time :2004-1-12 mail: liuyingbo@126.com, please correct me Reprint please specify the source and the author In SQL * PLUS, when you are the success...

48: Library
Library Novice data warehouse Create Date :2003-12-26 Modified :2003-12-29 [Abstract] This article is to read "decision-making support and data warehouse system," a book of learning experience. [Keywords] data warehouse, decision supp...

49: P3 install Notes
P3 install Notes MSDE is the desktop version MSSqlServer, not only in win2000, winxp installation, but also in win98, winme installed, much smaller than MSSqlServer. (Win95, I have not tested) First of all, download the Microsoft MSDESP3 Comparis...

50: Mistakes tspack
Mistakes tspack The use of Statspack Mistakes Author: Fenng Oracle provides Statspack is an example of tool-class Tuning. Like a lot of DBA to use this tool for the optimal adjustment of the database. However, the exchange found in many of my fri...

51: SQLSERVER client calls the DTS package (and the input parameters)?
SQLSERVER client calls the DTS package (and the input parameters)? ************************************************** ******** Author: Huangshan mail: leimin@jxfw.com version: 1.0.0 date :2004-1-30 (For a reprint, please indicate the source!, ...

52: Rangepartition used in more than a small case series
Use range partition to a small number of cases listed Use range partition on a small number of cases listed Author: Liu Time :2003-12-29 mail: liuyingbo@126.com, please correct me Reprint please specify the source and the author 1. Practice F...

53: SERVER encrypted stored procedures, functions, triggers, views
SERVER encrypted stored procedures, functions, triggers, views create PROCEDURE sp_decrypt (@ objectname varchar (50)) AS begin set nocount on - CSDN: j9988 copyright: 2004.07.15 - V3 .2 - Break byte unrestricted SQLSERVER2000 apply to stored...

54: Tax
Tax - 1: tax program table create table skm_mstr (number int, the proportion of wage int, only int, only int, rate of int, speed count value int) / * The following data for Taiwan-funded enterprises in Shenzhen Longgang tax by: (Such as the tax...

55: Card (18) of the parity bit
Card (18) of the parity bit / * People's Republic of China in accordance with national standards 〖〗 GB 11643-1999 citizenship numbers relating to the provisions of the characteristics of citizenship combination code number is by the number...

56: L statement problem posting form data to build and generate built form of the stored procedure statement
L statement problem posting form data to build and generate built form of the stored procedure statement The following stored procedure can help you in answering the question of SQL statements directly from the posting form to build the sample data...

57: Tables in those databases exist
Tables in those databases exist - Inquiries on the specified database table in which the existence of declare @ tbname sysname set @ tbname = customer information declare @ dbname sysname, @ sql nvarchar (4000), @ re bit, @ sql1 varchar (8000) ...

58: According to the Treasury of the table structure differences
According to the Treasury of the table structure differences / *-- Compare differences in the database table structure --* / / *-- Example call exec p_comparestructure xzkh_model, xzkh_new --* / if exists (select * from dbo.sysobjects where id...

59: nSoftware solution "HowTo" Series 4: Create a database
n Software Solutions How To Series 4: Create a database Listen Software Solutions How To Series 4: Create a database Plan the location of database files Repetition of three sets of log files, there are two members of each document Create a data ...

60: erver-wide angle and half-angle of the comparison of characters
erver-wide angle and half-angle of the comparison of characters /*------------------------------------------------ ------------------------------------ / * Welcome to reprint, please retain this statement of information / * Author:enhydraboy@yaho...


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