常用sql
来源:互联网 发布:dhcp 的udp端口 编辑:程序博客网 时间:2024/04/28 11:18
1、 sqlserver导出数据到Excel
无标题:
EXEC master..xp_cmdshell 'bcp "SELECT * FROM wsbm..lsb" queryout C:/Book2.xls -c -S"(local)" -U"sa" -P"malong"'
有标题:
EXEC master..xp_cmdshell 'bcp "select ''data1'' ,''data2'' union all SELECT data1,data2 FROM wsbm..lsb" queryout C:/Book2.xls -c -S"(local)" -U"sa" -P"malong"'
2、数据备份
backup database cars to disk='"+this.txt_lj.Text.Trim()+"' with init
3、数据还原
public bool backupdata(string path)
{
string strconn="Server="+server.ToString()+";Database=master;User ID="+sa.ToString()+";Password="+pass.ToString()+";Trusted_Connection=False";
SqlConnection back_conn = new SqlConnection(strconn);
back_conn.Open();
{
string strconn="Server="+server.ToString()+";Database=master;User ID="+sa.ToString()+";Password="+pass.ToString()+";Trusted_Connection=False";
SqlConnection back_conn = new SqlConnection(strconn);
back_conn.Open();
//KILL DataBase Process
SqlCommand cmd = new SqlCommand("SELECT spid FROM sysprocesses ,sysdatabases WHERE sysprocesses.dbid=sysdatabases.dbid AND sysdatabases.Name='cars'", back_conn);
SqlDataReader dr;
dr = cmd.ExecuteReader();
ArrayList list = new ArrayList();
while(dr.Read())
{
list.Add(dr.GetInt16(0));
}
dr.Close();
for(int i = 0; i < list.Count; i++)
{
cmd = new SqlCommand(string.Format("KILL {0}", list[i]), back_conn);
cmd.ExecuteNonQuery();
}
SqlCommand cmd = new SqlCommand("SELECT spid FROM sysprocesses ,sysdatabases WHERE sysprocesses.dbid=sysdatabases.dbid AND sysdatabases.Name='cars'", back_conn);
SqlDataReader dr;
dr = cmd.ExecuteReader();
ArrayList list = new ArrayList();
while(dr.Read())
{
list.Add(dr.GetInt16(0));
}
dr.Close();
for(int i = 0; i < list.Count; i++)
{
cmd = new SqlCommand(string.Format("KILL {0}", list[i]), back_conn);
cmd.ExecuteNonQuery();
}
SqlCommand cmdRT = new SqlCommand();
cmdRT.CommandType = CommandType.Text;
cmdRT.Connection = back_conn;
cmdRT.CommandText = @"restore database cars from disk='"+path+"'";
cmdRT.CommandType = CommandType.Text;
cmdRT.Connection = back_conn;
cmdRT.CommandText = @"restore database cars from disk='"+path+"'";
try
{
cmdRT.ExecuteNonQuery();
return true;
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
finally
{
back_conn.Close();
}
{
cmdRT.ExecuteNonQuery();
return true;
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
finally
{
back_conn.Close();
}
}
- 常用sql
- 常用sql
- 常用SQL
- 常用SQL
- 常用sql
- 常用SQL
- sql常用
- SQL常用
- 常用SQL
- 常用sql
- 常用SQL
- 常用SQL
- 常用SQL
- sql 常用
- 常用Sql
- 常用sql
- sql常用
- 常用SQL
- Open SOA
- 数据库设计中使用设计模式
- 再次聚焦收入分配制度改革
- 面向对象软件工程-概念设计里程碑
- 我的搜索引擎继7月份第二次开放测试后,现在进行第三次开放测试,前两次分别用CGI+Html、Java做的客户端网站,这次学习了4个月 .NET,用.NET做了一个版本,请大家多批评指正。同时开放网站源代码。(附件中)
- 常用sql
- English Practice ___ New Concept English 3(11-20)
- 如何取消磁盘空间不足发出警告
- 用SqlCommandBuilder 实现批量更新
- 今天才知道.原来Enum类型的ToString方法是不可以override的
- 在.net 2.0 中使用Dictionary
- IReport与JasperReport生成HTML报表的问题
- How do I sort groups of data items?(WPF)
- 功能测试用例设计