T-SQL语言基础
wangzhpwang
<--Wechat
展开
-
TSQL 带参数的游标 表值类型+record + cursor 模仿 plsql %rowtype
SET NOCOUNT ON;IF EXISTS( SELECT 1 FROM SYS.types AS t WHERE t.name = 'a01_A01_NODE_R_TABLE_TYPE' ) DROP TYPE dbo.a01_A01_NODE_R_TABLE_TYPEGOCREATE TYPE dbo.a01_A01_N原创 2014-08-10 21:30:48 · 756 阅读 · 0 评论 -
PLSQL TO TSQL , RECORE ,%TYPE,%ROWTYPE
SET NOCOUNT ONGOIF OBJECT_ID('TT') IS NOT NULL DROP TABLE ttGOCREATE TABLE TT( f1 NVARCHAR(100) DEFAULT 'VAL', f2 NVARCHAR(100) DEFAULT 'VAL', f3 NVARCHAR(100) DEFAULT 'VAL',原创 2014-08-08 15:06:10 · 643 阅读 · 0 评论 -
https://blog.hanschen.org/2012/10/17/open-application-launcher-with-super-key/
https://blog.hanschen.org/2012/10/17/open-application-launcher-with-super-key/How to make it workInstall ksuperkey. You can download the source and some distro-specific packages from Linux-a转载 2016-11-17 19:04:36 · 977 阅读 · 0 评论