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)

Friday, November 19, 2010

SQL query to insert record with random data

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

No comments:

Post a Comment