SQL Server

First, the business scenarioWe encountered the need to retrieve subtree data for a parent-child relationship in a real-world production environmentIt is estimated that you have encountered a similar scenario, most typical of which is the provincial

What is a stored procedure?A stored procedure is one or more SQL commands that are stored as executable objects in the database.In layman's terms: a stored procedure is actually a set of SQL statements that can perform certain operations.So why use

Call SQL to perform automatic backup by job, you can solve the problem of forgetting to back up the database, recordDECLARE @FileFullName varchar;d eclare @FileName varchar;d eclare @ExecSql varchar;--declare @Filesuffix varchar ($);--@Filesuffix = '

First, backgroundThe problem we are experiencing is as follows: The automatic growth of the unwarranted end is increased in proportion to this ratio;650) this.width=650; "title=" image "src=" http://images.cnitblog.com/blog/48305/201308/ 07123224-0e5

It is common to use MD5 encryption in SQL, but it is not known that people who pay attention to it will be wrong even if they are writing on a copy network.For example, a simple explanation:We can find the same string but the resulting MD5

1. Defining the table structureCreate a new database table Communicateitem in MSSM and define one of the fields Itemcontentxml as XML type2. Edit the table data and add a row to find that the XML type cannot be entered by the designer.You need to

SQLSERVER2008 does not support the keyword limit, so its paged SQL query statements will not be in the way of MySQL, fortunately sqlserver2008 provides the top,rownumber and other keywords, so that can be achieved through the several key words

converting data to occurMsg 8115, Level 16, State 6, line 1thAn arithmetic overflow error occurred while converting nvarchar to data type numeric.Nvarchar is with a long decimal, directly converted to decimal failedSolution:Convert to float and

One, SQL Server table data copied to Excel1, new query, with SQL statements to read out the table data2, then, select the data, right-click, copy (also can be clicked together with the title copy), copied into Notepad (otherwise garbled)3, then copy

Yesterday when the project, encountered the title problem, code tracking SQL statements copied out in the database can not be executed,And then write the exact same, and then in the assignment to the code, or the same error,Just don't know where the

When you partition the table in SQL Server, it must involve files and filegroups, about how files and filegroups are created on the Internet a lot of information, my blog also has two related reprint documents, you can see, I this is no longer

MS SQL Server Database connection string detailedC # Connection string set timeout timeSqlconnection.connectiontimeout and Sqlcommand.commandtimeout and Sqlbulkcopy.bulkcopytimeout propertiesHttps://msdn.microsoft.com/zh-cn/library/8xx3tyca.aspx SQL

Considerations for Optimizing Databases:1. Index key fields.2. Using stored procedures, it makes SQL more flexible and efficient.3. Back up the database and clean up junk data.4. Optimization of SQL statement syntax. (You can use Sybase's SQL Expert,

Project backgroundWindows-certified Web application, LocalDB created through Visual Studio 2013 is located in the App_Data directoryPhenomenonThere is no problem with local debugging. After publishing to the server (Windows server 2008R2, IIS7.5),

First big class: Integer dataThe Bit:bit data type represents 0,1 or null, which means true,false. Consumes 1byte.int: The positive and negative numbers are stored in 4 bytes. Storage range: -2^31 to 2^31-1.SmallInt: Stores the positive and negative

Collect and organize SQL Server database optimization experience and precautions There are many tutorials on SQL Optimization on the Internet, but they are messy. I have made some preparations recently, and I will share some of them with you. There

Graphic Tutorial: How to export the mssqlserver database to another database, The following illustration shows how to export a mssqlserver database to another database. For more information, see the following. 1. Prepare the source database, find

Usage of the merge function in SQLServer, sqlservermerge The Merge keyword is a magic DML keyword. It is introduced in SQL Server 2008. It can combine Insert, Update, and Delete into a simple sentence. MSDN's explanation of Merge is very short and

Detailed description of SQL statement execution sequence and SQL statement execution sequence Most of us do not need to deal with databases when we develop software. Especially for erp development, we have to deal with databases more frequently,

How to migrate sqlserver data to the mysql database and precautions: sqlservermysql During project development, sometimes the database used at the beginning of the project is SQL Server, and the stored database is changed to MySQL, so the data of