简单例子
Create procedure yourproc(@yourparam yourtype)
As
Update yourtable
Set yourfield1=yourvalue1
Where yourfield2=@yourparam
Create procedure yourproc(@yourparam yourtype)
As
Update yourtable
Set yourfield1=yourvalue1
Where yourfield2=@yourparam
Create procedure yourproc(@yourparam yourtype)
As
Update yourtable
Set yourfield1=yourvalue1
Where yourfield2=@yourparam
CREATE PROCEDURE [SP_CopyData] AS
BEGINUpdate [ItemRelation] SET [TData] = [SData]END
GO
我使用上面的语句执行不正确,得不到想要的结果。我用的是WIN2000,SQLSERVER2000中文版