创建表可以 string tablestr = "USE [" + dataname + "]" +
"CREATE TABLE [dbo].[FileName](" +
"[id] [int] IDENTITY(1,1) NOT NULL," +
"[field] [int] NULL CONSTRAINT [DF_FileName_field] DEFAULT ((0))" +
") ON [PRIMARY]";
SqlConnection MyCon = new SqlConnection(“。。”);
if (MyCon.State == ConnectionState.Closed)
{
MyCon.Open();
}
SqlCommand MyCmd = new SqlCommand(tablestr, MyCon);
MyCmd.ExecuteNonQuery();
MyCon.Close();存储过程怎样创建呢?
"CREATE TABLE [dbo].[FileName](" +
"[id] [int] IDENTITY(1,1) NOT NULL," +
"[field] [int] NULL CONSTRAINT [DF_FileName_field] DEFAULT ((0))" +
") ON [PRIMARY]";
SqlConnection MyCon = new SqlConnection(“。。”);
if (MyCon.State == ConnectionState.Closed)
{
MyCon.Open();
}
SqlCommand MyCmd = new SqlCommand(tablestr, MyCon);
MyCmd.ExecuteNonQuery();
MyCon.Close();存储过程怎样创建呢?
MsSql 2005 可以。直接在MSSQL里写个存储过程不可以吗?
都一样
创建一个sql脚本,在c#里调用执行就可以了
我们在做数据库升级的时候就是这样,有的时候是要增加一个存储过程
直接在C#里拼凑SQL语句不行吗?
如果非要在C#里拼凑SQL语句也可以
create procedure
string procedureStr = "USE [" + dataname + "]" +
"create procedure [存储过程名] "
+" @参数1 char(4),"
+" @参数2 char(4) "
+"as "
+" Begin "
+" ....... "
+" End";
SqlConnection MyCon = new SqlConnection(“。。”);
if (MyCon.State == ConnectionState.Closed)
{
MyCon.Open();
}
SqlCommand MyCmd = new SqlCommand(tablestr, MyCon);
MyCmd.ExecuteNonQuery();
MyCon.Close(); 存储过程怎样创建呢?