查一下SQL SERVER联机文档..sysobjects ..就知道了.在sysobjects表中大概是select count(*) from sysobjects where type='t' and name='stu'
select count(*) from sysobjects where type='t' and name='score'
select count(*) from sysobjects where type='t' and name='score' SQL SERVER可以!!
select count(*) from sysobjects where type='t' and name='score' ==================== 这样真的对吗? 应该是:select count(*) from sysobjects where type='u' and name='score'
应该是select count(*) from sysobjects where type='u' and name='score',我用过的。
你看查询分析器中一个创建一个表的SQL语句.都先查看一下是否存在这个表.
如果不存在才创建.
估计用这个SQL语句就可以查了
至于ASP.NET怎么调用SQL语句就不用再说了
====================
这样真的对吗?
应该是:select count(*) from sysobjects where type='u' and name='score'