10 LIKE

来源:互联网 发布:运动员直播软件 编辑:程序博客网 时间:2024/04/29 03:58
/****** Script for SelectTopNRows command from SSMS  ******/SELECT TOP 1000 [StudentNo]      ,[LoginPwd]      ,[StudentName]      ,[Sex]      ,[GradeId]      ,[Phone]      ,[Address]      ,[BornDate]      ,[Email]  FROM [MySchool].[dbo].[Student]  --WHERE Address LIKE '%长%'    --WHERE StudentName LIKE '杨%'    --WHERE SEX LIKE '男'    --WHERE LoginPwd LIKE '%245%'      --WHERE StudentNo like '%01%'    ------------------------------------------空  --WHERE Email IS NULL    --WHERE StudentName IN ('姜北')  ORDER BY StudentName

0 0