Answer» Hi all, I am learning SQL and LOOK for an application area to APPLY my queries. I know they can be used in SQL Server or else but I nedd more SIMPLE and easy way to see what I have learned and do they work? Something to create tables and then use queries. Thanks.MS Access would seem a good choice for practicing with SQL. SQL Server uses T-SQL, and if that is what you are learning, it won't help alot. I am just beginning to learn T-SQL myself and the differences from SQL used in Access and VBA is significant.
BenThanks. So you say I may find professional environment In access to practice SQL. Is there a big difference Between Trans.SQL and SQL? Because I know SQL serv 2000 a little and think to go further. May be it's better to go along with Tr-SQL? If you already know T-SQL, using more standard SQL should be a breeze. I get confused with T- more because of all of the @ signs and varchar's ETC. More standard SQL such as you would use in Access (SELECT * FROM tblMain) seems alot cleaner to me.
If you have MS Access, you can use the standard Northwind database and build queries in the SQL view of the QBE using straight SQL. I can't think of a better way to practice. Also, it is just test data so you really can't mess anything up.
Good Luck!Thanks a lot. I ll use MS Access
|