为每个计算的日期发送SQL字符串 [英] Sending SQL string in for every calculated date
问题描述
你好,
我现在有一个sql字符串,我需要在两个日期之间的每一天发送它。比如,如果您的第一个日期是01.01.0001,最后一个日期是03.01.0001那么,该字符串应该在每个日期发送3次(01. + 02. + 03.01.0001)
当我需要为每个选定的会员ID发送字符串时,我可以将其集成到我的脚本中吗?
这意味着,如果我有3个ID,3天,每个ID = 3个字符串将有3个字符串。
请注意,日期是动态的以及ID的数量。
我尝试过:
Hello there,
I have a sql string now, and I need to send it in, for every day between 2 dates. like, if the first date yould be, 01.01.0001 and the last date would be 03.01.0001 then, the string should be send 3 times in with every date (01. + 02. + 03.01.0001)
Any ideas for I can integrate that in my script when I already need to send the string in for every selected member ID?
That means, if I have 3 IDs, and 3 days, there would be 3 strings for every ID = 9 strings per total.
Please note, that the dates are dynamic as well as the amout of IDs.
What I have tried:
foreach (DataRow row in m_dt.Rows) {
foreach (var item in row.ItemArray) {
string sqlString = "INSERT INTO [table] ([id] ,[day] ,[month] ,[year]) VALUES('" + item + "', '" + reason + "', '10', '08', '2016', '1' )";
Sendin( sqlString );
}
推荐答案
请阅读解决方案循环:
SQL Server循环 - 如何循环浏览一组记录 - Stack Overflow [ ^ ]
Please read the solution to loop through:
SQL Server loop - how do I loop through a set of records - Stack Overflow[^]
这篇关于为每个计算的日期发送SQL字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!