SQL Server

If our statement is:? 12345678910111213 IF NOT EXISTS(SELECT 1 FROM sys.views WHERE name=‘Report_IndividualTicket‘) BEGINcreate view Report_IndividualTicket asSELECT Ticket.TicketNumber, Ticket.TicketID, GisProcess.StageName,

Workaround:One, locate the MSDE directory in the SQL Server installation disk, and click setup.exe to install it.Second, after installation, restart the system windowsxp, you can see the SQL Service icon appears.Third, install the Autorun.exe in the

In SQL Server, for data security reasons, you need to back up the database on a regular basis. While the backup database is usually in the early hours of the basic no database operation, so we can not ask the administrator every day to the night 1 o'

CREATE FUNCTION D_byteexchanges_byte (@str NVARCHAR (4000),--the string to convert@flag bit-conversion flag, 0 converted to half angle, 1 conversion to perfect angle) RETURNS nvarchar (4000)AsBEGINDECLARE @pat nvarchar (8), @step int,@i int, @spc

Ext.: http://www.cnblogs.com/moss_tan_jun/archive/2011/11/26/2263988.htmlThe cursor is evil!In a relational database, our thinking about queries is set-oriented. The cursor breaks this rule, and the cursor makes us think in a progressive way. For

long time no use of SQL Server, start SQL today, found that the service failed to start, error is as follows: ... Error 1069-(the service could not be started because of a logon failure.) ) , Baidu a bit, the solution is as follows:Follow these

When we write the query, in order to performance, tend to add a nolockbehind the table, or with (nolock), the purpose is to query is not locked table, so as to improve the query speed. What is concurrent access : More than one user accesses the same

The optimizer chooses which execution plan is selected based on the extinction and is related to the row count statistics, which are automatically generated by default in the process of optimization.Once the column is marked for statistical

Pre-Preparation:CREATE TABLE Nums (X int);CREATE TABLE T (X int);GoPurpose: Insert the table Nums | Delete | The update is reflected in the T table.------------------------------------------------------------------------------------------------------

Plan to make a back word Web application, very not successfully found the resources, to get a. bak file, import to SQL Server is simple, now I want to take the data to Mongolab, encountered some pits, specially recorded (old, can't remember

Based on performance considerations, the database engine performs changes to the database data pages (pages) in memory (buffer cache) and does not write the modified page back to disk after each modification. More accurately, the database engine

All along, MySQL because of open source, the birth of many expansion programs, like Amoeba, Atlas, Cobar, Mysqlproxy, etc., mostly based on the MySQL communication protocol to customize the solution, so we envy envy, but no way, Microsoft does not

In SQL SERVER 2008, BACKUP Log with TRUNCATE_ONLY is no longer supported, and to shrink the database log, you first need to truncate the file by setting the database recovery mode to simple.The statements are as follows:Use DATABASENAME;GO--Truncate

Set ANSI_NULLS onSET QUOTED_IDENTIFIER ONGoALTER TRIGGER [Insertreplytoic]on [dbo]. [Bbsreplytopic]After insertAsBEGIN--set NOCOUNT on;--Insert statements for trigger heredeclare @uid int, @topicId int, @Rcontent nvarchar (max), @Rtime datetime,

The first step,Scenario where the error occurredStep Two,Find the cause of the error1th Step,View the Windows log file. Run the input eventvwr (Event Viewer) to open the log file Viewer,The third step,Solution, from the second step we can see that

01.CreateCREATE TABLE Strings (ID int);Go02.Add columns to a tableALTER TABLE StringsAdd String nvarchar (32);Go03.Adding calculated columnsALTER TABLE StringsAdd ID2 as (id+1);Go---See there's no need to specify type here.04.Modify DefinitionALTER

Summary: Sometimes SQL Server built-in functions are not so useful, you can reference the external assembly, under the ugly, do add external assembly operations1, prepare the program, compile a myclr DLL. Public class Clrclass { [Microsoft.

/* 数据如下： name val memo a    2   a2(a的第二个值) a    1   a1--a的第一个值 a    3   a3:a的第三个值 b    1   b1--b的第一个值 b    3   b3:b的第三个值 b    2   b2b2b2b2 b    4   b4b4 b    5   b5b5b5b5b5 */--创建表并插入数据： create table tb(name varchar(10),val int,memo varchar(20))

Environment: Win7 x86 has installed VC 6.0 vs2010System.Configuration.ConfigurationErrorsException: Create usersettings/ Error Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings configuration section handler: Failed to load file or

Today to help test students to solve the database can not delete the problem, the process is as follows:1, delete the database is, the database into single-user mode, and can not be deleted, such as:650) this.width=650; "title=" 1.png "alt="