摘要:
我把一张表分成两张表为:CREATETABLEtest(t_idINTIDENTITY(0,1)NOTNULL,t_nameVARCHAR(10))CREATETABLEtest2(t_id2INTNOTNULL,t_infoVARCHAR(2000))向两个表test和test2中插入数据,并保证此数据的t_id和t_id2的值一致.INSERTINTOtest(t_name)VALUES('eeeeef');INSERTINTOtest2(t_id,t_name)SELECT@@IDENTITYAS'Identity','fffff'试了试, 阅读全文
posted @ 2011-10-17 15:17
旋律逍遥
阅读(1290)
评论(0)
推荐(0)

浙公网安备 33010602011771号