Category：MsSql
-
Time：2019-8-24
Mysql password forgetting solution in MAC Recently, MySQL has been used in the project. I installed one before, but I forgot the password I set up at that time. Then I embarked on a rough road to modify the password. After Baidu and Google had a pile of data, they still found that there were […]
-
Time：2019-8-24
1. Converting time to string form: Copy codeThe code is as follows: Convert (varchar, field name, 120) – – – —– yyyy-mm-ddhh: ss: mm0000Convert (char (10), field name, 120) – – yyyy-mm-dd 2If you use SQL editor (Microsoft’s own tool), you don’t need to use function conversion for query dates, such asSql code Copy codeThe […]
-
Time：2019-8-24
[System Environment] windows 2003 +sql2005 [Problem Status] Users can cause SQL2005 performance monitor counter errors after improper deletion of SQL2005, as shown below [Solutions] 1. Enter regedit in Start – > Run, open Registry Editor, and locate at [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib In the tree directory on the right, you can see that Perflib has two subdirectories, […]
-
Time：2019-8-23
Not much to say, please see the code: SQLServer Procedure Pagination_basic： ALTER PROCEDURE [qiancheng].[Pagination_basic] ( @Table_name VARCHAR (255), –name of table @Rows_target VARCHAR (1000) = ‘*’, –search rows @Rows_condition VARCHAR (1000) = ”, –the condition to find target (no where) @Rows_order VARCHAR (255) = ”, –the rows to rank @Order_type INT = 0, — *Q*C* […]
-
Time：2019-8-23
See many people on the Internet ask why my SQL 2008 can only use server calculator name login, but not IP login? I have also met this question. I see that the answers on the Internet have their own merits, but none of them are easy to write. After some searching, sorting and trying for […]
-
Time：2019-8-23
Starting from SQL Server 2005, a new data type, XML type, has been provided, which allows users to store data directly into data tables in the form of XML files. With the use of Linq to Sql in ASP.NET, we can easily store XML files in the SQL Server database. But by default, if you […]
-
Time：2019-8-22
When any query is executed, the SQL Server reads the data into memory. When the data is used, it will not be released immediately. Instead, it will be cached in the memory Buffer. When the same query is executed again, if all the required data is cached in memory, then the SQL Server will not […]
-
Time：2019-8-22
After some friends install SQL Server 2008, most of them will encounter connection errors. Especially for novices like us, they are so depressed that they can hardly pretend to play and then have problems. This article is intended to solve the problem that the installation step is not a problem, but the login is not […]
-
Time：2019-8-22
The code for modifying the SA account name of the database is as follows: Copy codeThe code is as follows: Alter LOGIN sa DISABLE Alter LOGIN sa WITH NAME = [systemAccount] “System Account” is the new name of SA. Upon completion of execution, you can refresh the login name on the right side to see […]
-
Time：2019-8-21
There are several ways to prevent concurrent insertion of duplicate data in SQL Server. 1. Using Primary Key, Unique Key and so on, duplicate data can not be inserted at the database level. 2. Conditions for insertion insert into Table(****) select **** where not exists(select 1 from Table where ****); 3. Use SERIALIZABLE isolation level […]
-
Time：2019-8-21
This error occurred the other day while attaching the database. When using sql2008 for additional database on win7 x64 system (including database files being used in x86 system and directly copying attached to X64 system), prompt can not open file, 5120 error. The reason for this error is that there is no operation […]
-
Time：2019-8-21
Installation steps of SQL 2005 Install Microsoft SQL Server 2005 database steps: Step 1: Place the Microsoft SQL Server 2000 installation CD into the CD-ROM. Under the CD-ROM directory, click Setup.exe installer to start the installation process. Or install files using mirrors. Select “X86-based Operating System”. Step 2: Select and install Server Components, […]
