sqlÓï¾ä»ñÈ¡¼Ç¼Êý

StrSQL="Select * from "&DataTable&" Where ID In("& ID &") and Shop_ID="&Shop_ID&Taxis


ÈçºÎ»ñÈ¡ËûµÄ¼Ç¼Êý?

---

@@ROWCOUNT

---

Select count(*) from

---

StrSQL="Select count(*) from "&DataTable&" Where ID In("& ID &") and Shop_ID="&Shop_ID&Taxis

---

count(1)

---

²»Ã÷°×°¡

---

ÒýÓÃ

@@ROWCOUNT

¶¥

---

StrSQL="Select COUNT(*) from "&DataTable&" Where ID In("& ID &") and Shop_ID="&Shop_ID&Taxis
ÔÚ³ÌÐòÖÐÕâÑùÓÃ

---

¿´Â¥Ö÷µÄÓï¾ä,Ó¦¸ÃÊÇÔÚ¿ª·¢³ÌÐòʱʹÓÃado¶ÔÏóÁ¬½ÓsqlÈ»ºó·µ»ØÊý¾ÝµÄ°É,Èç¹ûÊÇÕâÑù,ÄÇôado¶ÔÏ󶼻áÓÐÒ»¸öÊôÐÔ±êʶÕâ´Î²Ù×÷·µ»ØÁ˶àÉÙÐмǼµÄ.Èç¹ûÖ±½ÓÔÚsqlÀïÔËÐÐ,ÄÇô¿ÉÒÔÓÃϵͳ±äÁ¿@@rowcountÀ´È¥µÄ¼Ç¼Êý.

declare @rows int
select * from ±íÃû where Ìõ¼þ
set @rows = @@rowcount
select @rows
Õâ¶Î´úÂë¾ÍÄÜ·µ»ØËù²éѯµÄ¼Ç¼ÊýÁË.

---

StrSQL="Select count(*) from "&DataTable&" Where ID In("& ID &") and Shop_ID="&Shop_ID&Taxis

---

Á½ÖÖ¶¼¿ÉÒÔ£º
1.Count(*)
2.@@Rowcount