SQLʸˡ

2017-05-21 () 17:29:40

˺Ƥ롢SQLʸˡΤٶ򾯤(MS SQL Server)

  • DB̾ISM-DB
  • ɽdbo.Sheet2$
100JK5ZAD
101JM8VXE
102JE5JZB
103JH5OCI
104JL8LGE
105JV5DLN
106JF1DDS
  • ɽdbo.ꥢ$
No
0ÿ
1
2
3
4
  • ɽdbo.Sheet2$׹100-200
select * from [ISM-DB].[dbo].[Sheet2$] where  between 100 and 200
  • SQLȹ
-- select * from [ISM-DB].[dbo].[ꥢ$] 
  • ɽdbo.Sheet2$פȡɽdbo.ꥢ$פdbo.Sheet2$ΣХܤdbo.ꥢ$NoΤǷ礷ơdbo.Sheet2$ι100-200
select * from [ISM-DB].[dbo].[Sheet2$], [ISM-DB].[dbo].[ꥢ$] 
where SUBSTRING([ISM-DB].[dbo].[Sheet2$].,3,1) = [ISM-DB].[dbo].[ꥢ$].No and 
[ISM-DB].[dbo].[Sheet2$]. between 100 and 200

¹Է

SQL1.png


źեե: fileSQL1.png 86 [ܺ]

ȥå   Խ ʬ Хåå ź ʣ ̾ѹ   ñ측 ǽ   إ   ǽRSS
Last-modified: 2017-05-21 () 17:29:40 (519d)