Below is the query to insert random data to a table 'company' with columns 'Companyname', 'Location', 'Country', Telephone'.
DECLARE @NoOfRecords INT
DECLARE @i INT
SET @NoOfRecords = 10
SET @i = 1
WHILE (@i<@NoOfRecords)
BEGIN
INSERT INTO Company (Companyname
,Location
,Country
,Telephone)
SELECT 'Organisation Name - ' + CONVERT(VARCHAR(10),@i)
,'Location Name - ' + CONVERT(VARCHAR(10),@i)
,'Country Name - ' + CONVERT(VARCHAR(10),@i)
,91441234 + (@i %1000)
SET @i = @i+1
END
select * from Company
This blog contains posts related to data warehouse. All posts are used in my real time project and can be used as reusable codes and helpful to BI developers.
Labels
Apache Hadoop
(3)
ASP.NET
(2)
AWS S3
(2)
Batch Script
(3)
BigQuery
(21)
BlobStorage
(1)
C#
(3)
Cloudera
(1)
Command
(2)
Data Model
(3)
Data Science
(1)
Django
(1)
Docker
(1)
ETL
(7)
Google Cloud
(5)
GPG
(2)
Hadoop
(2)
Hive
(3)
Luigi
(1)
MDX
(21)
Mongo
(3)
MYSQL
(3)
Pandas
(1)
Pentaho Data Integration
(5)
PentahoAdmin
(13)
Polybase
(1)
Postgres
(1)
PPS 2007
(2)
Python
(13)
R Program
(1)
Redshift
(3)
SQL 2016
(2)
SQL Error Fix
(18)
SQL Performance
(1)
SQL2012
(7)
SQOOP
(1)
SSAS
(20)
SSH
(1)
SSIS
(42)
SSRS
(17)
T-SQL
(75)
Talend
(3)
Vagrant
(1)
Virtual Machine
(2)
WinSCP
(1)
No comments:
Post a Comment