SQL Server

Syntax: Use convert: Convert (data_type [(length)], expression [, style]) Example:Select convert (varchar, getdate (), 120)11:06:08 Select Replace (replace (convert (varchar, getdate (), 120 ),\'-\',\'\'),\'\', \'\'),\':\',\'\')200409121106

Introduction Transaction logs in SQL Server are undoubtedly one of the most important parts of SQL Server. Because SQL server uses transaction logs to ensure durability and transaction rollback ). This also partially ensures the acid attribute of

View code Set Statistics Io On Set Statistics Time On Go Select Top 100000 * From ( Select Top 190000 * From Job_job Order By Jobid ASC ) As A Order By Jobid Desc Go Set Statistics Profile Off Set Statistics Io

Before reading this article, make sure you have read the previous article.Article, Article address: Understanding the permission system in SQL Server (I)-Subject   Introduction In the previous article, I fully explained the concept of the

Use the user connections option to specify the maximum number of users allowed to connect to Microsoft SQL server at the same time. The actual number of user connections allowed depends on the SQL Server version in use and the application.ProgramAnd

SQL Server do's and dont's Http://www.codeproject.com/cs/database/sqldodont.asp 1. performance problems are generally optimized when they occur. However, there should be tests targeting a large amount of data to find potential performance

    Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> 1 ). % Set Conn = Server. Createobject ( " ADODB. Connection " )Conn. Open " Driver = {SQL Server };server = (local);

1. SQL Server System database Introduction SQL Server has four important system-level databases: Master, model, MSDB, and tempdb. MASTER: records all system-level information of the SQL Server System, including metadata of the instance range,

Copyright: Original Works are allowed to be reproduced. During reprinting, be sure to mark them as hyperlinks. Article Original source, author information, and this statement. Otherwise, legal liability will be held.

  Fixed the following three bugs on May 18,: the file storage content is empty, the DB list is accumulated repeatedly, and the table performs foreign key Association on itself and exits abnormally.   Running environment: Dot NET 2.0 or above

The most common usage of an execute statement is to execute the stored procedure. However, he still has more powerful and extensive use methods. 1. Execute the Stored Procedure Stored Procedure names support four object names: nominal value,

It took two days. 'Function name: parsesrc'Function: analyze the SQL Server Stored Procedure execution statement "procedurename par1, par2,..." Whether the syntax is correct.'Input parameter: SRC as string, for example, "proceduretest' string

In sqlserver, there is a system stored procedure: sp_recompile, which can force re-compile the execution plan for the SQL statements related to access to recompile [stored procedure, trigger, table, view!   IfObjectIs the name of the stored

Log loss, only MDF is left, and then the following process is performed (it does not seem to work on sql2005 ):1. Create a database with the same name2. Stop SQL server again (do not detach the database)3. overwrite the new database with the data

During the installation of SQL Server 2003 in XP and Server 2000 systems, after you click "Install", the installation page does not appear until you check the installation process. Solution: Restart the machine, or terminate two SQL processes in

  1. "SQL server does not exist or access is denied"This is the most complex. There are many causes of errors and there are many aspects to check.Generally, there are several possibilities:1. incorrect spelling of the SQL server name or IP address2.

Declare @ serverip varchar (50) -- Server IP AddressDeclare @ serverothername varchar (50) -- alias of the accessed ServerDeclare @ loginuser varchar (50) -- accountDeclare @ loginpassword varchar (50) -- Password Set @ serverip = '192. 8.28.9'Set

Reprinted fromHttp://www.cnblogs.com/wyforumid/archive/2008/02/22/1077690.html Use transactions in the stored procedure. The following is a template: Create procedure testpro as /** // * ------- transaction start ---------- */

This article starts from the definition and explains how to develop your own triggers in detail. Create a simple trigger A trigger is a special stored procedure, similar to an event function, SQL Server? Allows the creation of triggers for INSERT,

The statement for compressing a database is as follows:   CREATE Procedure [dbo]. [sp_Compress]AS BEGINDECLARE @ db_name varchar (200)Set @ db_name = 'dangjiae '-- Database NameDump transaction @ db_name WITH NO_LOGBackup log @ db_name WITH