Queries
- Query: Attach SQL Database
- Query: Display triggers
- Query: How to see connected users
- Query: How to drop a field
- Query: How to change a SQL Server database collation
- Query: Useful VersionLink Queries
- Query: Useful Query Examples
- Query: FAIA – Historical default values
- Query: How to create a unique index
- Query: How to mass create job numbers
- Query: How to create job numbers based upon job number
- Query: How to create jobs based upon job
- Query: How to delete unused Security records
- Query: How to select unbalanced accounting entries on all the databases
- Query: How to update a query in VersionSql table
- Query: Create SQL Database
- Query: Create UserOption
- Query: Select Countries and Translations
- Query: Select Companies having double VAT Number
- Query: Keep only last currency rate per year
- Query: View Groups for a specific Right
- Query: Delete all Currency rates that are not End of Year
- Query: Delete all Currency rates that are not End of Month
- Query: Update UserGroup
- Query: Count all records from all tables
- Query: Delete queries to create a standard Database
- Query: Balance on all accounts
Queries after upgrade:
- Queries: Issues with GLCaption
- Query: Select records with missing SecurityGLAccountId
- Query: Select missing Language records
- Query: Remove time from AccInterest.ToDate
- Query: Select TimeReport records with JobTaskId = -1
- Query: Select GLBankStatment with BCyAmount = 0
- Query: Select double GLAccountName numbers
- Query: Select Company with missing LegalName
Queries after upgrade V9: