SQL Server

Delete:1. Heap table: When rows are deleted, the space on the page is not automatically re-organized. Deleting rows is not deleted from the physical page.Instead, just set the row offset to 0. Indicates that the space is not used. In addition to the

C # synchronizes SQL Server database SCHEMA1. Write a SQL processing class first:Using system;using system.collections.generic;using system.data;using system.data.sqlclient;using System.Text; Namespace Pinkdatabasesync{class

--Add columnsIF not EXISTS (SELECT * from syscolumns WHERE id=object_id (' tbl_tranwoandcochistorybyrailassure ') and name= ' CreatedDate ' )BEGINALTER TABLE Tbl_tranwoandcochistorybyrailassureADD createddate DATETIME not NULL DEFAULT GETDATE ()END--

Once a friend asked me that the data has been deleted, not the use of third-party tools can check when it happened. SQL Server provides a undocumented function Fn_dblog lets us view the active transaction log.The syntax is as follows::: Fn_dblog

First, install FreeTDS 1, install the compiler tools and driversYum install make apr* autoconf automake gcc gcc-c++ wget2. Install UNIXODBC DriverYum-y Install UnixODBC Unixodbc-devel3, installation FreeTDSCd/usr/local/srcwget

We know that the datetime type in this SQL Server database is a data type that is often used in database application development, and the C # language also has a DateTime type, although both are used to describe time, but their default values are

SQL Server R2 How to open a remote connection to a databaseSQL Server 2005 and later versions do not allow remote connections, and if you want to connect to SQL Server 2008 on a remote server using SSMS locally, connect to the database remotely. You

Issue information: " a network-related or instance-specific error occurred while establishing a connection to SQL Server. The service was not found or could not be interviewed . Verify that the instance name is correct and that SQL Server is

Background knowledge:Lock escalation Roadmap, row-to-page (extent)-to-zone (table partitioning)-and table;ALTER TABLE controls the escalation behavior of the lock:1. The default behavior in table SQL Server 2008, when set to this value, enables lock

Background knowledge:Partitioned tables, you can save the data in a table to a different filegroup by scope.Let's take an example:Data saved to filegroup a before 20142014~2015 data is saved to filegroup bData after 2015 is saved to filegroup

Triggers can do a lot of things, but it also brings a lot of problems. The trick to using it is to use it at the right time, rather than using it at an inappropriate time.Some common uses for triggers are as follows: Elastic referential

First, backgroundA friend of the previous time group asked a question: "Add an increment sequence to the query, such as: 0x00000001, that is, each is a 36-digit (0-9,A--Z), and 0x0000000z is followed by 0x00000010, creating a mapping table like the

Recently, I have used the operation of SQL Server database to do something. Well, really long time did not see, to this database is unfamiliar to the pole, even the simplest how to set an ID primary key, let it with the insertion of data, automatic

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 {

--Create a tableCreate TableTable (A1varchar(Ten), A2Char(2))--add descriptive information to a tableEXECUTESp_addextendedproperty N'ms_description','Personnel Information Sheet'N'User'N'dbo'N'Table'N'Table',NULL,NULL--Add descriptive information

1. First determine your own IIS no problem2, second to determine their own SQL Server no problemThen in the IIS folder Wwwroot, create a file named Testsqlserver.asp, write code such as the following can be spt_values lines:" &rs.recordcount& "") '

Original: SQL Server add linked serverBackgroundIn SQL Server, if we query the database to associate a table in another database, in this case we can do so by adding a server link.Case List Mode 1. SQL Server provides a graphical interface, as

One of the most important commands in SQL Server is checkpoint, which is primarily to write data from the cache into an MDF file.In fact, when we do insert, UPDATE, delete, the data is not directly written to the database corresponding to the MDF

SQL statement ResultsSELECT CONVERT (varchar ( -), GETDATE (), 0)--10:57amSELECT CONVERT (varchar), GETDATE (), 1)--05/03/10SELECT CONVERT (varchar), GETDATE (), 2)--10.05.03SELECT CONVERT (varchar), GETDATE (), 3)--03/05/10SELECT CONVERT (varchar),

Action type executeworkflowaction invalid for workflowidentity element, the only valid operation type is executeworkflowactionError code: 0X84B20001 The cause of this error is to open directly with WinRAR, click on the inside of the setup.exe to