search sources.xml under C:
Just use Notepad or something to edit the file as needed (remove, add, etc)
Sunday, October 31, 2010
Wednesday, October 27, 2010
SQL join multiple tables (SQL join多个表)
NNER JOIN 连接两个数据表的用法：
SELECT * FROM 表1 INNER JOIN 表2 ON 表1.字段号=表2.字段号
INNER JOIN 连接三个数据表的用法：
SELECT * FROM (表1 INNER JOIN 表2 ON 表1.字段号=表2.字段号) INNER JOIN 表3 ON 表1.字段号=表3.字段号
INNER JOIN 连接四个数据表的用法：
SELECT * FROM ((表1 INNER JOIN 表2 ON 表1.字段号=表2.字段号) INNER JOIN 表3 ON 表1.字段号=表3.字段号) INNER JOIN 表4 ON Member.字段号=表4.字段号
INNER JOIN 连接五个数据表的用法：
SELECT * FROM (((表1 INNER JOIN 表2 ON 表1.字段号=表2.字段号) INNER JOIN 表3 ON 表1.字段号=表3.字段号) INNER JOIN 表4 ON Member.字段号=表4.字段号) INNER JOIN 表5 ON Member.字段号=表5.字段号
连接六个数据表的用法：略，与上述联接方法类似，大家举一反三吧：）
注意事项：
在输入字母过程中，一定要用英文半角标点符号，单词之间留一半角空格；
在建立数据表时，如果一个表与多个表联接，那么这一个表中的字段必须是“数字”数据类型，而多个表中的相同字段必须是主键，而且是“自动编号”数据类型。否则，很难联接成功。
代 码嵌套快速方法：如，想连接五个表，则只要在连接四个表的代码上加一个前后括号（前括号加在FROM的后面，后括号加在代码的末尾即可），然后在后括号后 面继续添加“INNER JOIN 表名X ON 表1.字段号=表X.字段号”代码即可，这样就可以无限联接数据表了：）
SELECT * FROM 表1 INNER JOIN 表2 ON 表1.字段号=表2.字段号
INNER JOIN 连接三个数据表的用法：
SELECT * FROM (表1 INNER JOIN 表2 ON 表1.字段号=表2.字段号) INNER JOIN 表3 ON 表1.字段号=表3.字段号
INNER JOIN 连接四个数据表的用法：
SELECT * FROM ((表1 INNER JOIN 表2 ON 表1.字段号=表2.字段号) INNER JOIN 表3 ON 表1.字段号=表3.字段号) INNER JOIN 表4 ON Member.字段号=表4.字段号
INNER JOIN 连接五个数据表的用法：
SELECT * FROM (((表1 INNER JOIN 表2 ON 表1.字段号=表2.字段号) INNER JOIN 表3 ON 表1.字段号=表3.字段号) INNER JOIN 表4 ON Member.字段号=表4.字段号) INNER JOIN 表5 ON Member.字段号=表5.字段号
连接六个数据表的用法：略，与上述联接方法类似，大家举一反三吧：）
注意事项：
在输入字母过程中，一定要用英文半角标点符号，单词之间留一半角空格；
在建立数据表时，如果一个表与多个表联接，那么这一个表中的字段必须是“数字”数据类型，而多个表中的相同字段必须是主键，而且是“自动编号”数据类型。否则，很难联接成功。
代 码嵌套快速方法：如，想连接五个表，则只要在连接四个表的代码上加一个前后括号（前括号加在FROM的后面，后括号加在代码的末尾即可），然后在后括号后 面继续添加“INNER JOIN 表名X ON 表1.字段号=表X.字段号”代码即可，这样就可以无限联接数据表了：）
How to monitor / check the current connections to iis per site
@ Web Service \ Current Connections perfmon counter -- get either _Total or per site.
Friday, October 22, 2010
Remove the IE warning - ‘Do you want to view only the webpage content that was delivered securely?’
Internet Explorer interrupts the download and displays a confirmation dialog whenever it detects the use of mixed content on a secure page.
In IE 7 and ealier, this dialog would cause annoyance to users but generally didn’t cause any other significant problems. This was because it was worded in such a way that most users would click on the Yes button and allow non-secure content to be downloaded.
However, the wording in the IE 8 version of this dialog has changed:
here's what you need to do if you don't want to see that dialog:
Note that if the site you are visiting is NOT on the internet zone, you would have to make the changes to the appropiate zone:
here's how you tell which "zone" you are on, on the bottom right hand corner of the browser you should see something like this:
If you double click that, you can make changes to the other zones (Local Intranet, Trusted sites, restricted sites)
Just click the zone you want, and it will bring up the first dialog (from this post) where you can make the change.
In IE 7 and ealier, this dialog would cause annoyance to users but generally didn’t cause any other significant problems. This was because it was worded in such a way that most users would click on the Yes button and allow non-secure content to be downloaded.
However, the wording in the IE 8 version of this dialog has changed:
here's what you need to do if you don't want to see that dialog:
tools>internet options>security>custom level>display mixed content: enable
Note that if the site you are visiting is NOT on the internet zone, you would have to make the changes to the appropiate zone:
here's how you tell which "zone" you are on, on the bottom right hand corner of the browser you should see something like this:
If you double click that, you can make changes to the other zones (Local Intranet, Trusted sites, restricted sites)
Just click the zone you want, and it will bring up the first dialog (from this post) where you can make the change.
Add an Output Caching Rule (IIS 7)
Applies To: Windows 7, Windows Server 2008, Windows Server 2008 R2, Windows Vista
Output cache rules are helpful when you must cache requests for a certain file type differently than for other file types on your server, site, or application. For example, you might want to keep ASP.NET pages in the cache longer than other file types in your application because the ASP.NET pages require more resources for processing than would the other file types.
Output cache rules are helpful when you must cache requests for a certain file type differently than for other file types on your server, site, or application. For example, you might want to keep ASP.NET pages in the cache longer than other file types in your application because the ASP.NET pages require more resources for processing than would the other file types.
Prerequisites
For information about the levels at which you can perform this procedure, and the modules, handlers, and permissions that are required to perform this procedure, see Output Caching Feature Requirements (IIS 7) [ http://technet.microsoft.com/en-us/library/cc754226(WS.10).aspx ] .
Exceptions to feature requirements
Exceptions to feature requirements
- None
To create an output cache rule
You can perform this procedure using the user interface (UI) or a command line.
To use the UI
To use the UI
- Open IIS Manager and navigate to the level you want to manage. For information about opening IIS Manager, see Open IIS Manager (IIS 7) [ http://technet.microsoft.com/en-us/library/cc770472(WS.10).aspx ] . For information about navigating to locations in the UI, see Navigation in IIS Manager (IIS 7) [ http://technet.microsoft.com/en-us/library/cc732920(WS.10).aspx ] .
- In Features View, double-click Output Caching.
- Click Add in the Actions pane.
- In the Add Cache Rule dialog box, in the File name extension box, enter the file name extension, such as .aspx, for which you want to create a cache rule.
- Select the User -mode caching check box to enable output caching, and select one of the following options:
- Using file change notifications: if you want an item to be removed from the cache when it is updated.
- At time intervals (hh:mm:ss): if you want an item to be removed from the cache after a certain time elapses. Then type a time in the format of hh:mm:ss (where h is hours, m is minutes, and s is seconds) in the corresponding box.
Note
If you configure different values for this property in the User-mode caching and Kernel-mode caching sections, the value in the Kernel-mode caching section will be used. - Prevent all caching: to prevent all caching of the designated file type.
- Using file change notifications: if you want an item to be removed from the cache when it is updated.
- Select the Kernel-mode caching check box if you want to enable kernel caching in addition to output caching, and select one of the following options:
- Using file change notifications: if you want an item to be removed from the cache when it is updated.
- At time intervals (hh:mm:ss): if you want an item to be removed from the cache after a certain time elapses. Then type a time in the format of hh:mm:ss (where h is hours, m is minutes, and s is seconds) in the corresponding box.
- Prevent all caching: to prevent all caching of the designated file type.
- Using file change notifications: if you want an item to be removed from the cache when it is updated.
- Click OK.
Configuration
The procedure in this topic affects the following configuration elements:
For more information about IIS 7 configuration, see IIS 7.0: IIS Settings Schema [ http://go.microsoft.com/fwlink/?LinkId=88551 ] on MSDN.
source: http://technet.microsoft.com/en-us/library/cc770547%28WS.10,printer%29.aspx
For more information about IIS 7 configuration, see IIS 7.0: IIS Settings Schema [ http://go.microsoft.com/fwlink/?LinkId=88551 ] on MSDN.
source: http://technet.microsoft.com/en-us/library/cc770547%28WS.10,printer%29.aspx
Thursday, October 21, 2010
Which Size HDTV is Right for My Room?
With standard-definition TVs, the rule used to be that viewers would feel comfortable watching a set from a distance of 3 to 6 times the screen size in inches. With HDTV, the resolution is so much better that you can sit closer to a larger TV without noticing the pixels. So with HDTVs, the rule tends to be you can sit anywhere from 1.5 to 3 times the screen size (in inches) for the best experience.
If you know the size of the room you have already, where you want to sit, and where your new HDTV should go once you get it, you can figure out the size HDTV you should get.
- Minimum size = Viewing distance/3
- Maximum size=Viewing distance/1.5
Subscribe to:
Posts (Atom)