DECLARE @d varchar(10) = CONVERT(VARCHAR(8), GETDATE()-365, 112) print @d the output will is: 20130901

http://www.sql-server-helper.com/tips/date-formats.aspx

SELECT TOP (1000) [yz3_location] ,[yz3_style] ,[yz3_qty] ,CONVERT(VARCHAR(8),[date],112) as d ,sl_repl_trans.dbo.send_stock_over_url(yz3_style,yz3_qty,date ) AS success FROM [SL_repl_trans].[dbo].[yz3_stock_h] 01.09.14

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024