SQL Server

The first step is to use Sp_who2 to isolate the SID of the backup (or in the connection properties in the window)exec Sp_who2Second, use the following query to get the run (see percent_complete column)SELECT session_id, request_id, start_time,

The situation I encountered was such that the site was planted on a trojan, Stole my Web. config file, the database connection string in the Web. config file is not encrypted, and my database remote connection does not have IP restrictions, the

CREATE TABLE #DBNAME (ID int identity (DBNAME), nvarchar (100))CREATE TABLE #BAK (ID int identity (), BAK nvarchar (120))DECLARE @BakDir nvarchar (+) = ' dir/b/a:d G:\sqldata\mssql\backup\ 'DECLARE @DelStr nvarchar (2000)INSERT into #DBNAMEEXEC

1) Update table (another table)A) Easy to type, update efficiency:Update table1 set field1=table2.field1,field2=table2.field2 from table2 where table1.id=table2.idb) Conventional way, this is equivalent to a left join, in the outside where is the

Java connection MySQL:First import the jar package file:　　: http://download.csdn.net/detail/chongzi321/5703641And then:　　　　1Connection ct =NULL; 2Statement SM =NULL; 3ResultSet rs =NULL;4 5 Try{ 6Class.forName

Remove whitespaceLTRIM (' content '): Remove the space to the left of the stringRTRIM (' content '): Remove the space on the rightLTRIM (RTRIM (' content ')): Remove the left and right spaces of the stringREPLACE (' content ', ' ', '): Remove all

SQL Server BasicsFirst, the basic knowledge(1), Storage structure: Database--table--Data(2), Management databaseAdd: Create DATABASE nameDelete: Drop database nameQuery: Select name from Master. sysdatabasesModify: Alter DATABASE name (modify the

SQL Server 2012 installation process is very long, there are many interfaces are not intercepted, I respectively in Win7 Enterprise Edition 64-bit and WIN10 Professional Edition SP1 64 bit installed SQL Server 2012, no problem.1. Install the feature

----------full backup and restore------------Full backup database--Backup database studb to disk= ' E:\stu.bak 'Backup log studb to disk= ' E:\stu_log.bak 'Use masterGo--Restore Library--Restore database Studb from disk= ' E:\stu.bak ' with

One, the connectionquery with a connection when there is more than one table in the result set1. Internal connection:multiple tables connected according to public columns, eligible for display, non-eligible for display2. External connection:Multiple

Write about the search function in the program in the near period of time. There is the keyword between, which is used to MS SQL Server, which is the data between the search range of values (including itself).There are some things to be aware of

Transferred from: http://www.cnblogs.com/huangxincheng/p/4227483.htmlA long time ago when we write SQL, the most feared one thing is the SQL inexplicable wonderful super slow, slow is a pipe back, the small ball is still turning ... This worry is

Usage Environment: Operating system: WINDOW7 database: SQL Server2005, MySql5.01, installing MySQL ODBC driver on server with SQL Server installed: Download link: http://dev.mysql.com/ downloads/mirror.php?id=376346 points in the past will be linked

SET IDENTITY_INSERT table name on--allows inserting the specified data into the self-increment column Id INSERT INTO table_name (ID,NAME) VALUES (1, ' Test ') set IDENTITY_INSERT table name off--close Inserts the specified data for the

----------------------the paging stored procedure--------------------------------------------------------------------------------------------- -------CREATE PROCEDURE [dbo]. [Proc_page] @PageIndex int = 1,                    --current page @pagesize

Declare qc_cursor cursor SCROLL optimistic forSelect SiteName from Tb_vhostcheckOpen Qc_cursordeclare @siteName nvarchar (50)While @ @fetch_status =0Begin FETCH NEXT from Qc_cursor to @siteName--print @siteNameIf not exists (select 1 from vhhostlist

The SQL Server replication divides large transactions into small transaction distribution methods. In SQL server replication, when a large transaction is executed in the published database, for example, 100,000 or more data is operated at a time.

The method for querying SQL data by PAGE and the method for querying SQL data by PAGE I recently learned about SQL paging queries and summarized the following methods. First, a table is created and some test data is inserted at will. The table

SQL Server restores the master database and sqlmaster database by means of Reconstruction SQL Server restores the master database through reconstruction. The details are as follows: 1. Back up the master database 2. Stop the service and

Detailed description and implementation code of SqlServer English word full match, sqlserver full match SqlServer English word full match Environment: Vs2013 + SQL Server2012 Problem: the current database records are as follows:   The Sentence