-- Database DB, tabella Tabella1, campo date Data1.
-- Voglio inserire tutte le date del 2017, dal 1/1 al 31/12.
DECLARE @data date='2015-01-01'
WHILE @data < '2016-01-01'
BEGIN
INSERT INTO DB.dbo.Tabella1 (Data1)
VALUES (@data)
SET @data=DATEADD(day,1,@data)
END
GO
Categories
Bash
(3)
BOT
(2)
C#
(1)
Cluster Analysis
(1)
Data Cleaning
(6)
Data Ingestion
(2)
Data Science Specialization
(10)
Data Visualization
(15)
ggplot2
(1)
Hadoop
(1)
Hashnode
(3)
Machine Learning
(5)
MapReduce
(1)
Maps
(1)
Markdown
(7)
Market Basket Analysis
(1)
MATLAB
(1)
Matplotlib
(3)
Numpy
(2)
Octave
(1)
Pandas
(3)
Python
(17)
R
(22)
Regression
(7)
scikit-learn
(1)
Seaborn
(1)
Shell
(3)
Shiny App
(1)
SSIS
(3)
Statistical Inference
(2)
T-SQL
(8)
Unix
(3)
No comments:
Post a Comment