iteye_12369的博客

[code="java"]with result as ( select id, parentid,name from syst_dept where id = 'b649a10a3fa8017b003165fea703fa81' union all select a.id,a.parentid,a.name from syst_dept a join result b on ...

[code="java"] USE [hospital] GO /****** Object: StoredProcedure [dbo].[P_PAGE] Script Date: 10/21/2012 10:33:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [db...

drop role ProgramerRole [code="java"] --创建角色 create role ProgramerRole --用于创建 存储过程 视图 grant create procedure,create view to ProgramerRole --execute用以执行存储过程，alter用以创建、修改存储过程...