右键点击表名弹出select top 1000 rows,弹出以下查询语句,但是一直显示正在执行查询,没有结果显示出来,这是为什么啊?
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [id]
,[uid]
,[pwd]
,[nickname]
,[name]
,[gender]
,[career]
,[address]
,[email]
,[tel]
,[birth]
FROM [try].[dbo].[custom]
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [id]
,[uid]
,[pwd]
,[nickname]
,[name]
,[gender]
,[career]
,[address]
,[email]
,[tel]
,[birth]
FROM [try].[dbo].[custom]
,[uid]
,[pwd]
,[nickname]
,[name]
,[gender]
,[career]
,[address]
,[email]
,[tel]
,[birth]
FROM [try].[dbo].[custom]-----------
貌似没问题.
--------------
SQL server2008不能查数据的问题这样解决,控制面版中Remove : Microsoft SQL server compact 3.5 SP1 Beta Management Tools English,然后再重装H:\Servers\Setup\SSCESqlWbTools.
再重启服务就可以了。
,[uid]
,[pwd]
,[nickname]
,[name]
,[gender]
,[career]
,[address]
,[email]
,[tel]
,[birth]
FROM [try].[dbo].[custom] (nolock)