【收藏】不同數據庫的SQL語法與C#連接代碼匯總
摘要:===數據庫SQL常用語句對比======================================1. ORACLE SELECT * FROM TABLE1 WHERE ROWNUM<=N HQL: from table1 t order by t.createTime desc where rownum<=n 2. INFORMIX SELECT FIRST N row...
阅读全文
posted @
2009-10-13 17:48
巍巍边疆
阅读(1155)
推荐(0)
ADO.NET获取TIPTOP存储过程的返回值
摘要://在TIPTOP中的操作,使用ODBC數據源連接INFORMIX,其他大同小異 /*Select*/ private DataTable OdbcSelect_ndsf(string sql) { OdbcConnection objOdbcConnection=new OdbcConnection(strOdbcConnection_ndsf); objOdbcConnectio...
阅读全文
posted @
2007-07-11 10:16
巍巍边疆
阅读(442)
推荐(0)