SQL Server

[Original source code] (01): Uses event-delegate to dynamically display the main and sub-forms, with different menus and toolbar. (Similar to SQL Server 2000 Enterprise Manager) Comments (vulnerabilities, performance, etc.) are welcome ). In

  This includes prompting pending operations, shrinking databases, compressing databases, transferring databases to new users with existing user permissions, checking backup sets, and restoring databases during installation. 1. suspend the

In order to reduce data loss caused by database server problems, the database is generally backed up, depending on the importance of data and performance compromise using different backup solutions.The general backup solution is:Full backup (once a

Several common creation methods are listed a few days ago. SQL Server Login , Login , User , System stored procedures used by roles and Groups , Of course, you also need to check Connectiongstring String SQL Server Login and database

I have always liked using window functions of SQL server2005/2008, especially the ranking function row_number. This evening, I checked the relevant documents of SQL Server development, sorted out my favorites and found two articles that have been

description: the Article In the disaster recovery series is composed of Robert Davis , released in sqlsoldier, I personally think it is quite good, so according to my own understanding, testing and sorting are not directly translated. If

I. Definition: The Stored Procedure of SQL Server is a named set of transacation-SQL statements stored on the server. It is a method for encapsulating repetitive work. Ii. Advantages of stored procedures: 1. reuse. Stored procedures can be

SQL Server Compact is a simplified version of SQL Server, which is first used for local data storage on mobile devices and embedded devices. Later, the platform support was extended to desktop computers and tablets, and now it has become an

Basic SQL server indexing knowledge (1)-basic format of Record DataHere we have collected a series of database indexing knowledge, which is a summary and review of the indexing knowledge. By summing up, you will find that many vague concepts are

Document directory General Solution (low efficiency) Efficiency Analysis Use connection Data Preparation References Http://hi.baidu.com/zdfgng/blog/item/dd5f88359a1cd0260b55a9ce.htmlQuestion How to query records that exist in Table A but do

References Monitoring with SQL profilerReadtrace There is a profiler tool in SQL Server to track the execution process of SQL Server and monitor all the processes of SQL Server. If SSMs is used to operate SQL Server, the commands corresponding to

1. Common date methods (the following getdate () = '2017-11-08 13:37:56. 123 ') (1) datename (datepart, date) Returns the string that represents the specified date part of the specified date. For details about datepart, see the following

SQL Server: security design starts from scratch 8:12:42 Source: dynamic website production guide author: Anonymous [For Me] [recommended] [print] [closed] Developers and administrators often constantly consider program

If you have a shopping website, how do you recommend products to your customers? This function is available on many e-commerce websites. You can easily build similar functions through the data mining feature of SQL Server Analysis Services.   It is

A friend changed his notebook and appended the database of SQL Server 2005 that was originally backed up to report "trying to open or create a physical file"... ", create file encountered an operating system error 5 (Access denied .). (Microsoft SQL

Northwind database Here we can find a breakthrough:   Http://social.msdn.microsoft.com/Forums/zh-CN/Vsexpressvb/thread/8490a1c6-9018-40c9-aafb-df9f79d29cde   The following is MSDN: Http://msdn2.microsoft.com/en-us/library/ms227484 (VS.80).

A person asked me a few days ago about the duplicate serial number. I thought about it. Although it is simple but extensive, I wrote this blog to introduce it and hope it will help you. When developing database applications, you will often encounter

Recently, many people have asked questions about online SQL management, and modified and shared a previous open source SQL online management tool. See:             Original Project address: http://sourceforge.net/projects/asp-ent-man/files/

1. usage of the Case Function(1) Use the following commands: switch-case and if-else if.(2) Syntax:Case [field]When expression then display dataWhen expression then display dataElse display dataEnd(3) percent conversion of Quality Education1) We

Unicode Character Set is generated to solve the incompatibility problem of character sets. All its characters are expressed in two bytes, that is, English characters are also expressed in two bytes. If you are still struggling with this issue, let's