sp_tables [ [ @table_name = ] 'name' ]
[ , [ @table_owner = ] 'owner' ]
[ , [ @table_qualifier = ] 'qualifier' ]
[ , [ @table_type = ] "type" ]例如这个存储过程, SQL里是这样调用exec sp_talbes @table_name='TV',其它取默认值,在C#里怎么样调用呀,
[ , [ @table_owner = ] 'owner' ]
[ , [ @table_qualifier = ] 'qualifier' ]
[ , [ @table_type = ] "type" ]例如这个存储过程, SQL里是这样调用exec sp_talbes @table_name='TV',其它取默认值,在C#里怎么样调用呀,
1 使用SqlParameter 类
如
SqlParameter parameter = salesCommand.Parameters.Add(
"@CategoryName", SqlDbType.NVarChar, 15);
parameter.Value = "Beverages";2 直接写,像写sql 一样
如:
using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(
queryString, connection);
adapter.Fill(dataset);
return dataset;
}
其中queryString="exec sp_talbes @table_name='param1',@table_owner='param2'.."