SQL Server

SQL Server Table Management _ about the operation of the table and adding and modifying the operation of the detailed (case code)Overview:Tables consist of rows and columns, and each table must have a table name.SQL CREATE TABLE SyntaxCREATE TABLE

Database Knowledge points1. Database operations:Add: INSERT into Table name values (value 1, value 2, value 3)Delete: Delete column name from table name whereConditionsChange: Update table Name set = value whereTable name = valueCheck: SELECT * FROM

1. How to troubleshoot SQL Server synchronous replicationhttp://blog.csdn.net/roy_88/article/details/414810592. "Synchronous replication common error handling 1" You cannot insert a display value into a table when IDENTITY_INSERT is set to OFF.

Second, the Complete lock compatibility matrix (see)The right is the code description: see.Third, the following table lists the resources that the database engine can lock. Name Resources Abbreviation Coding How the

SELECT TOP +--Create Time Qs.creation_time,--Query Statement SUBSTRING (St.text, (Qs.statement_start_offset/2)+1, (case Qs.statement_end_offset when-1Then datalength (st.text) ELSE Qs.statement_end_offset End-Qs.statement_start_offset)/2) +1) as

Recently has been studying the blog, in fact, is now a popular self-media, it is interesting that the netizens have written their own blog, the establishment of a small station, and now went to the platform for others to work free, but also enjoy

On his own computer for a long time, did not find, also think that they have less installed SQL Server Configuration Manager. Finally find the official website document, follow the path to find (this situation occurs after the recent WIN10

Differences between queries in Access and view in SQL ServerAlthough both can be used to create a drop view Delete in Delphi, but the two are not the sameSuppose there are table book and booktype associated Build query (view) V_bookWhen you add a

1 /// 2 ///database Access Help class3 /// 4 Public Static classDBHelper5 {6 Private Const stringConnStr ="server=127.0.0.1;database=db_test; Uid=user1; pwd=ps123321;";7 8 9 /// Ten ///implementation of the increase, deletion, change One /// A ///

One. SQL Server database commands1. Database(1) Database creationCreate DATABASE nameOn primary(Name= ' database name ',Filename= ' Database full path and database name, database file suffix. mdf ',)Log on(Name= ',Filename= ' database log file full

Original: SQL Server snapshotRecently, the development system used SqlServer2008 R2, but due to the increase of the system data pressure, ready to add a database synchronized with the official databases, used for the interface and reports to use, so

Stored Procedure format:CREATE PROCEDURE yourprocedure asbegin SET NOCOUNT on; BEGIN TRY---------------------start catching exception BEIN TRAN------------------start transaction UPDATE A SET a.names= B.names from T1 as A INNER joins T2 as B on a.id

View the memory usage of SQL ServerThe previous article mentions that dynamic T-SQL produces more execution plans, and how much memory is consumed by these execution plans? I found the answer in Xu Haiwei's book today. Dynamic view not only can find

Text: How to pause SQL Server data subscription serviceStarting and stopping the Snapshot Agent or Log Reader Agent from Management Studio Connect to the publisher in Management Studio, and then expand the server node and the replication

Original: SQL Server schema MigrationThe recent server architecture migration, the original server schema to the new server, the new server in the hardware better than before! The original server uses bidirectional synchronization and is divided

Original: SQL Server named instance change port for publish subscriptionTwo database servers, none joined the domain, all installed multiple instances, the port is not the same. Now using a named instance for replication, tossing a long time, only

--String function--1, LEN: Returns the number of characters in a stringSelect Len (' China '), Len (' abc123! ')Select Len (' abc ' + ' 1 '), Len (' abc ')--2, Datalength: Returns the number of bytes in a stringSelect Datalength (' China '),

1. The Text/ntext field in the SQL Server database, when driven with jtds1.2, will have a problem with getstring () not having a value, and toString () is not available.   checked the help yesterday. It can be solved by simple configuration. The

Sysobjects a row in the table for each object created within the database (constraints, defaults, logs, rules, stored procedures, and so on). Only intempdb, each temporary object occupies a row in the table. There are two fields in sysobjects that

Summary of four paging methods based on sqlserver and four paging methods of sqlserver First: ROW_NUMBER () OVER () method Select * from (Select *, ROW_NUMBER () OVER (Order by ArtistId) AS RowId from ArtistModels) As B Where RowId between 10 and 20