如题所述
å¤æsqlè¯å¥ï¼select * DB..syscolums where id=object_id('DB.dbo.seque')
ï¼DBæ¯å·²ç¥åå¨çæ°æ®åºï¼ã
2
è¾åºç»æï¼æ¾ç¤ºåºè¯¥è¡¨ä¸ææå段ååå±æ§ã
END
å¤æå·²ç¥è¡¨ä¸æ个å段æ¯å¦åå¨
sqlè¯å¥ï¼select * from DB..syscolums where id=object_id('db.dbo.seque') and name='s_id'
è¾åºç»æã
END
VC使ç¨æ¡ä¾
1
å©ç¨adoæ¹æ³è°ç¨æ°æ®åºï¼è®°å½éæå¼sqlè¯å¥ï¼å¦å¾æ示ã
æ¥éª¤é 读
ï¼DBæ¯å·²ç¥åå¨çæ°æ®åºï¼ã
2
è¾åºç»æï¼æ¾ç¤ºåºè¯¥è¡¨ä¸ææå段ååå±æ§ã
END
å¤æå·²ç¥è¡¨ä¸æ个å段æ¯å¦åå¨
sqlè¯å¥ï¼select * from DB..syscolums where id=object_id('db.dbo.seque') and name='s_id'
è¾åºç»æã
END
VC使ç¨æ¡ä¾
1
å©ç¨adoæ¹æ³è°ç¨æ°æ®åºï¼è®°å½éæå¼sqlè¯å¥ï¼å¦å¾æ示ã
æ¥éª¤é 读
温馨提示:答案为网友推荐,仅供参考