右键选择表,然后选择编辑1000行
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [ID]
,[CreateDate]
,[IsAvailable]
,[SiteCode]
,[SiteName]
,[SiteAlias]
,[SiteY]
,[SiteX]
,[BaseStation]
,[Location]
,[Remark]
FROM [Asset].[dbo].[hx_tblSite]
where [SiteY]<>''
按F5进行测试