陈斌彬的技术博客

Stay foolish,stay hungry

Sql脚本语句判断非空

右键选择表,然后选择编辑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进行测试