mycmd = mycn.CreateCommand(); mycmd.CommandText = "CREATE TABLE IF NOT EXISTS `ems_db1.dbo`.`querysummary` LIKE `ems_db1.dbo`.`" + TreeView1.SelectedNode.Text + "_querysummary`"; mycmd.ExecuteNonQuery();
IF object_id('querysummary', 'U') IS NOT NULL CREATE TABLE 'querysummary' ...
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='tbl_name' AND xtype='U') select * into ems_db1.dbo.kquerysummary from ems_db1.dbo.querysummary where 1 = 0
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)