舉報 
會員
phpMyAdminStarter (Microcontent)
最新章節(jié)：
Index
ThisisapracticalguideprovidingcomprehensivesolutionsforSQLqueryproblems,andisfullofconcretereal-worldexamplestohelpyoucreateandtroubleshootyourSQLqueriesinSAPBusinessOne.IfyouareasystemadministratorwhousesSQLqueryasyourtoolofchoiceforsolvingspecificproblemsthroughoutSAPBusinessOne,thenthisbookisforyou.Itmayalsobeusefulifyouareadeveloperorconsultantusingthistechnology,andcanbenefitendusersbyimprovingyoursearchforimportantbusinessinformation.ArudimentaryknowledgeofSAPBusinessOneandSQLServerisrequiredtousethisbookefficiently.ExamplescoveredarerelevanttoSBO2007Ausers,forwhichthe8.8releaseismostlycompatible.AllSQLqueryexampleswithinthebookareverifiedunderSQLServer2005,sotheyareguaranteedtorununderthisrelease,inadditiontoSQLServer2008.Non-SAPBusinessOneuserscanalsogainknowledgefromthemanyexamplesthroughoutthebook.ItishardtofindanotherbookwithsomanySQLqueryexamples.
目錄(82章)
倒序
- 封面
- 版權信息
- Credits
- About the Author
- Acknowledgement
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- Business Intelligence (BI)
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Part 1. SQL Query Basic
- Chapter 1. SAP Business One Query Users and Query Basics
- Who can benefit from using SQL Queries in SAP Business One?
- SQL query and related terms
- Data dictionary
- Table links—the key for the right query
- Base tables versus target tables
- Keeping it simple—The key to build a good query
- Summary
- Chapter 2. Query Generator and Query Wizard
- Query Generator
- Query wizard
- What is the difference between Query generator and Query wizard?
- Benefitting from built-in system queries
- Summary
- Chapter 3. Query Manager and Query Statements
- Query manager user interface
- Commonly used statements
- Some important functions to return values
- Summary
- Part 2. SQL Query in Action
- Chapter 4. Query Examples
- Why three categories have been chosen
- Defining variables for queries
- Date function—where the most problems emerge
- Orange arrow—an excellent tool for drill down
- Getting a subtotal from the query
- Query for marketing documents
- Query for inventory transactions
- Query for financial transactions
- User query for alert
- Miscellaneous query examples
- Summary
- Chapter 5. Securities and Approvals
- How to handle securities for query usage
- How to use query for approval procedures
- Examples of user queries for approval
- Summary
- Chapter 6. SQL Query for Formatted Search (FMS)
- Formatted Search and User-Defined Values
- How to work with User-Defined Values
- A typical FMS query application: auto code creation
- General FMS query examples
- Summary
- Chapter 7. SQL Query for Reporting Tools
- Query Print Layout Designer (QPLD) and its usage
- Direct query for Crystal Reports (Command)
- Summary
- Chapter 8. SQL Query for a Stored Procedure
- Why Stored Procedure is included in this book
- SBO_SP_TransactionNotification overview
- How to work with SBO_SP_TransactionNotification
- Some example queries for this SP
- Summary
- Chapter 9. More Complicated SQL Query Topics
- The Case expression usage
- Working with a subquery
- Using PIVOT to simplify a cross tab style queries
- Database query for Excel
- Avoiding pitfalls while building queries
- Summary
- Appendix A. Appendix
- Original transaction list by code
- Original transaction list by name
- Object codes and names
- Index 更新時間：2021-04-02 19:18:47
推薦閱讀
- Enhancing Microsoft Content Management Server with ASP.NET 2.0
- Photoshop CC 網店視覺設計
- 中文版CorelDRAW 2022基礎教程
- 中文版Photoshop CS6平面設計實例教程（第2版）
- Ogre 3D 1.7 Beginner's Guide
- Illustrator 2024從入門到精通
- Microsoft Silverlight 5: Building Rich Enterprise Dashboards
- Vue.js快速入門
- Excel公式、函數(shù)與圖表案例實戰(zhàn)從入門到精通（視頻自學版）
- Adobe創(chuàng)意大學Photoshop產品專家認證標準教材（CS6修訂版）
- Linux Shell Scripting Cookbook
- 中文版Flash CS6動畫制作（慕課版）
- TopSolid Wood軟件設計技術與應用
- Professional Azure SQL Database Administration
- Photoshop人像精修秘笈
- Photoshop CS6淘寶美工完全實例教程（全視頻彩色版）
- SolidWorks上機實踐經典40例
- 用友(T3)會計信息化軟件考前12小時
- Photoshop CS6平面設計案例教程
- Apache Axis2 Web Services, 2nd Edition
- SOLIDWORKS 2018中文版完全自學手冊（第2版）
- Moodle 1.9 Teaching Techniques
- 中文版Photoshop 2021入門教程
- 中文版CorelDRAW X6學習手冊
- Creo Parametric中文版模具設計案例精通
- Drupal Intranets with Open Atrium
- 從零開始玩轉剪映
- AutoCAD 2017中文版完全自學手冊
- 攝影師的后期課：7小時學會攝影后期原理與實戰(zhàn)
- Arduino+3D打印創(chuàng)新電子制作
