SQL Server

The first method: Copy Code code as follows: /* Create a linked server /* exec sp_addlinkedserver ' srv_lnk ', ', ' SQLOLEDB ', ' Barcode database IP address ' exec sp_addlinkedsrvlogin ' Srv_lnk ', ' false ', NULL, ' username ', '

There are two major storage needs for a database: data pages and index pages. It is fairly straightforward to understand and view the actual data in your table . Run some query examples to see which columns are used and what type of data is actually

According to the design practice, the query when the master table through the Keyword Field Association query, the query statement is as follows: Select Top 1000 a.word,a.queryurl,a.irank,a.title,a.baiduurl,a.itraffic1,a.itraffic2,b.ibaiduindex

When you restore a database from a database backup, you find that the log file actually has more than 120 g, not through the SQL management, resolute use DBCC statement cleanup success! Free space! and clear and speed! First of all, it's important

/*Use method, execute directly, pass in parameter (series_guid, query condition) return a datasetSuch as:Query all products under the CYLINDRICAL1 seriesDbo. P_getseriesproductdetail ' Cylindrical1 ', 'Query series Cylindrical1 products containing

1, first log in with Windows Authentication, and then under Object Explorer, select the topmost server, right-click its properties, select Security on the left, change Windows mode to SQL Server and Windows Authentication mode, and the following

The specified field in SQL Server displays a fixed length, which is often used when displaying data, but has a bad memory and often forgets. So write this so that when it is useful, pick it up. For example, there is a article table with 3 fields

(1). With the advent of the big data age, data plays an increasingly important role in our lives, and we are increasingly dependent on data. Therefore, it is a very important technology to study and master the relevant knowledge of database and to

Get, add, modify, delete SQL Server field descriptions Select O.name as TableName, c.name as ColumnName, P.[value] as Description From Sysproperties P INNER JOIN sysobjects o on o.id = p.id INNER JOIN syscolumns C on p.id = c.id and p.smallid =

Long-term modification or deletion of a table can produce a large amount of fragmentation that affects database performance. The solution is to rebuild the table or index, eliminate fragmentation, and achieve optimization. Directly on the code: *

We can maintain multiple copies of multiple data across the LAN and the Internet over different database servers through data replication, while ensuring data consistency between copies in a synchronous or asynchronous manner. SQL Server provides

Access developers to SQL Server face many difficulties, but the most intractable problem is the processing of dynamic SQL. In Access, it is fairly common to designate the row of a control as a string. For example, a form contains many selectors

When running SQL Server on a server, we always try to keep SQL Server from the intrusion of illegal users, deny it access to the database, and ensure the security of the data. SQL Server provides powerful built-in security and data protection to

On the database backup recovery principle, we are more or less familiar with. But how reliable are your current database backups? Can you sleep at ease? If the answer is yes, then there is no need to spend more time to see the following, if you feel

The server| server uses a reference that first adds the SQLDMO object, SQLDMO is a COM object, not. NET objects The following function returns an array of lists of SQL Server servers in the local area network. Private string[] Getallservers

asp.net|server| Schema | Data #region Constructors Public scoresetting () { } Overloaded constructors integral setting id public scoresetting (int id) { This.id=id; } #endregion #region Public methods Get integration setup

server|sqlserver| Data | database Preparation of database log tables Prepare one of these tables in the database, Mail_web_log: Build script: CREATE TABLE [dbo]. [Mail_web_log] ( [NId] [INT] IDENTITY (1, 1) not NULL, [Dtdate] [DateTime] Not

Asp.net|server|sqlserver Introduction: This article is my follow-up to "How to save pictures in SQL Server". I suggest that you take a look at the article before you read it. Reading a picture is much simpler than storing it. Output a picture all we

Server| stored procedure yesterday, an old classmate who had never met, suddenly asked how to call SQL stored procedures in VB. At that time because there is no information on the hand, the machine also did not install SQL, then sent an early

Asp.net|server is much simpler to read than to store a picture. Output a picture all we have to do is use the BinaryWrite method of the Response object. Format the picture at the same time. In this article, we'll discuss how to retrieve a picture