20211009 就採果了
比去年還多N倍,阿爸留下來的苦茶樹大果
在這3年被我細心照顧下,產量已漸好起來了
去年採的生果不到百顆,今年就爆量了;真是開心
可以摧芽育苗好多
UPDATE x
SET x.CODE_DEST = x.New_CODE_DEST
FROM (
SELECT CODE_DEST, ROW_NUMBER() OVER (ORDER BY [RS_NOM]) AS New_CODE_DEST
FROM DESTINATAIRE_TEMP
) x
--
CREATE FUNCTION [dbo].[SplitCsv]
(
@csvString nvarchar(2048),
@delimiter nchar(1)
)
RETURNS @values TABLE (value nvarchar(2048))
AS
BEGIN
DECLARE @x XML
SET @x = CONVERT(XML,
'<n>' + replace(@csvString, @delimiter, '</n><n>') + '</n>')
INSERT INTO @values
SELECT T.n.value('.','varchar(2048)') FROM @x.nodes('n') T(n)
RETURN
END
--使用範例
SELECT * FROM HumanResources.Department
WHERE DepartmentID IN (
SELECT value FROM dbo.SplitCsv('1,3,5,7', ',')
)