随笔分类 -  DB

sp__helptable, sp__help******* help 存储过程
摘要：from: https://sqldbaknowledgeshare.wordpress.com/2014/11/27/general-help-procedures/ GENERAL HELP PROCEDURES Posted: November 27, 2014 in Uncategorize 阅读全文
posted @ 2019-07-31 13:31 books2read 阅读(521) 评论(0) 推荐(0)
触发器-- 肖敏_入门系列_数据库进阶 60、触发器(三) --youku
摘要：二 https://v.youku.com/v_show/id_XMzkxOTc5NDY0OA==.html?spm=a2h0k.11417342.soresults.dtitle 三 https://v.youku.com/v_show/id_XMzkyMTM1MDMxNg==.html?spm= 阅读全文
posted @ 2019-07-25 18:00 books2read 阅读(228) 评论(0) 推荐(0)
SQL：找到特定日期每个顾客最高购买量：Find the highest purchase amount ordered by the each customer on a particular date， with their ID, order date and highest purchase amount.
摘要：A： SELECT customer_id,ord_date,MAX(purch_amt) FROM orders GROUP BY customer_id,ord_date; find the highest purchase amount ordered by the each customer 阅读全文
posted @ 2019-07-12 13:46 books2read 阅读(248) 评论(0) 推荐(0)
SQL: all 运算符 可以 表示 非空（NOT NULL）的意思吗？
摘要：select count(all grade) from customer; SELECT COUNT(DISTINCT customer_id) FROM customer WHERE grade IS NOT NULL; 阅读全文
posted @ 2019-07-12 10:32 books2read 阅读(542) 评论(0) 推荐(0)
SQL case when else 语句：选出年份等于1970的，选出的结果用科目和获奖者排序，同时把经济和化学2科放到最后：SELECT * FROM nobel_win WHERE year=1970 ORDER BY CASE WHEN subject IN ('Economics','Chemistry') THEN 1 ELSE 0 END ASC, subject, winner;
摘要：SELECT * FROM nobel_win WHERE year=1970 ORDER BY CASE WHEN subject IN ('Economics','Chemistry') THEN 1 ELSE 0 END ASC, subject, winner; 阅读全文
posted @ 2019-07-11 15:53 books2read 阅读(295) 评论(0) 推荐(0)
bcp文件， 逗号文件
摘要：bcp 实用工具 https://docs.microsoft.com/zh-cn/sql/tools/bcp-utility?view=sql-server-2017 大容量复制程序实用工具 (bcp) 可以在 Microsoft SQL Server 实例和用户指定格式的数据文件间大容量复制数据 阅读全文
posted @ 2019-07-05 10:16 books2read 阅读(477) 评论(0) 推荐(0)
叫法： 表名 表字段名 定义每个表字段
摘要：表名 表字段名 定义每个表字段 阅读全文
posted @ 2019-06-20 14:27 books2read 阅读(310) 评论(0) 推荐(0)

Total Visits
AmazingCounters.com