MS SQL Server Interview Question:

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

Submitted by: Administrator

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 ggl_links ADD tag VARCHAR(8)
GO

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

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

UPDATE ggl_links
SET counts = CAST(LOG(id)*1000000 AS INT) % 1000
GO
Submitted by: Administrator

<pre>
SELECT * FROM ggl_links
GO
id url notes counts created tag
101 globalguideline.com NULL 120 2006-04-30 DEV
102 globalguideline.com/sql NULL 972 2007-05-19 DBA
103 globalguideline.com/xml 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
</pre>
Submitted by: Administrator