- No INSERT, UPDATE or DELETE statements, only SELECT.
- No command execution.
- No wild cards for fields, all fields must be explicitly typed.
- No JOIN statement. However, we can include information from parent objects like Select name, phone, account.name from contact.
- No UNION operator.
- Queries cannot be chained together.
Use the following command to reseed YourTableNameHere to start at 1:
DBCC CHECKIDENT (YourTableNameHere, RESEED, 0)