SQL Server

DECLARE @name varchar, @newname varchar (@colname varchar) DECLARE ABC cursor for Select (a.[name] + '. ' + b.[name]) as TableName, b.[name] colname From dbo.sysobjects A, dbo.syscolumns b where a.id = b.ID and a.xtype= ' U

This article was reproduced from: http://www.cnblogs.com/sky_Great/archive/2013/01/09/2852417.htmlSQL Normal Transactionbegin TransactionTRDeclare @error int; Set @error=0; Select * fromCar_brandSet @error=@error+@ @ERROR Select 1/0 Set @error=@

Just spit it out, because the company is going to deploy a whole new system for new customers, but the company doesn't have an empty library, so it can only back up the databases that are running on the wire, and then empty the data.Here's a look at

usetempdbGO--------------------------------------------------------------------------IF object_id('Student','U') is not NULLDROP TABLEStudentGOCREATE TABLEStudent (StuidNVARCHAR(8)PRIMARY KEY, NameNVARCHAR(5) )GOINSERT intoStudent

1 Use [Database name]2 GO3 4 SETAnsi_nulls on5 GO6 7 SETQuoted_identifier on8 GO9 CREATE PROCEDURE [dbo].[Stored Procedure name]Ten @pageIndex INT, One @pageSize INT, A @totalCount INTOUTPUT - as - SETNOCOUNT on the - DECLARE

Mirroring of SQL Server database backupsA full backup can be divided into zoomed like UseMasterGOBACKUP DATABASE [Testdatabase] toDISK =N'C:\testdatabase1.bak'MIRROR to DISK =N'D:\testdatabase2.bak' withFORMAT, INITGOA full backup can be striped

object_idReturns the database object identification number of the schema-scoped object.Important NotesObjects that are not schema-scoped (such as DDL triggers) cannot be queried using OBJECT_ID. For objects that are not found in the Sys.objects

In a two-step query, the first step is to query the dynamic column, and the second step uses the pivot function.Code:List datatablelist =NewList();#regionIndexDataTable Dtevaitemtitle= db. Runtable (string. Format (@"SELECT DISTINCT eva.id, eva.name

SQL Server function Daquan Functions in SQL Server play a prominent role in improving the productivity of queries. good at using SQL functions in query work or development work will be very helpful to the work, and will greatly improve the

Let's look at an example: document_id card_holder_id created_date document_type_id 1 1 2015-7-1 1 2 4 2015-7-2 1

--Create TABLE TEST_TBL (ID varchar (primary) key nonclustered, Intcol int,datecol datetime)--=============== ===================================================================--"100w Data Test"--============================== ======================

From sqlservercentral translation Section stairways articles, set up catalogs for easy reading (2015-11 update)SQL Server Agent familyFirst SQL Server Agent overviewSecond SQL Server Agent job steps and subsystemsThird SQL Server Agent alerts and

An action method in SQL Server that copies the records from one table to the table in another database.SceneExisting database A and database B, database A has table table1, database B has table table2.Now to copy the records from the table Table1 to

Select DATEADD (Dd,datediff (DD, ' 2015-02-01 ', ' 2015-10-31 ') *rand (), ' 2015-02-01 ')Since 2015-02-012015-10-31Select SUBSTRING (CONVERT (CHAR), DATEADD (Dd,datediff (DD, ' 2015-02-01 ', ' 2015-10-31 ') *rand (), ' 2015-02-01 '), 21), 0,

GUID as the database primary key because of its disorder so performance is not good, SQL server has a function newsequentialid can generate an ordered GUID, because in the program needs to use, in C # implementation, the resulting GUID format basic

A trigger is a special type of stored procedure .The difference between a trigger and a stored procedure is that the trigger is executed automatically by an event trigger, and stored procedures can be called through the name of the stored

After deploying to SQL Server using Project Deployment model, SSISDB is responsible for managing this project,Reference documentation url:integration Services Language ReferenceHttps://msdn.microsoft.com/en-us/library/dn198335.aspxThis section

Original: SQL Server optimizes row_number () with lock hints-programmers need to knowSome of the old pages in the site still use row_number similar window functions for paging, at this time if the situation of digging graves may require a long wait

Control Panel \ All Control Panel items \ Administrative ToolsOpen "Component Services-Computer" by opening "Administrative Tools-Component Services" and right-click on "My Computer". On the MSDTC tab, click the "Security Configuration" button.In

How to solve SqlDateTime overflow and sqldatetime Overflow Error:"SqlDateTime overflow occurs during data import. It must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM ."This problem occurs mostly because the datetime field value is