SQL Server

In SQL Server we often need to write a variety of SQL scripts, such as stored procedures and functions, because in the writing process, often adjust, some of the keywords we use uppercase, some we use the lowercase, some end use; For people with

You can query the system tables yourself: SELECT o.name as TableName, c.name as ColumnName, P.[value] as Descriptionfrom sysproperties p INNER JOIN s Ysobjects o o.id = p.id INNER JOIN syscolumns c on p.id = c.id and P.smallid = c.colidwhere (p.name

/*--Synchronizing readersINSERT into [172.21.200.8].gdlisxp.dbo. Reader Library (library card number, reader barcode, name, gender, ID number,reader level, level Code, Unit Code, Unit, debit, issuing date, expiration date, ethnicity, reservation

Original article, reprint must indicate source: http://www.ncloud.hk/%E6%8A%80%E6%9C%AF%E5%88%86%E4%BA%AB/introduce-for-sqlserver-cursor-2/In the previous section, we briefly explained the simple creation of SQL Server cursors, which we will explain

Source: http://andylin02.iteye.com/blog/486296What does the dbo in SQL Server mean?DBO is the default user for each database, with owner permissions, that is, DbownerBy defining an object with the dbo as the owner, you can make any user in the

Original: SQL Server synchronizes data across librariesA recent requirement is to synchronize data across libraries, where two databases are distributed over two physical computers, and automatic periodic synchronization can be done through SQL

SQL2005 Empty Delete log:Backup Log with no_log ' The dnname here is the name of the database you want to shrink, and notice that you modify the database name below and I'm not commenting anymore. Godump transaction dnname with no_log gouse

1, fake device files Xxxx.bak size of about 300G, the space occupied after restoration is 900G2, disk space only 1 T, if the backup files copied, the space remaining 700G, can not be restored successfully, so the remote way to restore.Examples are

Begin transaction--Start TransactionDECLARE @errorSun INT--Define error countersSET @errorSun = 0--yes, 0.UPDATE dbo. Test SET testname= ' 232 'WHERE testid=1--transaction operation SQL statementSET @[email Protected][email protected]

SQL Server's BULK INSERT statement can import local or remote data files into a database in batches, very quickly. The remote file must be shared before the file path should use the Universal Convention (UNC) name, which is the form of "\ \ server

If you need to pass a table to a stored procedure, then the table-valued type is used1. Create a table-valued typeCREATE TYPE [dbo]. [Storepreseparationamount] As TABLE ([Preseparationid] [int] not null,[preseparationamount] [decimal] (2) not

The memory that SQL Server occupies consists primarily of three parts: Data buffer, execution cache (Procedure cache), and SQL Server engine program. While the cache used by SQL Server engine programs is generally relatively small, the main focus of

Sometimes when we attempting to login the SQL Server 20xx Management Studio, when we type in the correct password, it fail S with:"a network-related or instance-specific error occured while establishing a connection to SQL Sercer. The server was not

SQL Statistics Daquan Collection, mainly some of the implementation of statistical functions commonly used code, I hope that the need for friends to help.1. Calculate each person's total and rank Select Name,sum (Score) as Allscore from Stuscore

If you have a job that needs to be performed automatically, such as how often or when each day is done, you can use the SQL Server job feature. Use the following steps:1. Open SQL Server Configuration Manager　　2, found that SQL Server Agent can not

COLUMN_ID like the following table:1 TextData The text value associated with the event class captured within the trace.2 BinaryData binary value associated with the event class captured in the trace.3 The database ID specified by the DatabaseID. DB

Process Control Statements refers to the command that is used to control program operation and process Fits. Generally refers to the control of the logical calculation section. 1.Begin End StatementEncapsulates multiple T-SQL statement combinations,

1.Ole Automation Procedures Server configuration optionssp_OACreate will start the OLE shared execution environment. ">When OLE Automation procedures is enabled, calls to sp_OACreate will start the OLE shared execution environment.Ole Automation

Common SQL statement query and sharing -- Create a database (File: main data file mdf = 1, secondary data file ndf> = 0, log file ldf> = 1)-- File group: When 1mdf, 5 ndf (, 2), 10 ldf (, 4), they are divided into multiple groups for storage. CREATE

The parameter cannot be NULL when SQL SERVER uses the connection SERVER established by ODBC driver to call the stored procedure. odbcnull We know that there are a lot of drivers available for SQL SERVER link Server (Linked Server). Recently we found