by Administrator | Jan 19, 2018 | Query
Use this query to mass create job numbers: Insert Into [Job] ([DBId], [Id], [Number], [ClientId], [JobTypeId], [DivisionId], [Description], [Actif], [Archive], [JobServiceTRRestriction], [StartDate], [EndDate], [Chargeable], [Status], [TRLockType],...
by Administrator | Oct 28, 2016 | Query
Create a unique index: Create Unique Index [Id] on [G1] ([DBId], [GLPeriodId], [EntryNumber], [LineNumber])
by DOS | Oct 16, 2014 | Query
Where condition with upper/lower case consideration: Select * from Document where StrComp(Extension, “.PDF”, 0) = 0
by DOS | Jul 23, 2014 | Query
1) Select Environment, count(*) from VersionLink Group by Environment 2) Select Environment, count(*) from VersionLink where not Environment = ‘Your Environment’ Group by Environment 3) Select * from VersionLink where not Environment =...
by DOS | Jul 16, 2014 | Query
List the existing triggers: Select * from sysobjects where type = ‘TR’ order by Name Specififc Trigger Select Text from syscomments where Text like ‘%CompanyPerson%’
by Administrator | Jan 22, 2014 | Query
To drop a field from a specific table, do the following: Open Microsoft Sql Server Management Studio Connect to the desired database and create a new query Paste the following in the window: ALTER TABLE [TableName] DROP COLUMN [ColumnName] Execute the...