CBA

Sqlserver教程SQL存储过程和算

2019-06-20 02:06:22来源:励志吧0次阅读

  ****** Object: Stored Procedure arch Script Date: 10:28:35 ******/ if exists (select * from sobjects where id = object_id(N'[dbo].[Search]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Search] GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO /****** Object: Stored Procedure arch Script Date: 10:28:35 ******/ CREATE proc Search @name1 nvarchar(50), @name2 nvarchar(50) as --中转站 create table #tmp ( tmp_id int identity(1,1), tmp_name NVARCHAR(50) ) --站点队列 create table #tmp1 ( tmp1_id int identity(1,1), tmp1_name NVARCHAR(50) ) --查找结果 create table #result ( r_id int, r_lid nvarchar(50), r_name nvarchar(50), r_type int ) --直达 insert into #result select c.* from t a,t b,t c where d=d and a.[type]=b.[type] and 小便刺痛快速治疗方法
小便刺痛吃药一直不好
尿痛尿急吃什么药

分享到: