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, 1295🔥, 0💬
Popular Posts:
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...