How to select a OptionSet on ms sqlserver database for Microsoft Dynamics CRM
2023-09-11 14:21:33 时间
OptionSet:
Select * from StringMap
Global OptionSet:
select os.Name, l.Label from AttributePicklistValueAsIfPublishedLogicalView av
join OptionSetAsIfPublishedLogicalView os
on av.OptionSetId = os.optionsetid
join LocalizedLabelAsIfPublishedLogicalView l
on l.ObjectId = av.AttributePicklistValueId
where os.IsGlobal = 1 and os.IsCustomOptionSet = 1
and os.Name = 'new_xxx'
相关文章
- Logon database Tiger引起DataGuard不同步问题
- EDBC(Emacs-Lisp Database Connectivity)
- Connect to DB2 database in eclipse via jdbc
- 解决报错(Could not create connection to database server.)
- 转 OGG Troubleshooting-Database error 1 (ORA-00001: unique constraint ...)
- Plugging an Unplugged Pluggable Database
- EM 12c: OMS Failed to start After restarting the Repository Database or reboot of the server
- Attempt to fetch logical page (1:164360) in database 17 failed. It belongs to allocation unit 72057594328317952 not to 281474980642816.
- MySQL数据库断电修复(Database page corruption on disk or a failed)
- ### Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 必须声明标量变量 "@P23@P24"。(sql少一个逗号)【??】