UPDADR.SQL
资源名称:MSDN_VC98.zip [点击查看]
上传用户:bangxh
上传日期:2007-01-31
资源大小:42235k
文件大小:0k
源码类别:
Windows编程
开发平台:
Visual C++
- if exists (select * from sysobjects where id = object_id('dbo.update_addr') and sysstat & 0xf = 4)
- drop procedure dbo.update_addr
- GO
- CREATE PROCEDURE update_addr(@au_id varchar(11), @addr varchar(40)) AS
- update authors set address = @addr where au_id = @au_id
- GO