📄 cs_urls_redirectlookup.prc
字号:
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cs_Urls_RedirectLookup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[cs_Urls_RedirectLookup]
GO
create procedure [dbo].[cs_Urls_RedirectLookup]
@UrlID int
as
BEGIN
SELECT
url
FROM
cs_UrlRedirects
WHERE
urlID = @UrlID
UPDATE
cs_UrlRedirects
SET
impressions = impressions + 1
WHERE
urlID = @UrlID
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
grant execute on [dbo].[cs_Urls_RedirectLookup] to public
go
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -