¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡

---

¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

---

Ö±½ÓÖ´ÐоÍÐÐÁË

---

exec sp_executesql @STR

---

exec(@STR)  
exec ÊÇÖ´ÐÐÃüÁî

---

ÒýÓÃ

exec(@STR)

¹ýÀ´Ñ§Ï°µÄ¡£

---

exec ¹ýÀ´Ôø·ÖµÄ¡£

---

exec(@STR)

---

»¹ÓÐÒ»¸öÎÊÌ⣺Èç¹û²éѯÓï¾ä¹ý³¤µÄ»°£¬ÄÇôÎÒ¶¨ÒåµÄÄǸö±äÁ¿£¬¸ÃÊÇʲôÀàÐ͵ÄÄØ

---

sqlserver05µÄ»° ¿ÉÒÔÊÇtextµÄ°É? ²»¹ývarcahrÓ¦¸Ã¹»ÓÃÁË°É?

---

ÎÒÊÔÁËһϣ¬¿ÉÊÇtext²»Ðа¡£¬²»ÖªµÀ»¹ÓÐûÓÐÆäËûµÄ°¡

---

exec Ö´ÐÐ

---

ÕâλÊÇÏÀ½ãÄØ»¹ÊÇÈÊÐÖÄØ

---

ʹÓÃsp_executesql

SQL code:

DECLARE @STR NVARCHAR(MAX)
SET @STR=N'SELECT @count=count(*) from Category'
declare @count int
exec sp_executesql @STR,N'@count int output', @count output
select @count


²Î¿¼

---

ºÃµÄ£¬Ð»Ð»

---

ÎÒ¿´´íÌâÄ¿ÁË ÎÒÈÕ Ö´ÐÐËû Ö±½Óexec¾ÍºÃ

---

varchar×ºÃÏñÊÇ7000£¨ÓпÉÄÜ¼Ç´í£©£¬Èç¹ûʵÔÚ³¬³¤£¬¿ÉÓÃnvarchar(max)