Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Çë½Ì¸ßÊÖ--¶¯Ì¬SQLÓï¾äÎÊÌ⣡

ALTER PROCEDURE [dbo].[Procep]
@PName varchar(50),        --×Ö¶ÎÃû
@PTxt varchar(200)        --×Ö¶ÎÄÚÈÝ
AS
BEGIN
Exec('Update Ptable Set '+@PName+'='+@PTxt)
END


EXEC Procep 'pName','jjjjj'   

ÏûÏ¢ 207£¬¼¶±ð 16£¬×´Ì¬ 3£¬µÚ 1 ÐÐ
ÁÐÃû 'jjj' ÎÞЧ¡£


ÄÄλ¸ßÊÖÖ¸½ÌÏ£¬Ð»Ð»£¡
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 codeALTERPROCEDURE[dbo].[Procep]@PNamevarchar(50),--×Ö¶ÎÃû@PTxtvarchar(200)--×Ö¶ÎÄÚÈÝASBEGINExec('Update Ptable Set'+@PName+'='''+@PTxt+'''')END


¶¥£¬¶¯Ì¬sqlÖÐΪ×Ö·û´®¸³ÖµÒªÓÃË«ÒýºÅתÒåµ¥ÒýºÅ

ALTER PROCEDURE [dbo].[Procep]
@PName varchar(50),        --×Ö¶ÎÃû
@PTxt varchar(200)        --×Ö¶ÎÄÚÈÝ
AS
BEGIN
Exec('Update Ptable Set '+@PName+'='+


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

¹ØÓÚSQL Server Mobile Edition - .NET¼¼Êõ / C#

¹ØÓÚSQL Server Mobile Edition
ÓÃMicrosoft SQL Server2005 Management Studio Express9.00.3042.00´´½¨SQLCEÊý¾Ý¿âsqlmobile.sdf
ÔÚmobileϵͳÖÕ¶ËÉÏÓÃSQL Server Mobile Edition3.0Äܲ鿴sqlmobile.sdfÀï±íÊý¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