SQL Server

1 linking to an instance of another SQL ServerEXEC sp_addlinkedserver ' server address ', @srvproduct ='SQL Server' GoThe return of XML data types is not supported in distributed queries2 SQL Server connects to an external data sourceConditional

1, database-contraction-log-can shrink by more than 90, but the shrinkage, the capacity is not reduced. Check the information may be the log is occupied, temporarily unable to contract;2, select Log_reuse_wait_desc from sys.databases where name = '

ifExistsSelect* fromsysobjectswhereid = object_id (N'Dbo.test_cursor') and type ='P') Drop PROCEDURE dbo.test_cursorgoset ansi_nulls ongoset quoted_identifier ongocreate PROCEDURE test_ Cursorasdeclare @acctNbr varchar ( -);D eclare @acctName

When you encounter a requirement in a project, you need to get the latest item published by the merchant in the Merchant's collection, the requirements are simple, the SQL statements are not

/********************************************************************************** function:pagedproc                                                     * * Description: * * Sql2005 paging stored procedure                                           

In SQL Server database, if the query database has the index of the specified name or foreign key constraints, etc., often use the object_id (' name ', ' type ') method, take notes as follows:? Syntax: object_id (' objectname ') or object ('

1 overviewThis article provides a brief analysis of the basic usage of as in SQL Server.2 Specific analysis2.1 Defining variable Types1 DECLARE @UserName as VARCHAR (+) = ' alan_beijing '2.2 Take aliases2.2.1 Alias for result set columnCode1 SELECT

I am also very helpless ah ...You have this skill 、、、 build a table to try?Obviously not.Check the table structure again.Front small predecessors a little pit ...SELELCT [group] from Tablle Yesshould be the [square brackets] as the character of it ..

When you restore the database, you are prompted to restore successfully, but the database in the database list appears to be being restored:You can execute this command:RESTORE DATABASE enterprisebuilding with RECOVERYUnderstanding SQL Server script

First, the use of composite index need to pay attention to the place1, the index should be built on the high selectivity of the field (the key value of the number of records/total number of records), the more selective index, the better the effect,

Distinct: Used to filter duplicate records. It is often used only to return the number of non-repeating records, rather than using it to return all values that are not re-recorded. The reason is that distinct only with double-loop query to solve,

sp_spaceusedDisplays the number of rows, reserved disk space, and disk space used by tables in the current database, or displays the disk space reserved and used by the entire database.Grammarsp_spaceused [[@objname =] ' objname '][, [@updateusage =]

Can be achieved by writing a custom function, the following provides two ways to solve:1, through regular matching, find the number in the string, one by one to spell up/*method One: one to find out*/CREATE FUNCTION [dbo].[Fun_getnumpart] ( @Str

First, the use of modules introduction and installation1. The module used by Python to operate SQL Server is pymssql.2, pymssql installation, directly using PIP install pymssql to install.Ii. introduction of Python Operations SQL Server1, database

Take the stored procedure for lesson selection as an example:To add to the jargon, a simple personal understanding: physical reads "read from memory", logical reads "Read through logical Structure", and physical reads are much less efficient than

AlwaysOn in the process of adding a database, if the Sync preferences select "Full", then the full and log backups of copyonly are performed on the primary replica to perform the restore operation on the secondary replica, and it is this operation

There are a lot of statements about how to get an index script, and the last time I had to query and get the index script in the project, I wrote a simple query statement to get it.With IdxcolAs (SELECTI.OBJECT_ID,I.INDEX_ID,object_name (i.object_id)

How to install and configure SQL Server in Centos 7.3 In the future, I will deal with Linux. I am lucky to be a loyal fan of. net in Linux, because. net core and asp.net core are already cross-platform. Today, it's okay to try the legendary Linux

SQL Server Parameter Sniffing and its improvement method, parametersniffing When processing stored procedures, SQL Server implements one compilation and reuse multiple times to save Compilation Time. The parameter sniffing problem occurs when the

In-depth analysis of SQL group by and having usage, sqlgroup I. Analysis of group by usage in SQL: The Group By statement is interpreted literally as "grouping by certain rules )". Purpose: use certain rules to divide a dataset into several small