Tag：cursor
-
Time：2020-11-28
1. Cursor movement for words All you have to do is press option and the left arrow. Instead, to move the cursor to the end of a word, just press option and the right arrow key. You can move the cursor in a document in units of words. Move the cursor to the beginning or […]
-
Time：2020-11-28
1. Cursor movement for words All you have to do is press option and the left arrow. Instead, to move the cursor to the end of a word, just press option and the right arrow key. You can move the cursor in a document in units of words. Move the cursor to the beginning or […]
-
Time：2020-11-28
1. Cursor movement for words All you have to do is press option and the left arrow. Instead, to move the cursor to the end of a word, just press option and the right arrow key. You can move the cursor in a document in units of words. Move the cursor to the beginning or […]
-
Time：2020-11-27
–Dangerous operation, remember to backup database 1 declare @ SQL varchar (500) before processing ,@tbname varchar(100) 2 begin 3 4 — create cursor 5 declare cursor_item cursor fast_forward for select [name] from sysobjects where xtype=’U’ AND id in(select id from syscolumns where name=’myColumnName’ and colstat=0 ) 6 open cursor_ Item; — Open cursor 7 while […]
-
Time：2020-11-24
Oracle database review catalog Oracle database review Database integrity SQL language DDL database definition language DML database manipulation language insert update delete Table creation, modification and deletion query Single table query join query Subquery and set operation paging Data deletion recovery flashback PL/SQL If case loop while for goto Function Stored procedure Cursor Trigger Exception […]
-
Time：2020-11-21
MacOS: Jump to the beginning of a word:option (⌥) + ← Jump to the end of a word:option (⌥) + → Jump to a line:command (⌘) + ← Jump to the end of a line:command (⌘) + → When the cursor is inserted at the current position of the previous line:command (⌘) + option (⌥) […]
-
Time：2020-11-15
When using the input field, we may encounter the situation that we need to set the cursor color for it. How to change the color of the white cursor on the CSS browser?The scenario described above can be implemented in two ways: 1. Use color to implement The color of the cursor is inherited from […]
-
Time：2020-11-12
–View all triggers in the database https://docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver15 –Geovin Du edit https://www.mssqltips.com/sqlservertip/5909/sql-server-trigger-example/ select * from sysobjects where xtype=’TR’ — exec sp_helptext ‘TriClerkOfficeInsert’ –Create an insert type trigger posionroledesaut. When adding employee data, add it in the role table if (object_id(‘TriClerkOfficeInsert’, ‘tr’) is not null) drop trigger TriClerkOfficeInsert go create trigger TriClerkOfficeInsert On clerkhoffice — specifies the […]
-
Time：2020-11-3
1. Try to avoid using the! = or < > operator in the where clause, otherwise the engine will give up using the index and scan the whole table. 2. To optimize the query, we should avoid scanning the whole table as much as possible. First of all, we should consider building indexes on the […]
-
Time：2020-10-29
A few days ago, a classmate added my QQ to chat privately. I said that their teacher arranged a greedy snake. He didn’t know how to write it, so he came to me to solve it. I gave him a brief explanation of the train of thought and some difficulties. After that, he was able […]
-
Time：2020-10-27
This paper describes the Oracle stored procedure cursor usage. For your reference, the details are as follows: Five steps to use a cursor 1. Declare variables to hold the index returned by the select statement2. Declare the cursor and specify the select statement3. Open cursor4. Get record from cursor5. Close cursor Get each record from […]
-
Time：2020-10-25
preface To improve the development efficiency of programmers, we must have a good development tool. At present, the best front-end development tools mainly include vs code, sublime text, atom, webstorm, Notepad + +. Vs code is a very powerful code editor. Although it has been out for a short time, its usage frequency and popularity […]
