摘要：using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.Data;using System.Configuration;namespace CommonClass{ static class SqlHelpers { /// /// 数据库连接串 /// private static SqlConnection connection =... 阅读全文

摘要：Sybase 存储过程的创建和执行--返回值为int的存储过程create proc testReturn@tname varchar(12) ,@tid int outputasbeginset @tid = (select testid from Mytest where testname=@tname)returnend--返回值为varchar的存储过程create proc testReturnT@tid int ,@tname varchar(12) outputas begin set @tname = (select testname from Mytest where tes 阅读全文

摘要：最近工作上需要熟悉Oracle.,Sybase,之前自己一直用SQL ,虽然三者之间大方向上没什么不同但是在一些小细节上需要多加注意, 比如参数的调用using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.OracleClient;using System.Data.SqlClient;using System.Data.Odbc;using System.Data.OleDb;namespace SybaseTes 阅读全文