Category：MsSql
-
Time：2019-10-24
Common statements in connection strings are: The Server declares Data Source, Server, Addr, and so on. The DataBase declaration Initial Catalog and DataBase, and so on. Integrated Security statements for Windows accounts Integrated Security and Trusted_Connection, etc. Declare User ID and Password etc. with the security of the database account. For an account accessing a […]
-
Time：2019-10-23
SQLServer database demoted from high version to low version instance details Because SQLServer2000 is still widely used, many companies want to use the new SQLServer, so directly [separate/attach] or [backup/restore] database, storage between different versions. Version incompatibilities are common. A few days ago, I encountered a restore from a database backed up on my machine […]
-
Time：2019-10-23
Although other ranking functions are technically similar in calculation to ROW_NUMBER, they are much less useful in practice. 10. RANK and DENSE — your RANK is primarily used for ranking and scoring points. NTILE is more used for analysis. First create a sample table: Copy the codeThe code is as follows: SET NOCOUNT ON USE […]
-
Time：2019-10-21
Oracle delete users and tablespaces Oracle has been used for a long time, and many new users and tablespaces have been added. It needs to be cleaned up. For a single user and tablespace, you can use the following command. Step 1: delete user drop user ×× cascade Note: if the user is deleted, only […]
-
Time：2019-10-21
Copy codeThe code is as follows: –View the current database status 1 as full-text indexing enabledSelect databaseproperty (‘Database name ‘,’ isfulltextenabled ‘)–Open fulltext functionexecute sp_fulltext_databse ‘enable’ –Turn this feature offexecute sp_fulltext_databse ‘disable’ –Create a full-text index catalog–Drop fulltext directory nameCreate fulltext catalog directory name–Each table can only have one full-text index, which is stored in […]
-
Time：2019-10-20
1. overview Trigger is a special stored procedure, which can not be called explicitly, but is activated automatically when inserting records, updating records or deleting records into a table. So triggers can be used to implement complex integrity constraints on tables. 2. Classification of triggers SQL Server 2000 provides two types of triggers: “embedded of” […]
-
Time：2019-10-20
As for XML, what is difficult to understand is not the functions provided by SQL server, but the understanding of XML itself. The seemingly simple file format is very difficult to handle. This article is just a preliminary study.See SQL server online help for details:themeExplainQuery () method (XML data type)This method is used to query […]
-
Time：2019-10-19
Scheduled job task of SQL Server: that is, the job task that the database automatically executes according to the schedule. It has the characteristics of periodicity and does not need human intervention. Creation steps: (login with the account with the highest permission — SA) I. start SQL server agent II. New job 3. […]
-
Time：2019-10-19
1、 Copy codeThe code is as follows: select top 10 * from ( select top (@Page * 10) ROW_NUMBER() OVER (order by id) as RowNum, id, username from Guest where username = ‘user’ ) as T where RowNum > ((@Page – 1) * 10) 2、 Copy codeThe code is as follows: select * from ( […]
-
Time：2019-10-18
Remote link server detailed configuration –Establish a connection server Exec sp’addlinkedserver ‘remote server IP’, ‘SQL Server’ –Dimension storage EXEC sp_addlinkedserver @Server =’server ‘– the local name of the linked server. Instance names are also allowed, such as Myserver \ sql1 @Srvproduct = ‘product_name’ — product name of OLE DB data source. For SQL server instances, […]
-
Time：2019-10-18
Background: During the daily operation of SQL Server 2005 relational database, sometimes some abnormal operations are carried out on the database (such as: SharePoint website configuration database name SharePoint ﹣ config). For example, when the database is reading and writing, it stops the database without any reason, resulting in abnormal interruption of SQL Server 2005 […]
-
Time：2019-10-17
When it comes to removing the space between the beginning and the end of a string, you must be the first to think of the trim() function. However, there is no such function in SQL server. Instead, there are two functions, ltrim() and rtrim(). See the name everyone knows what to do, ltrim () to […]
