Question

如何从数据库一个表中读取主键并插入另外一个表？

实现功能是：在发帖的同时上传图像，并把发的当前帖子的ID（表Topci，主键是ID，自增字段）同时插入到表Img的Topic中，怎么样才能获取Topic表的主键ID？
我现在的插入语句是： "insert into Img(Image_Wpath,Imge_User,Topic_ID,UpLoad_Time) values(" + "'" + wpath + "'" + "," + "'" + Session["UserName"].ToString() + "'" + "," + "'" + ImgID.ToString() + "'" + "," + "'" + DateTime.Now.ToString() + "'" + ");";
应该怎样修改？用的是VS2008，SQL2005。

Answer 1

用纤丛坦带返回毁桐值参数的sql 啊
比如 INSERT INTO [ABC].[dbo].[tABC]
([A]
,[B]
,[C])
VALUES
('A'
,'B'
,'C')

select @@identity
或者做一个郑羡存储过程什么的

追问

select identity()怎么用？按我这个语句的话怎么修改？

追答

@@identity
是一个全局变量，记录的是最新主键的值

追问

我现在用了string contentsSave = "insert into Topic(Topic_Title,Topic_Time,Topic_Content,Topic_User) values(" + "'" + Topic_Title + "'" + "," + "'" + DateTime.Now.ToString() + "'" + "," + "'" + Topic_Content + "'" + "," + "'" + Session["UserName"].ToString() + "'" + ");select @@identity;";
int ImgID = (int)Tcmd.ExecuteScalar();
也还是报错。说不能强制转换，必须是小于无限大的数。

Answer 2

insert into img(Topic) value (select Id from Topic )
试一下