ÄÄλ¸ßÊÖÖ¸½ÌÏ£¬Ð»Ð»£¡begin declare @sql varchar(400) select @sql='Update Ptable Set '+@PName+'='+'''++@PTxt+''' exec (@sql) end SQL code:
ALTER PROCEDURE [dbo].[Procep] @PName varchar(50), --×Ö¶ÎÃû @PTxt varchar(200) --×Ö¶ÎÄÚÈÝ AS BEGIN Exec('Update Ptable Set '+@PName+'='''+@PTxt + '''') END
¶¥£¬¶¯Ì¬sqlÖÐΪ×Ö·û´®¸³ÖµÒªÓÃË«ÒýºÅתÒåµ¥ÒýºÅ ALTER PROCEDURE [dbo].[Procep] @PName varchar(50), --×Ö¶ÎÃû @PTxt varchar(200) --×Ö¶ÎÄÚÈÝ AS BEGIN Exec('Update Ptable Set '+@PName+'='+
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
¹ØÓÚSQL Server Mobile Edition ÓÃMicrosoft SQL Server2005 Management Studio Express9.00.3042.00´´½¨SQLCEÊý¾Ý¿âsqlmobile.sdf ÔÚmobileϵͳÖÕ¶ËÉÏÓÃSQL Server Mobile Edition3.0Äܲ鿴sqlmobile.sdfÀï±íÊý¾Ý ......