SQL Server

I encountered a problem today, and finally found that it was caused by insufficient understanding of @ identity, scope_identity () and ident_current. Write it down and give a prompt to new users like me. There are two tables Table1 and Table2 at

-- Replace the original unitcodingCommunityReplace data with the new unitcodingCreate procedure DBO. sp_changeunitcoding(@ Oldunitcoding varchar (20 ),@ Newunitcoding varchar (20))AsDeclare @ returnvalue varchar (1)Begin Tran T1 -- 1Update tab_a

Question about installing SQL server2005: "SQL Server InstallationProgramUnable to get the system account information for the ASPNET account" Solution: Use the aspnet_regiis utility to uninstall and reinstall it. Specific operations: 1. Go to

Install vs2008 in win7 to develop the dnn module. "The SQL Server user instance cannot be generated due to an error in the process of starting the user instance. The connection will be closed. The following solutions are available on the Internet:

Table Name:Peishain(Warehouse receiving ticket) Table Structure: innumber char (8), indate datetime, intype char (12 ),Cangwei char (12 ),Pihao char (18), inweight decimal (9, 2), remark varchar (80) The dynamic statements built in SQL Server are

Returns the table name, index name, and number of rows. Select object_name (I. object_id) as objectname, I. [name] As indexname, sum (P. Rows) as rowcnt From SYS. Indexes I Inner join SYS. partitions P On I. object_id = P. object_id And I. index_id =

View Code create view view_job_info Select B. [name] [job name], case when B. Enabled = 1 then' enable 'else' disable 'end [Enable] , A. step_name [step name], A. Command From MSDB. DBO. sysjobsteps a inner join MSDB. DBO. sysjobs B on A. job_id = B.

A very valuable article: Http://www.sqlstudy.com/ SQL _article.php? Id = 2008060701 One of the keys is set xact_abort on. [I personally think This is the simplest and most effective method] If try catch is applied, use the following system

The most common errors in SQL Server connection: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

Step by Step 2 Use SSIS for simple Import and Export 1. Create an integration service project Open vs.net 2005, "file" -- "new" -- select business intelligence project -- select the integration service project in the template -- enter the project

Original article translated from: Simplified. We know that vbs has a winnt object in the Active Directory (ADSI) to manage local resources. You can add an administrator without using commands such as cmd. The server administrator or the

Yesterday, a friend sent a piece of SQL stored procedure (as shown below). Let me see if it can be optimized. Insert @ T1 Select g_no, co_no, si_no, str_no, sum (ind_qty) as Qty From instock_detail where in_id = @ ID group by g_no, co_no, si_no, str_

　　Iii. SQL Server unpatched vulnerabilities John's SQL Server is installed on Win 2000, with no patching and no patching, no matter how strict your permission settings are, they are all broken. The following example is an attack on the vulnerable

Http://www.cnblogs.com/changbluesky/archive/2010/05/07/1729519.html PS. Too lazy to write, too lazy to summarize, copy a good summary, but there are some not said, in short, several errors encountered when the null should be considered more test   I

-- DBO. fnsplittovarchar Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->If exists (select * From information_schema.routines where routine_name = 'fnsplittovarchar ') Begin Drop function

Create a function:Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->If exists (select * From DBO. sysobjects where id = object_id (n' [DBO]. [f_sheetname] ') and xtype in (n'fn', n'if', n'tf

The most common method to automatically generate a primary key is: 1. the identity attribute treats the original seed value as its first parameter and the increment value as its second parameter value. 2. specify your field as the unique identifier

@ Servername: return the name of the local server running SQL Server 2000.@ Remserver: return the name of the Remote SQL Server server recorded in the logon record.@ Connections: returns the number of connections or attempts to connect to the SQL

As a DBA, it not only helps developers Write Excellent query scripts, but also efficient data storage architecture. In fact, most of the time is in operation and maintenance, and most of the work time is not saturated, but why are some DBAs so busy,

Select * From sysobjects where (xtype = 'U ') Xtype = 'U' indicates the xtype char (2) object type. It can be one of the following object types:C = check ConstraintsD = default value orDefault ConstraintF = foreign key constraintL = LogFn = scalar