SQL Express Edition, SQL Compact Editin and SQLCMD for learning purpose
- by Mil
Hi,
I want to learn programming in SQL from some SQL tutorial sites of which I heard of here but I need some environment for executing query's. I think I have both SQL CE and SQL EE installed on my computer but I have some doubts about these DBMS and I don't know exactly how to use SQLCMD utility so I hope someone here will have time and will to explain me the following:
Since running sqlcmd -S.\sqlexpress at command prompt command gives "1" prompt I assume I have SQL express installed but anyway how can I be sure what I have installed on my machine since I cannot find in installed programs SQL Express Edition name?
Can I ship and use database with my C# (VC# Express) application which was created with SQL EE (embedded?)?
How can use sqlcmd for learning SQL, that is by issuing commands like create, use, select..., again emphasize is on learning SQL I do not want to run scripts but use interactive command prompt like with MySQL (since I want to use SQL I would pretty much like to avoid graphical tools for DBMS)?
Please tell me if you have some other advice regarding as to what should I better use in learning how to program in SQL or should I stick with the above for now.
Thanks in advance.
