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, 1482🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...