摘要：
A Transact-SQL code snippet is to create an XML file with the text of your code snippet. The file must have a .snippet file extension, and meet the re 阅读全文
posted @ 2021-07-15 14:17
Tuzi_ya
阅读(88)
评论(0)
推荐(0)
摘要：
sql server ,oracle 通用： 1. 行转列（PIVOT） CREATE TABLE [StudentScores]([UserName] NVARCHAR(20),[Subject] NVARCHAR(30),[Score] FLOAT,) INSERT INTO [StudentS 阅读全文
posted @ 2021-07-15 14:15
Tuzi_ya
阅读(293)
评论(0)
推荐(0)
摘要：
Bcp概述 Bcp用于Microsoft SQL Server 实例和用户指定格式的数据文件间大容量复制数据。使用 bcp 实用工具可以将大量新行导入 SQL Server 表，或将表数据导出到数据文件. Ø 2. Bcp的常见参数 -f format_file format_file表示格式文件名 阅读全文
posted @ 2021-07-15 14:07
Tuzi_ya
阅读(701)
评论(0)
推荐(0)
摘要：
When you meet below scenarios, you may check the locked table and kill the session. Unable to compile the source because of blocking tables. The sessi 阅读全文
posted @ 2021-07-15 13:59
Tuzi_ya
阅读(96)
评论(0)
推荐(0)
摘要：
open pl/sql, click "Tools" >>Preferences 2. find "User Interface" module, click "editor". 3. prepare a txt file as below: 4. Drag the zip code scroll 阅读全文
posted @ 2021-07-15 13:51
Tuzi_ya
阅读(166)
评论(0)
推荐(0)
摘要：
CTRL+E is used to copy the pattern of the first cell without any formula. From the first cell, type the last name then "Enter". Highlight from the fir 阅读全文
posted @ 2021-07-15 13:45
Tuzi_ya
阅读(187)
评论(0)
推荐(0)
浙公网安备 33010602011771号