· 8 years ago · Jun 15, 2018, 11:10 PM
1/****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] Script Date: 09/13/2011 12:03:44 ******/
2SET ANSI_NULLS ON
3GO
4
5SET QUOTED_IDENTIFIER ON
6GO
7
8
9
10CREATE procedure [dbo].[_ExistsServiceOffRentItem]
11as
12
13if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
14begin
15return -1
16end
17
18
19GO
20
21
22
232
24
25
26
27
28
29
30
31SET ANSI_NULLS ON
32GO
33
34SET QUOTED_IDENTIFIER ON
35GO
36
37CREATE TABLE [dbo].[SK_gamebang_ip](
38[nID] [smallint] NOT NULL,
39[ip] [int] NOT NULL,
40[capacity] [smallint] NOT NULL
41) ON [PRIMARY]
42
43GO