Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


21: Some of the concept of (model and database design)
Some of the concept of (model and database design) Some of the concept of database design (a model and database design) All along I thought there is hope that the database design and model the way to the, I have listed here may also not model, but...

22: Pieces of how to specify the type of field? (B)
Pieces of how to specify the type of field? (B) How to import text file specified field type? Question: I have a text file needs to import Access, text files, however there is a copy of the original data, but automatically import the database int...

23: Pieces of how to specify the type of field? (A)
Pieces of how to specify the type of field? (A) How to import text file specified field type? (A) Question: I have a text file needs to import Access, text files, however there is a copy of the original data, but automatically import the database...

24: QLSERVER2000 error
QL SERVER 2000 error I use the wave NP350R server configuration is a single Xeon 2.4 stars (2 motherboard support) 1GBDDR RAM 36.4GB * 2 SCSI hard drive Integrated dual LAN with ADSL dial-up with WIN 2000 SERVER (SP4) + SQL SERVER 2000 SQL SERVER...

25: Reduction
Reduction SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE strink_logspace AS SET NOCOUNT ON DECLARE @ LogicalFileName sysname, @ MaxMinutes INT, @ NewSize INT SELECT @ LogicalFileName = rtrim (name), @ MaxMinutes = 10...

26: In regular expressions
In regular expressions T-SQL in regular expressions Original author: Cory Koski Time: 2003/06/24 This article from Cory Koski. Cory wrote: I recently encountered a problem domain in the database is to try a regular expression search. There is no...

27: Some can be used to deal with null values the function
Some can be used to deal with null values the function NVL (expr1, expr2) NVL2 (expr1, expr2, expr3) NULLIF (expr1, expr2) COALESCE (expr1, expr2, ..., exprn) NVL Converts a null value to an actual value NVL2 If expr1 is not null, NVL2 returns...

28: After taking a few colors, how to be divided into RGB color?
After taking a few colors, how to be divided into RGB color? API function with color check how their color into RGB? Question: API function with color after the check is a hexadecimal value of 10, how to be divided into RGB color? Method One: H...

29: Use in the end pieces were sent?
Use in the end pieces were sent? . ldb file in the end, what use was to send? In this paper, the reference address: http://support.microsoft.com/default.aspx?kbid=208778 Abstract: . ldb file in the multi-user environment is very important too. T...

30: State formula method for calculating the wage system
State formula method for calculating the wage system Simple formula describes the dynamic method for calculating the wage system Question: Access a brief description of the dynamic equation method for calculating the wage system Answer: The fol...

31: He database table (IN clause example)?
He database table (IN clause example)? How to query the other database table (IN clause example)? Question: How to invoke the other database table? (Query external tables) jet sql clause of in how to use them in the end? Where to use? Method On...

32: db connection string, as well as the encrypted string
db connection string, as well as the encrypted string On the jet db connection string, as well as the encrypted string Question: On the jet db connection string, as well as the encrypted string ADO connection string MDB file how to write? How t...

33: Not exclusive way to open the current database?
Not exclusive way to open the current database? How to determine whether the current database open exclusively? Question: How to determine whether the current database open exclusively? ADO in the link operation or other database, if database op...

34: File management module to achieve multi-level classification of the file ID number of automated coding technology (V1.0)
File management module to achieve multi-level classification of the file ID number of automated coding technology (V1.0) ERP based on the file management module to achieve multi-level classification of the file ID number of automated coding technol...

35: And lock (v)
And lock (v) Deadlock problem Deadlock is a very important topic. In the affairs and the use of locks, the deadlock is an inevitable phenomenon. In both cases, deadlock can occur. The first is, when the two panels, respectively, lock the two separ...

36: And lock (d)
And lock (d) Space Management Lock is to prevent access to other resources designated control, concurrency control to achieve a primary means. In order to improve system performance, speed up processing speed services to shorten the waiting time f...

37: And lock (c)
And lock (c) Consider the use of services When in use, in principle, should be a short as possible so that services and services to avoid nesting. Services should be a short as possible, because the affairs of a long occupation of data services ha...

38: The
The / * Call in the Query Analyzer script generates sqldmo - stored procedure Zou 2003.07 ----------------- * / / *-- Example call declare @ str varchar (8000) exec sp_getscript zj,,, xzkh_sa, regional data, @ str output print @ str * / if ...

39: According to the state library
According to the state library HOW TO FIX SQLSERVER DATABASE SUSPECT? How to fix the database the state of "doubt"? ************************************************** ******** Author: Huangshan mail: leimin@jxfw.com version: 1.0.0 d...

40: oint (bzszp)
oint (bzszp) Savepoint (SAVEPOINT) is in the process of business a sign, with the rollback command (ROLLBACK) used in combination, the main purpose is to allow users to roll back a certain period without having to deal with the entire rollback, whi...


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