by1455的自留地

输出

bcp "SELECT * FROM 库名.表名" queryout 表名.dat -c -S 服务器名 -T

输入

bcp 库名.表名 in 表名.dat -T -c

在主程序中用以下javascript

 function calcIFrameHeight(id) {
           
          //find the height of the internal page
          var theHeight=
            document.getElementById(id).contentWindow.
              document.body.scrollHeight;
 
          //change the height of the iframe
          document.getElementById(id).height =
              theHeight + 50;
        }

在iframe中用

if (this.frameElement != null) window.parent.calcIFrameHeight(this.frameElement.attributes.id.value);

一直使用以下的SQL

SET NOCOUNT ON

-- Table row counts and sizes.

CREATE TABLE #t

(

    [name] NVARCHAR(128),

    [rows] CHAR(11),

    reserved VARCHAR(18),

    data VARCHAR(18),

    index_size VARCHAR(18),

    unused VARCHAR(18)

)

INSERT #t EXEC sp_msForEachTable 'EXEC sp_spaceused ''?'''

-- Order by size (need to remove the KB sign).

SELECT *

FROM   #t ORDER by cast(SUBSTRING(reserved, 1, LEN(reserved)-2) as Int) desc

DROP TABLE #t

但是今天碰到table名中含有schemas,就看上去怪怪的，

只好改用下面的SQL,还来不及检查发生了什么事，只好头痛医头脚痛医脚

declare @RowCount int, @tablename varchar(100)

