摘要:
//01|02|03| ====> (01,02,03) string s = "("; for (int i = 0; i < countryid.Split('|').Length; i++) { if (i > 0 && i < countryid.Split('|').Length-1) { s += ","; } s +=countryid.Split('|')[... 阅读全文
摘要:
declare @NewsTitle nvarchar(255)declare mycursor cursor forselect title FROM lc_Article where t_id=1open mycursorfetch next from mycursor into @NewsTitleWhile(@@Fetch_Status = 0)begin INSERT INTO tb_News (NewsTitle) VALUES(@NewsTitle) fetch next from mycursor into @NewsTitle endclose mycur... 阅读全文
摘要:
declare @start int; declare @ends int; set @start=1; set @ends=49; while @start<=@ends begin set @start=@start+1 insert into tb_News(newstitle) values(@start); end 阅读全文