Çë½ÌÒ»ÌõSQLÓï¾ä

²éѯt_Question±íÖÐËùÓÐ×Ö¶ÎÃûµÄÇ°4λ£¬ÎªItemµÄ×Ö¶ÎÃû

---

select left(Item,4) from t_Question

---

SQL code:
select left(Item,4)Item from t_Question

---

select left(Item,4) from t_Question

---

SQL code:
select substring(Item,1,4)Item from t_Question

---

SQL code:
select left(Item,4) from t_Question

---

²éѯ³öÀ´µÄ½á¹ûÈ«ÊÇItem£¬ÎÒÏëÒªµÄÊǺ¬ÓÐItemµÄ×Ö¶ÎÃû(È«Ãû)

---

ÒýÓÃ

²éѯt_Question±íÖÐËùÓÐ×Ö¶ÎÃûµÄÇ°4λ£¬ÎªItemµÄ×Ö¶ÎÃû

¿´²»¶®Òâ˼.

---

SQL code:

select left(colname ,4) from t_Question where colname like '%Item%'

---

Õâ¸öÒªµ½ÏµÍ³±íÀïÈ¥²éÁË

---

SQL code:

select * from syscolumns where id = object_id('t_Question') and left([name],4) ='Item'

---

ÒýÓÃ

SQL codeselect*from syscolumnswhere id=object_id('t_Question')andleft([name],4)='Item'