Collections:
Adding More Test Data for Query Statements in SQL Server
How To Add More Data to the Testing Table in SQL Server?
✍: FYIcenter.com
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
⇒ Sorting Query Output with ORDER BY Clauses in SQL Server
⇐ Selecting Some Specific Rows from a Table in SQL Server
⇑ Using SELECT Statements and GROUP BY Clauses in SQL Server
2016-10-26, 1277🔥, 0💬
Popular Posts:
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...