Lost In Space

五指湖自助游攻略

• jQuery Custom [:] Expression Test
• jQuery Custom Selectors - holy Cow That Is So Badass
• Getting serious with jQuery - Adding custom CSS selectors
• Writing custom JQuery Selectors

<code class="mix"><span class="com">// Add this code anywhere you want (after jQuery has been loaded).</span> <br /><span class="com">// Edit it to add your own expressions.</span> <br /><span class="jquery">jQuery</span>.extend(<span class="jquery">jQuery</span>.expr[<span class="string">':'</span>], { <br />    <span class="com">///////////////////////////////////////////////////////////</span> <br />    <span class="com">// form elements that are submitable based on these criteria</span> <br />    <span class="com">//    element is not disabled</span> <br />    <span class="com">//    element has a selected or checked attribute</span> <br />    <span class="com">//    element is a textarea</span> <br />    <span class="com">//    element is an input of type text or hidden</span> <br />    <span class="com">//</span> <br />    <span class="com">//  @usage: $(':submitable')</span> <br />    <span class="com">//  @usage: $('#myForm :submitable')</span> <br />    submitable: <span class="string">"!a.disabled&&(a.selected||a.checked||(a.nodeName.toUpperCase()=='TEXTAREA')||(a.nodeName.toUpperCase()=='INPUT'&&(a.type=='text'||a.type=='hidden'||a.type=='password')))"</span>, <br /> <br />    <span class="com">///////////////////////////////////////////////////////////</span> <br />    <span class="com">// elements that have a type attribute not equal to hidden</span> <br />    <span class="com">//    use if you want to select all input elements that are not hidden</span> <br />    <span class="com">//  @usage: $('input:nothidden')</span> <br />    nothidden: <span class="string">"a.type&&a.type!='hidden'"</span> <br />}) <br /></code>

showModalDialog in Dialog Windows

ASP.NET Tutorial 22: Adding Client-Side Confirmation when Deleting

Lightbox Gone Wild
  lightbox can be used as modal dialog box
  need prototype
from Lokesh Dhakar's Lightbox and Lightbox 2

• jQuery lightBox plugin
• jQuery Lightbox Plugin (balupton edition)
• prettyPhoto
• FancyBox (IFrame)
• ThickBox
• facebox
• jQuery UI
• LiteBox
• lightWindow
• lightView
  

SELECT execution_count, st.text

FROM sys.dm_exec_query_stats as qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st

WHERE st.text like '%FETCH NEXT FROM outerCursor INTO%'

b) How to: Debug T-SQL Using the SQL Server Management Studio

still from Visual Studio (Pro/Team, not Standard or Express)

• Direct Database Debugging - from Visual Studio's Server Explorer, right-click on a database object
  and choose to step into the object. For example, when right-clicking on a stored procedure, the context menu includes a menu option titled "Step Into Stored Procedure."
• Application Debugging - with application debugging you can set breakpoints within a database object. When the associated ASP.NET application is debugged and the database object invoked, Visual Studio's debugger pauses the application's execution as the breakpoint it hit, allowing us to step through the object's statements one at a time.
• Debugging from a SQL Server Project - Visual Studio offers a SQL Server Project type. This project can include both T-SQL and managed database objects and these objects can be debugged by debugging the SQL Server Project itself.

• local database
• remove database

• Add breakpoints to the database object(s) that you want to debug. A database object will only be debugged if it contains a breakpoint. For example, you cannot "Step Into" a stored procedure from application code that calls the stored procedure. Rather, you must explicitly set a breakpoint within the stored procedure itself.
• Configure the application to debug SQL Server objects. For 'DataTest NoExcel', Properties, Debug, Enable Debuggers, check box 'Enable SQL Server debugging'; for ASP.NET, Property Pages, Start Options, Debuggers, check ASP.NET and SQL Server.
  
• Update the connection string to disable connection pooling. Connection pooling is a performance enhancement that allows an application to connect to a database from an existing pool of connections. This feature, if enabled, does not correctly construct the debugging infrastructure needed on the connection taken from the pool. Since connection pooling is enabled by default, we must update our connection string to disable connection pooling during the timeframe that application debugging
  is being used. (After you've completed debugging the SQL Server objects via application debugging be sure to reinstate connection pooling.) To accomplish this simply tack on the attribute Pooling=false to you existing connection string

a). temptable in SQL Server

b) SQL Server, Server roles:

dbcreator

processadmin

securityadmin

setupadmin

c) store database connection string encrypted,

d) All input is evil

e) no sa

SELECT-only account for data retrieval