这样的话, user_id 只能是一个固定的值。
如
string user_id = "10";
strSql = "INSERT INTO Radio_playList (user_id,ss_id,ss_mp3name,ss_name,ss_geci) SELECT '"+user_id+"',ss_id,ss_mp3name,ss_name,ss_geci FROM ssong";
如
string user_id = "10";
strSql = "INSERT INTO Radio_playList (user_id,ss_id,ss_mp3name,ss_name,ss_geci) SELECT '"+user_id+"',ss_id,ss_mp3name,ss_name,ss_geci FROM ssong";
strSql = "INSERT INTO Radio_playList (user_id,ss_id,ss_mp3name,ss_name,ss_geci) SELECT s2.UserID,s1.ss_mp3name,s1.ss_name,s1.ss_geci FROM ssong s1 Inner Join (Select '" + Session("userid") + "' As UserID From ssong) s2 On s1.ss_id = s2.ss_id"
ProvinceID,ProvinceName,DomainID,DomainName,SubcoID,SubcoName)
select distinct (从另一张表中查出相对应的数据)@CSC_ID,@LEND_ID,@LEND_IsInvoiced,@LEND_Requisition,CSC_Name,Employee_ID,Employee_Name,
Zone_Code,Zone_Name,Province_ID,Province_Name,Domain_ID,Domain_Name,Subco_ID,Subco_Name from Standard.dbo.ST_CSC_Area_CS
as V where V.CSC_ID=@CSC_ID