删除SQLSERVER2012TestDb数据库里面的所有表，下面是SQL的语言，在SQL里面是能运行删除的，但是我照着这个在VB.Net里面写了就是运行不起来，看看哪位大大能帮忙转化成VB.net的语言
use testdb
declare @sql varchar(8000)
while (select count(*) from sysobjects where type='U')>0
begin
SELECT @sql='drop table ' + name
FROM sysobjects
WHERE (type = 'U')
ORDER BY 'drop table ' + name
exec(@sql)
end
这个我写的VB.net的
ObjCommand.Connection = objConnection
ObjCommand.CommandText =
"declare @sql varchar(8000)" &
"while (select count(*) from sysobjects where type='U')>0" &
"begin()" &
"SELECT @sql='drop table ' + name" &
"FROM sysobjects" &
"WHERE type = U" &
"ORDER BY 'drop table ' + name" &
"exec(@sql)" &
"End"
objConnection.Open()
ObjCommand.ExecuteNonQuery()
objConnection.Close()
------解决思路----------------------
删除表都是SQL的事情，跟语言没关系
http://www.cnblogs.com/jys509/p/3589468.html
------解决思路----------------------
你直接创建一个存储过程，把那段sql复制进去，你通过代码执行这个存储过程就好了