19 lines
372 B
Transact-SQL
19 lines
372 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_get_pcroominfo]
|
|
(
|
|
@szIP nvarchar(24)
|
|
)
|
|
as
|
|
begin
|
|
set nocount on
|
|
|
|
--declare @sql nvarchar(1000)
|
|
--set @sql= 'select * from openquery(PcRoom, '
|
|
-- + '''select Level from tbCustomerIP
|
|
-- where IP = '''''
|
|
-- + @szIP + ''''' '')'
|
|
--exec(@sql)
|
|
--select InquiryCount as [Level] from AuthTable where IP = @szIP
|
|
select 0 as [Level]
|
|
|
|
end
|
|
|