CNCEC_SUBQHSE_WUHUAN/DataBase/版本日志/SGGLDB_WH_V2024-09-11-phf.sql

5 lines
282 B
Transact-SQL

CREATE NONCLUSTERED INDEX [t_d_facerecord_Projectid_Index]
ON [dbo].[t_d_facerecord] ([ProjectId])
INCLUDE ([ID],[EmployName],[DepartmentID],[DepartName],[AreaID],[AreaName],[EmployNO],[CardID],[RoleID],[DateTimeRecord],[RecordDes],[FaceIP],[InOrOut],[Des1],[Des2],[Des3],[Des4])
;