Tag：server
-
Time：2020-2-18
In this paper, an example is given to illustrate the method of SQL server data table field self defining and auto increasing data format. To share with you for your reference, as follows: –Modify the field companyid Custom Auto increment constraint in the data table sys company ALTER TABLE [dbo].[SYS_Company] Add Constraint DF_SYS_Company_CompanyId DEFAULT ([dbo].[f_PrimaryCode_SYS_Company]()) […]
-
Time：2020-2-17
How to make activiti Explorer use SQL Server database The war file of activiti Explorer downloaded from the official website uses H2 memory database by default. If you want to use other databases for persistence, such as SQL server, you need to make the following configuration. 1) Modify db.properties file Route:C:\apache-tomcat-7.0.64\webapps\activiti-explorer\WEB-INF\classes\db.properties The contents are as […]
-
Time：2020-2-13
Filetable is a feature based on FileStream. It has the following functions: • a line represents a file or directory. • each line contains the following information: • file stream data, stream ID identifier (GUID). • user represents and maintains path locators and parent path locators for file and directory hierarchies • 10 file attributes […]
-
Time：2020-2-13
MySQL Community ServerIt is a free download version of the most popular open source database in the world, which is actively supported by an open source developer and enthusiast community. MySQL community server is the database server of MySQL Community Edition, namely database software;Supports 32-bit and 64 bit！ introduce MySQL is an open source relational […]
-
Time：2020-2-12
1. Error information description HTTP Status 500 – Internal Server Error MESSAGE :Request processing failed; nested exception is com.sun.jersey.api.client.UniformInterfaceException: PUT http://localhost:9090/uploads/91e5118e60924b21bd48a9ed19ab91ff_girl8.jpg returned a response status of 405 Method Not Allowed Description :The server encountered an unexpected condition that prevented it from fulfilling the request. Exception : org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.sun.jersey.api.client.UniformInterfaceException: PUT […]
-
Time：2020-2-10
Cookie cookieIt is used by the client to store data. It can be set either on the client side or on the server side.cookieWill follow anyHTTPRequest sent together Web Storage html5StandardWeb StorageThere are two storage methods:sessionStorageandlocalStoragesessionStorageIt is used to store the data in a session locally, which can only be accessed by pages in the […]
-
Time：2020-2-9
This paper introduces the method of SQL Server to split and insert specific strings. To share with you for your reference, as follows: –Loop add declare @idx as int While Len(@UserList) > 0 Begin Set @idx = Charindex(‘,’, @UserList); –Only one piece of data If @idx = 0 and Len(@UserList) > 0 Begin Insert Into […]
-
Time：2020-2-8
The example of this paper describes the function and usage of split function in SQL server. To share with you for your reference, as follows: /* Function name: F? Splittonvarchar Function: function to realize split function Update records: Design idea: separate a string of nvarchar type characters into a table with only one column of […]
-
Time：2020-2-6
I. overview SQL server provides backup and recovery methods for “separate / attach” database, “backup / restore” database, replication database and other databases. This paper introduces a commonly used “separate / attach” method in learning, which is similar to the familiar “file copy” method, that is, copy database files (. MDF) and corresponding log files […]
-
Time：2020-2-2
Query deadlock process statement select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type=’OBJECT’ Kill deadlock process statement kill spid Next, I will share a paragraph about SQL Server deadlock detection, killing locks and processes, and viewing lock information –Detect deadlock –If a deadlock occurs, how can we detect which SQL statement or stored procedure is […]
-
Time：2020-1-31
FileMaker Server 18Is a powerful server software, you can buy users through FileMaker server management console or FileMaker store. FileMaker server is the FileMaker Pro advanced used to host the database. Such data can be shared. Through FileMaker Pro advanced, FileMaker can modify and create a special database server and FileMaker webdirect client, as well […]
-
Time：2020-1-27
A key:The following installation steps are all installed in a disconnected environment Because I want to see if sql2012 will download and install. NET2.0 and. NET3.5 and. Net4 and Sp1 patches My environment: The size of the installation package without the integrated SP1 patch package is 4.71gb, which is available in every version of the […]
