I figured out how to login to a database but haven't done much else
C:\ isql -U database (ie ctrain) then you get prompted for a password
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/qryanlzr/qryanlzr_7v02.asp Color Coding in Query Analyzer
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/qryanlzr/qryanlzr_7v02.asp Talks about the different icons in the Query Analyzer screen
We also talked about Analyzing queries http://msdn.microsoft.com/library/default.asp?url=/library/en-us/qryanlzr/qryanlzr_3cj2.asp
And using Object Search http://msdn.microsoft.com/library/default.asp?url=/library/en-us/qryanlzr/qryanlzr_3cj2.asp
and system functions
rowset - used when connecting to a database on another server, the rowset behaves like an object
aggregate - use with group by to get a total of products (for example) for a unit
scalar - only use when you want to return a single value
Query Analyzer Query Menu
Results in Text - shows messages on the same pane as query results
Results in Grid - shows messages on a different pane labeled messages than results
Results to File
Object Browser
Can right click on table and choose Script Object to New Window to see SQL statements that created the table
I suggested that we try to create a non comshare sql database to practice on.
We also talked some about stored procedures and using the debugger.
Please feel free to elaborate on what I missed.
Are folks interested in meeting next Tuesday? We discussed Cheryl covering Chapter 3 after New Year's since she will be gone until then.
Best,
Susan Gross
Product Support Specialist
Phone: 734-994-5212 or +(0) 20 7349-6060 (UK)
FAX: 734-994-1399
Email: sgross@comshare.com
Web Page: http://support.comshare.com/
When you add a primary key to a table, a clustered index is automatically created unless you specify that it should be non-clustered, or there is already a clustered index on the table. Susan 3:42 PM
The fixed server roles that can create databases are:
sysadmin
dbcreator
These are the roles that can do this by default, although you can grant the permissions to others. Susan 3:41 PM
Do not use reserved keywords to name objects in an SQL Server database. MSDN has a list of the reserved keywords.