SQL Server

After you create a new database or attach a database, you want to add a relational table, resulting in the following error:The database diagram support object cannot be installed because this database does not have a valid owner. To continue, first

Personal experience of a project, the boss suddenly proposed that the database of the debt to implement a diversion, a database one responsible for reading, and the other responsible for writing, background is required to synchronize the state of

Is it a tragedy that you have a situation in which you export a database, go back home and import your own computer, and then find that the database version does not match?The following approach avoids this tragedy by exporting the data as a script,

A long time ago when we write SQL, the most feared one thing is the SQL inexplicable wonderful super slow, slow is a pipe back, the small ball is still turning ... This worry is only for the partiesUnderstand, later heard that there is a "evaluation

The functionality of the transaction has been in SQL Server for a long time, because it has recently been a data synchronization scheme, so there is a chance to study it again and snapshots, and found that there are a lot of good features and

In previous customer consultation cases, many client applications connected SQL Server directly with the SA account. If you are a little more strict with database management, you should not give the application this permission, usually the

Paging in SQL Server is required in recent projects, and paging query statements need to be written. I've written some statements about paged queries before, but the performance is not flattering. So during business hours, a foreigner wrote an

Select the database that needs to shrink the log, right-click Properties-Options, and change the recovery mode to simple.650) this.width=650; "title=" QQ picture 20141229141044.jpg "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M01/57/A1

Provides special connection information as part of a four-part object name without using the linked server nameThis article gives an SQL statement to show the query between different databases on the same server, noting that the current connected

1. The column in the select list is not valid because the column is not contained in an aggregate function or a GROUP by clauseA: When you specify group BY, all columns in any non-aggregate expression in the selection list should be included in the

Create TRIGGER [dbo]. [Tr_customer_info]on [dbo]. [T_customer_info]After UPDATEAsBeginif ((((select Bank_number from inserted) <> (select Bank_number from deleted)or ((select Mobile_phone from inserted) <> (select Mobile_phone from deleted)or

The DBCC (database Base consistency Checker, DB consistency checker) commands are used to verify database integrity, find errors, and analyze system usage.1. DBCC CheckallocChecks the consistency of the disk space allocation structure for the

There are questions about indexing failures in the database, and there are related discussions on the web. However, they were discussed for the Oracle database. So when is the index in the SQL Server databaseWill fail. Sum up, but I haven't been

I. Debugging SQL Server 20001. Set up your account. locate MSSQLServer in the Windows service, double-click the Pop-up dialog box. Select the "Login" tab, select "This Account" and enter an administrator account and password. Restart the service.2.

Both the database and C # are nullable types. Assign a value of nullparameters[9] to the field directly. Value = null; the execution of the error, a lot of, in short, it is a parameter less. Use the SQL Server Profiler tool to view the execution

Partition (Split)Add a new partition on an existing partition.As shown, split partition 03 into 03 and 04 partitions, the Split method first locks all the data of the old 03 partition, and then migrates the old 03 partition related data to partition

SQL ServerReplace Null:isnull (Arg,value)For example: Select IsNull (price,0.0) from orders, if Price is null, replace with 0.0Compared to null: is not null,is nullsuch as SELECT * from orders where price is null and price equals NULLFor example:

After SQL Server 2008 is installed,The connection to the local database is not a problem, the connection to the remote database is reported that the request cannot retrieve data. MICROSOFT.SQLSERVER.MANAGEMENT.SDK.SFC An exception occurred while

--Under the sql2005, sql2000 can notCREATE TABLE TB (ID int,name varchar (4))Insert TB Select 1, ' AA 'UNION ALL Select 1, ' AA 'UNION ALL Select 2, ' BB 'UNION ALL select 3, ' BB 'UNION ALL Select 4, ' CC 'UNION ALL Select 1, ' AA 'UNION ALL Select

1. Using functionsGoCREATE FUNCTION Dbo.fn_sumtype (@type varchar (50))RETURNS varchar (8000)AsBEGINDECLARE @values varchar (8000)SET @values = ' 'SELECT @values = @values + ', ' + Product_type from [DataCopy2] WHERE [email protected]RETURN STUFF