自定义安装包及软件任务栏图标控制例源码

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tsxx_Temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tsxx_Temp] GO CREATE TABLE [dbo].[tsxx_Temp] ( [id] [int] IDENTITY (1, 1) NOT NULL , [msgid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [rid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [title] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO IF OBJECT_ID ('tsXX_Insert', 'TR') IS NOT NULL DROP TRIGGER tsXX_Insert GO Create TRIGGER tsXX_Insert ON dbo.tsXX FOR INSERT AS DECLARE @msgid int DECLARE @tile nvarchar(15) DECLARE @UserName int DECLARE @rid nvarchar(15) SET @msgid = (SELECT max(msgid) FROM tsXX) SET @tile = (SELECT title from tsXX where msgid=@msgid) SET @rid = (SELECT rid from tsXX where msgid=@msgid) begin INSERT tsxx_Temp(msgid,title,rid) values(@msgid,@tile,@rid) end GO