Tag：Server database
-
Time：2021-2-3
In the SQL Server database operation, the following errors occurred when copying the database. The error information is shown in the following figure: Reasons and solutions of SQL Server database replication failure What is the reason for the above prompt? After some deliberation, the author finally found the above reasons. reason:When copying a database, the […]
-
Time：2021-1-29
In the daily database operation, we often back up the database, so as to restore the database in case of database disaster, so as to ensure the security of the database. SQL Server database using enterprise manager can be simple and intuitive to complete these operations, but also can automatically back up the database every […]
-
Time：2021-1-28
When querying SQL Server database, can you find out the number of records by percentage? The answer is yes. In this paper, we introduce this method. The code to realize this function is as follows: create procedure pro_topPercent ( @Ipercent [int] = 0 — not returned by default ) as begin select top (@ipercent ) […]
-
Time：2020-8-7
Recently, because I want to connect to the SQL Server database on vs code, I tried for the first time. I used JDBC to connect to the database when I used java. I felt that I used vs Code connection to the database steps to be simple, online blog is not particularly many, by the […]
-
Time：2020-3-24
In this paper, the method of modifying SQL Server database logical name, database name and physical name by T-SQL statement is introduced. To share with you for your reference, as follows: Changing the writing method of physical file name sql statement of MSSQL database Note: in the activity monitor, make sure that no process is […]
-
Time：2020-1-12
Because of the work needs, to analyze the data stored on SQL server, we have to study how to use ruby to access SQL server, and find that it is still very simple: Installing freetds Download freetds source code Decompress, compile and install: Copy codeThe code is as follows: ./configure –prefix=/usr/local/freetds && make && sudo […]
