drop table unit drop table unit1 CREATE TABLE unit(unit_id int ,unit_type_id int,unit_name text ,project_count int, apply_count int ,product_count int) CREATE TABLE unit1(unit_id int ,unit_type_id int,unit_name text ,project_count int, apply_count int ,product_count int)我的语句可以在查询分析器执行呀!!!!
Dim myconn As New SqlConnection("server=nikko2;database=iteminf;uid=sa;pwd=") myconn.Open() Dim sqltext As String sqltext = "IF EXISTS(SELECT name FROM sysobjects WHERE name = N'unit' AND type = 'U') DROP TABLE unit " sqltext = sqltext & "CREATE TABLE unit(unit_id int ,unit_type_id int,unit_name text ,project_count int, apply_count int ,product_count int) " sqltext = sqltext & "IF EXISTS(SELECT name FROM sysobjects WHERE name = N'unit1' AND type = 'U') DROP TABLE unit1 " sqltext = sqltext & "CREATE TABLE unit1(unit_id int ,unit_type_id int,unit_name text ,project_count int, apply_count int ,product_count int)" Dim Multicommand As New SqlCommand(sqltext, myconn) Multicommand.ExecuteNonQuery() myconn.Close()
SqlCommand cmd=new SqlCommand();
cmd.CommandText=sqlall ;
cmd.Connection=con;
cmd.ExecuteNonQuery();
{
try
{
if(MyConnection.State==System.Data.ConnectionState.Open)
{
MyConnection.Close();
}
string str=strSql;
SqlCommand MyCommand=new SqlCommand(str,MyConnection);
//if (MyCommand.Connection.State="open
MyCommand.Connection.Open();
MyCommand.ExecuteNonQuery();
MyCommand.Connection.Close();
}
catch(SqlException e)
{
MessageEr=e.Message;
return false;
}
catch(System.ArgumentException e)
{
MessageEr=e.Message;
return false;
}
return true;
}
你可以把sql输入并测试此语句正确,再执行Command.Executenonquery().
能帮我把SQL语句写成 存储工程吗?
然后怎么调用呢?谢谢谢谢 :)
建议你将语句先打印出来,然后放在查询分析器了执行,
没有错误再运行语句。
myconn.Open()
Dim sqltext As String
sqltext = "IF EXISTS(SELECT name FROM sysobjects WHERE name = N'unit' AND type = 'U') DROP TABLE unit "
sqltext = sqltext & "CREATE TABLE unit(unit_id int ,unit_type_id int,unit_name text ,project_count int, apply_count int ,product_count int) "
sqltext = sqltext & "IF EXISTS(SELECT name FROM sysobjects WHERE name = N'unit1' AND type = 'U') DROP TABLE unit1 "
sqltext = sqltext & "CREATE TABLE unit1(unit_id int ,unit_type_id int,unit_name text ,project_count int, apply_count int ,product_count int)"
Dim Multicommand As New SqlCommand(sqltext, myconn)
Multicommand.ExecuteNonQuery()
myconn.Close()