SQL Server

If you delete a batch of records in a data table without a trigger, you can use a delete statement to delete all the records that meet the condition. However, I found that if a data table has a deletion trigger, in this case, to delete a batch of

You have configured the publishing database in the SQL Server of your machine and created a publication named pubs: stores.At the same time, the subscription database mypubs (empty database generated according to the pubs script) is designed on the

SQL ServerHorizontal scaling: Design, implementation and maintenance (2)-distributedPartitionView (top) We have released someDatabaseExtendedArticleMany of my friends expressed great interest and expressed their pain points. With everyone's

SQL ServerReplicatioN Article 1: Approaching replication (I) For many SQL Server DBAs, replication is not a new thing.Copy", Many friends have already used it in the project. Like other technologies: Some people can use it well, and some people

FK _ foreign key   Select tab for primary key constraints. name as [Table name], idx. name as [primary key name], Col. name as [primary key column name] From sys. indexes idx join sys. index_columns idxcol on (idx. object_id = idxcol. object_id

There are four types of database replication. They are: Each item has its own advantages and disadvantages. I mainly use snapshot publishing and transaction Publishing. as for why not to use other products, all of them are synchronized with

In SQL Server, each SQL server operation will have a certain log record. In comparison, the insert, update, or delete event will be used. Each operation will lock the row and then record the row operation. When a table contains many data rows and

The following describes how to create an sqlserver DatabaseCodeTemplate, and a template for creating a table. During development, you can copy it and change it directly. Hope you can help me!   Code highlighting produced by Actipro

Http://msdn2.microsoft.com/zh-cn/library/ms152567 (SQL .90). aspx Replication uses publishing terminology to represent components in the replication topology, including the Publishing Server, distribution server, subscription server, publishing,

When I started to use SQL Server replication yesterday, I knew nothing about this, but what I wanted to achieve through this function was very clear-to complete data synchronization between the two SQL Server databases, that is, any data changes in

Today I encountered a problem: to convert the text in a field in the data table to "xxx.gif" to "xxx.jpg", I don't know the specific name, but I only know that it ends with GIF.Solution: Update pet set petphoto = substring (petphoto, 1, datalength

The sqlserver2000 on the machine has been useless for a long time, and the service has been stopped by me.To enable the sqlserver service and service manager today, I did not expect that the 1068 error will be reported as soon as I start the service,

Writing a winform in the past few days Queries data on any SQL server in the LAN. Some problems occurred when calling the COM component sqldmo, which have not been solved Partial tests Code Using System; Using System. net. Sockets; Using

Table 1ID Int   4   0 R_name Nvarchar   20   1 R_class Nvarchar   20   1 R_p Int   4   1 R_p1 Int   4   1 R_p2 Money   8   1 R_p3 Money   8   1 R_type Int   4  

The SQL Server Stored Procedure is a named set of transacation-SQL statements stored on the server. It is a method for encapsulating repetitive work, it supports declared variables, conditional execution, and other powerful programming functions.

Introduction   SQL Server ProfilerSQL Server event Exploration, An SQL monitoring tool that can be specific to each line of SQL statements, each operation, and each connection. I feel that this tool is still very useful. I would like to

ArticleDirectory Clustered Indexes First, we will introduce some index fragmentation related concepts and check and organize the Methods: Two types of index fragmentation One external Fragment The cause is that the index is not

Create   Function Split ( @ Str_in Varchar ( 8000 ), @ Separator   Varchar ( 4 )) Returns   @ Strtable   Table (Strval Varchar ( 8000 )) As Begin Declare @ Occurrences Int, @ Counter Int, @

A simple example is provided to mark the string decomposition problem encountered in the project. 1 Declare   @ IDS   Varchar ( 300 ) 2 Set   @ IDS = ' 1, 3, 4 ' 3 If ( Right ( @ IDS , 1 )

Sp_fulltext_catalog 'doc ', 'create', 'f: \ Temp' -- Create full-text reference on the ab01 table Sp_fulltext_table 'doc _ archivesresource', 'create', 'Doc', 'pk _ doc_archivesresource' -- Add the column za0101 to the ab01 table as the index