SQL Server

The previous articles have provided the basic idea of diagnosing all aspects of the database from the whole ... Maybe it's very useful to you, maybe you feel too far away from yourself. So today we are going to make an introduction from some of the

When involved in the old project data migration, the database structure has changed completely, and the old data needs to be treated with special fields, and the data is large, using Navicat to export a single table, a table data about more than 1

Purpose: Install sqlserver2012 on a computer that has been added to the domain, and configure database mirroring for real-time synchronization and failover.Establishment of domain control see:

You can perform an unattended installation by following these steps: Add the repository and install SQL Server. When you run Mssql-conf Setup, set the environment variables and use the-n option (without prompting).

SQL Server VDIBackup Principle AnalysisSQL Server provides a virtual device interface (VDI) API to help stand-alone application providers, supporting the integration of SQL Server backup and recovery operations into their products. These APIs are

The default language option SQL Server defines 33 natural languages, each of which identifies a date Interpretation Method stored in the system table syslanguages, each language is identified by a language identifier (ID.The default language of the

Database Administrators familiar with SQL Server 2000 know that DTS can import and export data. In fact, we can also use Transact-SQL statements to import and export data. In a Transact-SQL statement, we mainly use the OpenDataSource function and

SQL Server 2005 compact edition books online Ing Data Types of ole db (SQL Server compact Edition)   SQL Server 2005 compact edition converts the ole db data type to the local SQL Server compact edition data type.Data Type ing The following

SQL Server database, how to add s lock or X lock to data items I. Why should I introduce locks? When multiple users perform concurrent operations on the database, the following data inconsistency occurs: Update lossA and B read and modify the same

  In the SQL Server database, values of datetime and smalldatetime are stored as integers. However, unlike integers, they cannot be directly computed in mathematics. However, sometimes you still need to add or subtract a time interval in the

I have been searching for this stuff on the Internet for a long time, either incomplete or not what I wanted. I finally figured it out and posted it. Please help me to see if there are still defects. // Global variableString szsqlservicename; //

        The user is not associated with a trusted SQL Server Connection2009-05-06 Source:

Modify the SQL Server Name (@ servername)     After SQL server2005 is installed, the computer name (xiage) is changed ), However, the @ servername returned by the database is still fb4b6c04012d449/sqlexpress (the original default computer

The code page defines the bit mode of character and Unicode data. This mode represents a specific letter, number, or symbol (for example, 0x20 represents a space, 0x74 represents the character "T "). Some data types Use one byte for each character.

1. view the database versionSelect @ version Common SQL server patch versions: 8.00.194 Microsoft SQL Server 20008.00.384 Microsoft SQL Server 2000 sp18.00.532 Microsoft SQL Server 2000 sp28.00.760 Microsoft SQL Server 2000 sp38.00.818 Microsoft SQL

When using tables in a database, we often encounter two ways to use tables: using temporary tables and table variables. In actual use, how can we flexibly use them in the stored procedure? Although they implement the same functions, in a stored

I encountered a problem with using the stored procedure today. I used it for the first time. I used the Enterprise Manager to create a stored procedure. I just gave a name and didn't want to write anything in it. I saved it, later I used it, so I

Database Administrators familiar with SQL server 2000 know that DTS can import and export data. In fact, we can also use Transact-SQL statements to import and export data. In a Transact-SQL statement, we mainly use the OpenDataSource function and

My colleague's machine encountered the following prompt when installing SQL SERVER 2000: "A previous program has been installed to create a pending file on the installation computer. You must restart the installer before running it ". In the past,

SQL server lock mechanism (I)-Overview (lock types and ranges) SQL SERVER lock mechanism (II)-Overview (Lock compatibility and lockable resources)   This article introduces the locking mechanism of SQL SERVER (iii) -- Overview (lock and transaction