Adding More Test Data for Query Statements in SQL Server

Q

How To Add More Data to the Testing Table in SQL Server?

✍: FYIcenter.com

A

If you want to continue with other tutorial exercises in this FAQ collection, you need to add more data to the testing table. Follow the script below to add a new column and more rows:

ALTER TABLE fyi_links ADD tag VARCHAR(8)
GO

UPDATE fyi_links SET tag = 'DEV' WHERE id = 101
GO
UPDATE fyi_links SET tag = 'DBA' WHERE id = 102
GO
UPDATE fyi_links SET tag = 'SQA' WHERE id = 103
GO

INSERT INTO fyi_links VALUES (104, 
   'www.mysql.com', '', '0', '2006-01-01', 'DBA')
GO
INSERT INTO fyi_links VALUES (105,
   'www.oracle.com', '', '0', '2005-01-01', 'DBA')
GO
INSERT INTO fyi_links VALUES (106,
   'www.php.net', '', '0', '2004-01-01', 'DEV')
GO
INSERT INTO fyi_links VALUES (107, 
   'www.winrunner.com', '', '0', '2003-01-01', 'SQA')
GO

UPDATE fyi_links 
   SET counts = CAST(LOG(id)*1000000 AS INT) % 1000
GO

SELECT * FROM fyi_links
GO
id   url                notes  counts  created     tag
101  dev.fyicenter.com  NULL   120     2006-04-30  DEV
102  dba.fyicenter.com  NULL   972     2007-05-19  DBA
103  sqa.fyicenter.com  NULL   728     2007-05-19  SQA
104  www.mysql.com             390     2006-01-01  DBA
105  www.oracle.com            960     2005-01-01  DBA
106  www.php.net               439     2004-01-01  DEV
107  www.winrunner.com         828     2003-01-01  SQA

 

Using SELECT Statements and GROUP BY Clauses in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-26, 530👍, 0💬