![](/Images/OutliningIndicators/ContractedBlock.gif)
cs_Licenses_Update
ALTER PROCEDURE dbo.cs_Licenses_Update
@LicenseID uniqueidentifier,
@LicenseType nvarchar(50),
@LicenseValue ntext
AS
![](/Images/OutliningIndicators/None.gif)
if exists(select LicenseType from cs_Licenses where LicenseType = @LicenseType)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//*如果存在此许可类型*/
begin
delete from cs_Licenses where LicenseType = @LicenseType
end
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//*删除*/
![](/Images/OutliningIndicators/None.gif)
insert into cs_Licenses (LicenseID, LicenseType, LicenseValue) values (@LicenseID, @LicenseType, @LicenseValue)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//*插入许可*/
![](/Images/OutliningIndicators/ContractedBlock.gif)
cs_Licenses_Get
ALTER PROCEDURE dbo.cs_Licenses_Get AS
![](/Images/OutliningIndicators/None.gif)
SELECT * FROM cs_Licenses
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//*查询全部*/
![](/Images/OutliningIndicators/ContractedBlock.gif)
[cs_InkData_Update]
ALTER Proc [dbo].[cs_InkData_Update]
(
@SectionID int,
@SettingsID int,
@Ink NTEXT,
@DateUpdated datetime,
@InkID int
)
as
![](/Images/OutliningIndicators/None.gif)
update cs_InkData
SET
Ink = @Ink,
DateUpdated = @DateUpdated
where
SettingsID = @SettingsID and SectionID = @SectionID and InkID = @InkID
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//*更新*/
![](/Images/OutliningIndicators/ContractedBlock.gif)
[cs_InkData_Get]
ALTER Proc [dbo].[cs_InkData_Get]
(
@InkID int,
@SettingsID int
)
as
Select InkID, Ink, UserID, SectionID, SettingsID, DateUpdated, ApplicationType FROM cs_InkData where InkID = @InkID and SettingsID = @SettingsID
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//*获取数据*/
![](/Images/OutliningIndicators/None.gif)
posted on
2006-09-20 16:11
MainIsUsed
阅读(
209)
评论()
编辑
收藏
举报