華閱文章網請問SQL查詢語句有長度限制嗎
在sql 里面執行 create proc 存儲過稱名稱 as select iperiod 會計期間，ino_id 憑證編號，iflag ,cdigest 摘要，ccode 科目，md 借方金額， mc 貸方金額，cdept_id 部門，ccus_id 客戶，ccode_equal 對方科目 from UFDATA_005_*_accvouch WHERE (iflag Is Null) AND (iperiod Between 1 AND 12 ) AND ( ccode =10101) AND ( ccode_equal LIKE '%52102%') order by iperiod,ino_id go。
SQL 語句 最大長度限制 DB2如何修改最大長度限制
home/datamart$ db2 get db cfg|grep HEAP
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC
Sort list heap (4KB) (SORTHEAP) = AUTOMATIC
Database heap (4KB) (DBHEAP) = AUTOMATIC
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 103816
SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC
Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC
Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC
修改 STMTHEAP
P570_B_2:/DATAMART/usr/datamart >db2 update db cfg for datamart using STMTHEAP 20480 AUTOMATIC
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
P570_B_2:/DATAMART/usr/datamart >db2stop force
10/19/2012 10:56:14 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
P570_B_2:/DATAMART/usr/datamart >db2start
10/19/2012 10:56:20 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
P570_B_2:/DATAMART/usr/datamart >db2 get db cfg |grep STMT
SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(20480)
Automatic statement statistics (AUTO_STMT_STATS) = OFF
sql server 2005有sql語句長度限制嗎
SQL Server 2005 查詢語句 最大長度 測試
原來看過好像說SQL2005的查詢語句長度沒有什么限定了。但是因為最近要寫一個查詢，可能要很多條件。估計會超過1W字符。所以就直接測試一下。結果是沒有發現有長度的限制。
測試用例：
using (SqlConnection sconn = new SqlConnection("server=172.18.13.73;uid=patent;pwd=patent;database=DBPatentStar;"))
{
string sql0 = "SELECT count(*) FROM *_BasicInfo WHERE n_PatentID IN ({0})";
StringBuilder nids = new StringBuilder();
int iCnts = 50000;
for (int i = 0; i
