Çó¶¯Ì¬SQL·µ»ØÖµµÄ´æ´¢¹ý³Ì

ÎÒÓö¯Ì¬SQLÓï¾äÀ´·µ»Ø·ûºÏÌõ¼þµÄ¼Ç¼Êý£¬ÈçÏ£º

CREATE PROCEDURE zhcx_11wrts    --µ¥¸öÌõ¼þ²éѯ¼Ç¼Êý
@zd varchar(10),@nr varchar(10)  ---@zd (×Ö¶Î) @nr (×Ö¶ÎÖµ)
AS
begin
declare @count int
EXEC('select @count=count(*) from volvo where '+@zd+' ='''+@nr+'''')
return @count
end
GO

µ÷ÓÃÈçÏ£º
declare @count int,@zd varchar(10),@nr varchar(10) set @zd='bxlx' set @nr='СÐÞ' exec @count=zhcx_11wrts @zd,@nr select @count shuliang

³öÏÖÈçÏ´íÎó£º
·þÎñÆ÷: ÏûÏ¢ 137£¬¼¶±ð 15£¬×´Ì¬ 1£¬ÐÐ 1
±ØÐëÉùÃ÷±äÁ¿ '@count'¡£
¹ý³Ì 'zhcx_11wrts' ÊÔͼ·µ»Ø״ֵ̬ NULL£¬µ«²»ÔÊÐíÕâÑù×ö¡£½«¸ÄΪ·µ»Ø״ֵ̬ 0¡£

£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©

ÈçºÎÕýÈ·Êéд¶¯Ì¬SQL·µ»ØÖµµÄ´æ´¢¹ý³Ì£¿£¿£¿

---

¿ÉÒÔÓà sp_executesqlÀ´Ð´

---

Óà sp_executesqlÀ´Ð´ ¾ßÌåÇë²Î¿¼
http://blog.csdn.net/fredrickhu/archive/2009/09/21/4574840.aspx

¶¯Ì¬SQL»ù±¾Óï·¨ Òª×ßÁË À´²»¼°°ïÄãдÁË SORRY

---

ÒýÓÃ

Óà sp_executesqlÀ´Ð´ ¾ßÌåÇë²Î¿¼
http://blog.csdn.net/fredrickhu/archive/2009/09/21/4574840.aspx

¶¯Ì¬SQL»ù±¾Óï·¨ Òª×ßÁË À´²»¼°°ïÄãдÁË SORRY

·ÉÏСÐÄ£¡

---

SQL code:


d