c＃中的sql查询。 [英] The sql query in c#.

问题描述

如果不是EXISTS（SELECT * from sysobjects WHERE name ='tbl_name'AND xtype ='U'）select e into ems_db1.dbo.Rish Master 3450_querysummary from ems_db1.dbo.querysummary where 1 = 0



c＃中的这个查询给出了一个错误，即Master附近的语法不正确。在Rish Master 3450中有间距，那是不是会出错？如果是，那么什么是解决方案。



Rish Master 3450是运行时文本框中的值。

"IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='tbl_name' AND xtype='U') select * into ems_db1.dbo.Rish Master 3450_querysummary from ems_db1.dbo.querysummary where 1 = 0"

this query in c# it gives an error that Incorrect syntax near Master. In Rish Master 3450 spacing is there,is that case it gives an error? if yes then what is solution for this.

Rish Master 3450 is a value from textbox at runtime.

推荐答案

使用括号：

Use brackets:

...into ems_db1.dbo.[Rish Master 3450_querysummary] from...

你的sql查询

Hi,

your sql query

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='tbl_name' AND xtype='U')
 select * into ems_db1.dbo.Rish Master 3450_querysummary from ems_db1.dbo.querysummary where 1 = 0

尝试代替您的代码

Try instead of your code

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='tbl_name' AND xtype='U')
select * into ems_db1.dbo.RishMaster3450_querysummary from ems_db1.dbo.querysummary where 1 = 0

这篇关于c＃中的sql查询。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！