SQL Server

Source: Test data generated in SQL ServerBrief introductionIn the actual development process. In many cases we need to insert a large amount of test data into the database to test the functionality of the program. The resulting test data often needs

Author: GW? Reprint annotated Source??The SQL statement creates the table format:? CREATE table?? ( ??? [column-Level integrity constraints]? [, [column-Level integrity constraints] ...]? [,? );??--above is the format of the table if you do not

1. Returns the length value of the specified field in the table Col_lengthReturns the defined length, in bytes, of a column.Grammar:col_length ' Table ' ' column ' )Example:SELECT col_length ('dbo. Product'ProductName')2. Returns the name of the

A high level of understanding of SQL Server concurrency processing, indexing, GC, and caching is essential in the process of advanced programmer progress, which has recently been discovered. Therefore, to prepare for the future, decided to make a

Original: How to use OPENQUERY to access another SQL ServerIn a project, you often encounter a database that accesses another database, "cnvferpdb" is the server name, "CE3" is the library name1 SELECTDtl.* 2 fromcnvferpdb. CE3.ce3.ZTLE0125 Dtl3

The UPDATE statement is used to update the existing data with the update syntax:[With [... n] ]UPDATE [TOP (expression) [PERCENT]] {{Table_alias| Object> |rowset_function_limited[With ( [... n] ) ] } | @table_variable }

SQL Server High-availability scenarios Scenario One:asynchronous Mirror + AliasProgram IntroductionThe database server configures an asynchronous mirroring relationship, and the program client connection string configures the alias connection.1.

Original: http://www.nigelrivett.net/SQLTsql/WriteTextFile.htmlThe is several methods of creating text files from SQL Server. osql Bcp Redirection commands Sp_makewebtask Com Object Calls Remember that in all cases the

SQL Server version R2 (10.50.40), install SQL Server PROFILER:With command prompt, use the following commands:setup.exe/features=tools/q /indicateprogress /action=install/instancename=sqlserver2008r2ent/

In the original: SQL Server with (NOLOCK) detailedWhen we write the query, in order to performance, tend to add a nolockbehind the table, or with (nolock), the purpose is to query is not locked table, so as to improve the query speed. What is

--two times less efficient for table a queriesSelect Top 10 *From Awhere ID not in (select top with ID from A)--The outer query does not query the table A, the efficiency is greatly improvedSelect Top 10 *From (select top-from-A order by ID) as

In the face of a lot of Excel data we may be very distressed, if one of the inserted into the database, not only a lot of time, but also possible errors, and now I say how to import data!1. Preparatory workThe first thing to do is to create a data

A SQL Server function is a structure that encapsulates one or more SQL statements.SQL Server functions are divided into two types: system functions and user-defined functions.Scalar-valued Functions: The return value of a scalar-valued function is a

Deadlock definition:A deadlock is a two-thread or multiple-thread that has a subset of resources and needs other resources.But other resources are occupied by other threads, and each thread is in a waiting order to get the resources that other

SQL Server Database DesignFirst, the necessity of database designSecond, what is the database designThird, the importance of database designIv. Data ModelEntity-Relationship (E-R) data modelEntities (Entity)Properties (Attribute)Relationship

It's too much, I've erased the data."Big hole, the data was accidentally deleted by me." "In the process of database-related work, I think many people will have the same experience as I do?" In particular, when an update or delete operation is

--------------------------------------------------------------------------------------------------------------- -------------------1. File Header page:2. Page Free Space page:3. GAM:If the corresponding area is occupied corresponding to the bit is 0,

SQL Server custom data synchronization for business functionsDriven by different business requirements, the modular split of the database will face some special business logic processing requirements. For example, data synchronization requirements

SQL Server database performance optimization http://www.blogjava.net/allen-zhe/archive/2010/07/23/326927.htmlRecent project needs, did a period of time SQL Server performance optimization, encountered some problems, but also accumulated some

Six commonly used user-defined functions in SQL Server are shared. In daily applications, some values are often input based on actual needs, and these values cannot be directly used. Therefore, SQL usually performs some regular processing on field