`
xitong
  • 浏览: 6190100 次
文章分类
社区版块
存档分类
最新评论

SQL Server 巧用'' as where_used

 
阅读更多
在创建view时,有某个字段可以写成'' as where_used,在获取view的其他值后,在给它捞数据,这是一种方式,当然也可以直接连接查询创建该view,这样取得view时就有where_used字段的值了。
分享到:
评论

相关推荐

    Programming.Microsoft.SQL.Server.2000.with.XML

    The book covers XML-related functionality in SQL Server 2000 and describes how this functionality can be used to build a solution that exchanges data in XML format. Because a great deal of the ...

    SQL Server Integration Services Design Patterns(Apres,2ed,2014)

    SQL Server Integration Services Design Patterns is newly-revised for SQL Server 2014, and is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book help to solve ...

    查询数据库状态

    sum(CAST(FILEPROPERTY(name, ''SpaceUsed'') AS INT))/128.0 as Space_Used_MB, SUM( size)/128.0 - sum(CAST(FILEPROPERTY(name,''SpaceUsed'') AS INT))/128.0 AS Free_Space_MB from sys.database_files where ...

    微软内部资料-SQL性能优化3

     Differentiate locks, latches, and other SQL Server internal “locking” mechanism such as spinlocks and other synchronization objects. Recommended Reading  Chapter 14 “Locking”, Inside SQL ...

    微软内部资料-SQL性能优化5

    In a nonclustered index, the leaf level contains each index key, plus a bookmark that tells SQL Server where to find the data row corresponding to the key in the index. A bookmark can take one of two ...

    Microsoft SQL Server 2008 - T-SQL Querying

    Where appropriate, some level of discussion will be at the technical level. But, for the most part, the book is about issues and techniques. This book is meant to serve as a guideline for the designer...

    微软内部资料-SQL性能优化2

    Although 2 GB of address space may seem like a large amount of memory, application such as SQL Server could leverage more memory if it were available. The boot.ini option /3GB was created for those ...

    webwizforums 7.7 SQL 版

    tblActiveUsers - table removed from the database as it is no-longer used 6. msSQL_server_setup.asp - removed the creating of the tblActiveUsers table and the stored procedures:- ...

    最全的oracle常用命令大全.txt

    如果我们想知道user_indexes表各字段名称的详细含义,可以用下面这条SQL语句: SQL>select column_name,comments from dict_columns where table_name='USER_INDEXES'; 依此类推,就可以轻松知道数据字典的详细...

    IderaSQLDiagnosticManagerForMySQL-Linux-x64-rpm.zip

    the daemon script 'MONyogd' can be used to start/stop the server. This script is installed in the directory "/etc/init.d/". You can use one of the following commands to start MONyog: # service ...

    Citrix_XenApp5

    • often be deployed in scenarios where machines are older, slower, or not in need of additional configuration options such as the Start menu and desktop shortcuts • Program Neighborhood • Oldest ...

    kbmMW v1.02 Commercial for Delphi n BCB incl Source

    Usually 3-tier models are used, where one tier is the backend database engine, one is the front end client and one is just in between them, also named the application server or business logic node....

    kbmMW v1.07e Commercial for Delphi n BCB incl Source

    Usually 3-tier models are used, where one tier is the backend database engine, one is the front end client and one is just in between them, also named the application server or business logic node....

    kbmMW v1.06 Commercial for Delphi n BCB incl Source

    Usually 3-tier models are used, where one tier is the backend database engine, one is the front end client and one is just in between them, also named the application server or business logic node....

    kbmmware

    Usually 3-tier models are used, where one tier is the backend database engine, one is the front end client and one is just in between them, also named the application server or business logic node....

    经典小巧的表格组件 EhLib4.14

     event, where programm can transfer SQL expression on the server.  There are several components that inherited from TSQLDataDriverEh, which  can send SQL expressions on the server through the ...

    php.ini-development

    as it gets it. On production servers, 4096 bytes is a good setting for performance ; reasons. ; Note: Output buffering can also be controlled via Output Buffering Control ; functions. ; Possible ...

    High Performance MySQL

    We emphasize reliability and correctness just as much as performance, in part because we have used MySQL ourselves for applications where significant amounts of money are riding on the database server...

    Database Processing Fundamentals, Design, and Implementation (12th Edition).rar

    Combing the SQL WHERE Clause and the SQL ORDER BY Clause Performing Calculations in SQL Queries Using SQL Built-in Functions SQL Expressions in SQL SELECT Statements Grouping in SQL SELECT Statements ...

    mysql示例数据库 employee

    A sample database with an integrated test suite, used to test your applications and database servers This repository was migrated from Launchpad. See usage in the MySQL docs Where it comes from The...

Global site tag (gtag.js) - Google Analytics