哪里有存储过程的教程下载??
解决方案 »
- |zyciis| 求更新语句:A表根据B条条件更新,同时更新B表信息
- 求助!!!高手救命!!!SQL日期查询的问题!!
- 求一SqlServer语句
- 超级简单但又奇怪的SQL问题,是SQL的BUG么?有人遇到过么?
- 救命呀!只有BOM_Data.MDF,BOM_Log.LDF这两个文件,怎么恢复数据库BOM!在线等待!
- SQL Server小问题?
- 朋友们,你们有没有见到过可以在查询分析器里面格式化SQL代码的程序?就象DELPHI formatter 一样的东西??
- 怎样实现内部自己连接的表的检索!
- 如何对N个字段进行联合约束?
- 当我的WHERE语句等于汉字的时候不会出现结果
- SQL的简单问题!
- BULK INSERT
一些例子---------------添加的存储过程
-- ===========================================
-- Author: <Author Name : Charry Chen>
-- Create date: <Create Data : 2007-5-14>
-- Description: <Description : 添加科室信息>
-- ===========================================
ALTER PROCEDURE [dbo].[OfficeInfo_AddOfficeInfo]
(
@Office_Name nvarchar(50),
@Phone nvarchar(30),
@Position nvarchar(100),
@Director_Name nvarchar(50)
)
AS
begin
INSERT INTO OfficeInfo
(
Office_Name,
Phone,
Position,
Director_Name
) VALUES
(
@Office_Name,
@Phone,
@Position,
@Director_Name
)
End
-----------------------更新的存储过程
-- =============================================
-- Author: <Author Name : Charry Chen>
-- Create date: <Create Data : 2007-5-14>
-- Description: <Description : 更新科室信息>
-- =============================================
ALTER PROCEDURE [dbo].[OfficeInfo_UpdateOfficeInfo]
(
@Office_ID int,
@Office_Name nvarchar(50),
@Phone nvarchar(30),
@Position nvarchar(100),
@Director_Name nvarchar(50)
)
AS
BEGIN
update OfficeInfo
set
Office_Name = @Office_Name ,
Phone = @Phone,
Position = @Position,
Director_Name = @Director_Name where Office_ID= @Office_ID
END
-- =============================================
-- Author: Marry
-- Create date: 2007-02-14
-- Description: Add or Update Larger=
-- ================================================ 更新或删除
ALTER PROCEDURE [dbo].[mis_SystemSetup_AddorUpDateLargerUpload]
@radix Int,
@taskNum Int,
@PRI Nvarchar(50),
@dateTime Datetime
AS
BEGIN
SELECT *
FROM FtpSecondUpLoadMaintenance
IF @@Rowcount < = 0
INSERT INTO FtpSecondUpLoadMaintenance
(
radix,
taskNum,
PRI,
dateTime
)
VALUES
(
@radix,
@taskNum,
@PRI,
@dateTime
)
ELSE
UPDATE FtpSecondUpLoadMaintenance
SET
radix = @radix,
taskNum = @taskNum,
PRI= @PRI,
dateTime = @dateTime
END
--------------------------更新
ALTER PROCEDURE [dbo].[mis_SystemSetup_DeleteTifFolderPathInfo]
@TifID int,
@IsUsing INT OUTPUT
AS
SELECT Flag
FROM TifFolderPath
WHERE Flag = 0 And TifFolderPath_ID = @TifID
IF @@Rowcount > 0
UPDATE
TifFolderPath
SET
InActive=0,
@IsUsing = 0
WHERE
TifFolderPath_ID = @TifID
ELSE
SET
@IsUsing = 1
----删除的存储过程-- ==========================================
-- Author: <Author Name : Charry Chen>
-- Create date: <Create Data : 2007-5-14>
-- Description: <Description : 删除科室信息>
-- ==========================================
ALTER PROCEDURE [dbo].[OfficeInfo_DelOfficeInfo]
(
@Office_ID int
)
AS
BEGIN
DELETE From OfficeInfo
where Office_ID = @Office_ID
END----查找
----排序
-- ===========================================
-- Author: <Author Name : Charry Chen>
-- Create date: <Create Data : 2007-5-14>
-- Description: <Description : 获得科室信息>
-- ===========================================
ALTER PROCEDURE [dbo].[OfficeInfo_GetAllOfficeInfo]
AS
BEGIN
SELECT Office_ID,Office_Name,Phone,Position,Director_Name from OfficeInfo
order by Office_ID asc/desc
END