News:
Begin a transaction
Create a connection to the database
Create a data set using an adapter object
Use the data set to display data or to change items in the database
Update the database from the data set
Close the database connection
Check for transaction errors
Populate the data objects with data from the database. Populate the controls with values retrieved from the data objects.
Populate the business objects with data from the database. Populate the controls with values retrieved from the business objects.
Populate the data objects with data from the database. Populate the business objects with data from the data objects. Populate the controls with values retrieved from the business objects
Bind the controls directly to the database.
Quarter
dayofweek
dayofyear
weekday
Table Name
Database name
LIMIT clause
WHERE clause
Column Names
CHANGE TABLE
MODIFY TABLE
ALTER TABLE
UPDATE TABLE
SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC
SELECT * FROM Persons SORT REVERSE ‘FirstName’
SELECT * FROM Persons ORDER BY ‘FirstName’
SELECT * FROM Persons ORDER BY FirstName DESC
SELECT * FROM Persons ORDER BY DESC FirstName
Dec 31, 9999
Jun 6, 2079
Jan 1, 2753
Jan 1, 2100
desc myTable
desc table myTable
sp_columns myTable
None of the above
Using either option a or c
Loss of data from employee sabotage
Loss of data from any one corrupted table
Recursive joins
One-to-many or many-to-many relationships between columns in a table
Data redundancy
@@colcount
@@error
@@rowcount
@@version
All are valid global variables
Useful resources, Global Variables in SQL Server