如何为日期列编写游标 [英] how to write a cursor for date column

问题描述

hii，

hii ,

Insert into Holidays
Select @CompanyId,'New Year''s Day','',Convert(datetime, '01 January 2015', 103),
datename(dw,(Convert(datetime, '01 January 2015', 103))),
Year(Convert(datetime, '01 January 2015', 103)),0,1

，



我写了一个光标，所以我的所有假期都会被添加到所有公司。但是我只有5种类型的假期..这些也将在2022年之前的所有年份重复



如何管理我的日期栏...所以我不想要插入需要日期的列..我已经给出了我插入的一个列名..

,

I have written a cursor so all my holidays will gets added to all companies .. but i have only 5 type of holidays .. which will also gets repeated in all years till 2022

how can i manage my date column .. so i dont want to insert columns which requires date as well .. i have given my one column name which i am inserting ..

推荐答案

如果我理解你的话......



如果您想为每家公司添加假期，则不需要光标。所有你需要的是使用简单的 INSERT INTO 和 SELECT 语句。

If i understand you well...

If you would like to add holidays for each companies, you don't need cursor. All what you need is to use simple INSERT INTO with SELECT statement.

INSERT INTO Holidays (CompanyID, SomeField, OtherField, AnotherField, OneMoreField, SomeID1, SomeID2)
SELECT CompanyID, 'Day Description' AS SomeField, '' AS OtherField, datename(dw,(Convert(datetime, '01 January 2015', 103))) AS AnotherField,
Year(Convert(datetime, '01 January 2015', 103)) AS OneMoreField, 0 AS SomeID1, 1 AS SomeID2
FROM Companies

如需了解更多信息，请参阅此处：

INSERT（T-SQL） [ ^ ]

INSERT示例（T-SQL） [ ^ ]

这篇关于如何为日期列编写游标的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！