随笔分类 - SQL语法实例
摘要:sqlServer 函数 ALTER FUNCTION [dbo].[IM_fn_SRNO](@reg VARCHAR(64),@inv VARCHAR(64))RETURNS [varchar](256) WITH EXECUTE AS CALLERAS begin declare @Name v
阅读全文
摘要:select saddr,sid,serial#,paddr,username,status from v$session where username is not null and username = 'EHR' ; select 'alter system kill session '''|
阅读全文
摘要:1.查询 select object_name,machine,s.sid,s.serial#from v$locked_object l,dba_objects o ,v$session swhere l.object_id = o.object_id and l.session_id=s.sid
阅读全文
摘要:SELECT * FROM (select aa.*,bb.mentalvisitid, case when bb.BCSFXS='1' then '门诊' when bb.BCSFXS='2' then '家庭访视' else '电话' end as BCSFXS ,bb.visitdate, c
阅读全文
摘要:1.创建语法 2.举个栗子 3.语法备注 3. ACL权限设置 sql命令 4.触发器访问网络
阅读全文