If you have study about the Introduction of Database before, then, you have to practice to make a table. This is the example of Rep Table. Write this syntax on your SQL 2000 Query Analyzer.
After you write the syntax above on your Query Analyzer, press F5 to run it. There's a notification that the program run successful if the syntax is correct. Next, delete the syntax above and replace with this syntax.
Press F5 again to run that syntax. Okay, now I will explain about the syntax above.
- SELECT * FROM Rep
- this mean we show all the column from Rep Table.
- SELECT City FROM Rep
- this mean we only show the City column from Rep Table.
- SELECT FirstName, LastName FROM Rep
- this mean we only show the FirstName and LastName column from Rep Table.
Use this syntax to sort the column that you want sort by.
Okay, that's all about Creating Table in SQL. Thanks for you kind attention. If there's any critical or suggestion, please write on the box below. Keep visiting IT Programmer.
"Om Santhi, Santhi, Santhi, Om"