declare @Tables table (

PK int IDENTITY(1,1),

tablename varchar(100),

processed bit

INSERT into @Tables (tablename)

SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']' AS TableName

FROM sys.tables order by TABLENAME asc

declare @Space table (

[id] [int] IDENTITY(1,1) NOT NULL,

name varchar(100), rows nvarchar(100), reserved varchar(100), data char(100), index_size varchar(100), unused varchar(100)

select top 1 @tablename = tablename from @Tables where processed is null

SET @RowCount = 1

WHILE (@RowCount <> 0)

print @tablename

insert into @Space exec sp_spaceused @tablename

update @Space set name = @tablename where id = (select top 1 MAX(id) as no from @Space)

update @Tables set processed = 1 where tablename = @tablename

select top 1 @tablename = tablename from @Tables where processed is null

SET @RowCount = @@RowCount

update @Space set data = replace(data, 'KB', '')

update @Space set data = cast(data as decimal(10,0)) / 1000

update @Space set data = cast(data as decimal(10,2))

update @Space set reserved = replace(reserved, 'KB', '')

update @Space set reserved = cast(reserved as decimal(10,0)) / 1000

update @Space set reserved = cast(reserved as decimal(10,2))

select name as Tablename, rows, replace(data,' ','') + 'MB' as used, replace(reserved,' ','') + 'MB' as [Reserved] ,index_size,unused from @Space order by convert(decimal(10,2),data) desc

在iis7,这个东东被和谐了，好在下面的命令行可以完成同样工作

导出Site的配置

 %windir%\system32\inetsrv\AppCmd.exe LIST SITE "Old Site" /config /XML > site.xml

导入Site的配置

%windir%\system32\inetsrv\AppCmd.exe ADD SITE /IN < site.xml

从网上拷贝，方便记忆

Keyboard Shortcuts

1. Alt-Shift-Enter to View Coding Window Full-screen

Hitting "Alt+Shift+Enter" will make the coding window full-screen and (temporarily) drop most other windows from view. Restore to your usual window configuration by de-pressing the "Full Screen" button at top (the fact that it seems to be pushed up a little off-screen must be a VS2010 Beta 2 deal):

2. Alt-F12 to Find Symbol

Use "Alt-F12" to find symbols, objects, or members.

3. Ctrl-F to do a Quick Find

Search for something in the current code file quickly with "Ctrl-f".

4. Ctrl-Shift-F to Find in Files

Find in files is easy with "Ctrl-Shift-f".

5. Ctrl-K-C to Comment/Uncomment Code

You can comment or uncomment code by highlighting the respective code block and hitting "Ctrl-k-c" to comment or "Ctrl-k-u" to uncomment. This shortcut even works in .aspx pages.

6. Ctrl-K-D to Reformat the Entire Document

If you want to reformat all of the code in the current document, hit "Ctrl-k-d".

7. Ctrl-K-F to Reformat a Block of Code

If you've just pasted in a bunch of code where the formatting is screwed-up, just highlight it and hit "Ctrl-k-f" to format.

8. Ctrl-K-L to Toggle Outlining Ctrl-M-M to Toggle Outlining

If you want to open (expand) or close (collapse) all outlining in a code file, use "Ctrl-m-m". It works like a toggle, alternatively expanding or collapsing all outlining in the current file.

9. Ctrl-K-S to Access Code Snippets

Easily open the code snippets selection dropdown with "Ctrl-k-s":

10. Ctrl–K–T to View Call Hierarchy

Highlight a member operation and hit "Ctrl-k-t" to view it's call hierarchy.

A new window will open:

11. Ctrl-L to Cut Line to Clipboard

It's not necessary to highlight an entire line and then hit the delete key. Just hit "Ctrl-L" and the line the cursor is currently on will be removed and copied to the clipboard. "Ctrl-x" performs the same operation by default.

12. Ctrl-F3 to Search Without the Dialog

Just highlight the text you want to search on and hit "Ctrl-F3" to search down or "Ctrl-Shift-F3" to search up.

13. Ctrl-, (Ctrl-Comma) to Perform a Fuzzy 'Navigate To' Search

Perform a "fuzzy" search and get location information with "Ctrl-," (Ctrl-Comma).

14. Ctrl-] to Find Matching Curly Brace or Region

Position the cursor next to a curly brace ('{' or '}') and hit "Ctrl-}'. This will toggle the cursor between the matching braces.

This shortcut will also work for #region...#endregion's.

15. F9 to Add/Remove Breakpoint

'F9' will toggle breakpoints for the current line.

16. F12 to Go to Definition

Put the cursor on an item and hit 'F12'. Instant 'go to definition' functionality.

17. Shift-F5 to Stop Debugging

To stop debugging a project, use "Shift-F5". Much quicker than going through the Debug menu.

18. Shift-F12 to Find Usages

'Shift-F12' will find all usages of the item the cursor is currently on and display the "Find Usages" dialog (this is ReSharper's version of the dialog; standard VS2008 looks a little different):

19. 'prop' to Create New Property

Add a new property in code by typing prop then hitting the Tab key twice. This "prop-TAB-TAB" combination will create a property template that looks like:

1: public int MyProperty { get; set; }

View Plain

Mouse Shortcuts

1. Right-click to add references

Say you've just entered a line of code like the following where the red squiggly indicates you haven't yet added the necessary reference (in VS2010 Beta 2, the red squiggly isn't showing up, but the shortcut still works):

You could jump to the top of the file and type it in manually, or you could right-click on the squiggly-indicated word and choose "Resolve | using …":

This will add the needed reference for you, no typing required.

2. Zoom In/Zoom Out

The same Word functionality of pressing Ctrl and zooming in and out is now in VS2010.

3. Remove unused references

Many times there are references included in the "using…" section that are not needed. Removing the unnecessary ones is easy: Right-click anywhere on the code file, select "Organize Usings | Remove Unused Usings".

4. Sort usings

To sort your "usings…" section, right-click anywhere on the code file and select "Organize Usings | Sort Usings".

5. Open a file's "containing folder"

Right-click on an open file's tab, select "Open Containing Folder".

6. Copy a file's folder location to the clipboard

Right-click on an open file's tab, select "Copy Full Path".

7. Close all files but "this" one

If you have more than one file open, you can right-click on one of the file tabs (the one which you want to stay open) and choose "Close All But This". This will close all other files.

8. Close tab

A quick way of closing a tab is to use the mouse scroll or middle button. Hover the mouse cursor over the tab, click the mouse scroll button, and the file (and it's tab) will close.

9. Highlight References/Usages

Place the cursor on any member and VS2010 will auto-highlight it throughout: