Just another WordPress.com site

Archive for October, 2008

特殊符号大全


♀ ♥ ♡ ☜ ☞ ☎ ☏ ⊙ ◎ ☺ ☻ ► ◄ ♨ ◐ ◑ ↔ ↕ ▪ ▫ ☼ ♦ ▀ ▄ █ ▌ ▐ ░ ▒ ▬ ♦ ◊ ◦ ☼ ♠ ♣
▣ ▤ ▥ ▦ ▩ ◘ ◙ ◈ ♫ ♬ ♪ ♩ ♭ ♪ の ☆→ あ ぃ £ ▧ ▨ ♠ ♣๑•ิ.•ั๑๑۩۞۩๑ ♪ ♬ ⓛⓞⓥⓔ ๑۩ﺴ
♬ ♫ ♪

♯♭ $ ஐﻬ◎ ﻬஐ の ☆→ あ ぃ £ ♥『』Ψ № ∑ ⌒〖〗@ξζ∮ ▓ ∏ 卐【】√ ¤ ╋

☞☜︶ இ ℡.○● 彡 ° ₪ ௫ ★ ☆ ⊙ ☺ ☻ ☼ ♠ ♡ ♣ ♤ ♥ ♦ ♧ ♨ ♩ 〠 〄 ㍿ ♩♪♫♬ 큐 ™

㊣㊚㊛㊙㊝㊊㊋㊌㊍㊎㊏㊐⓪ ①②③④⑤⑥⑦⑧⑨⑩⑪⑫⑬⑭⑮⑯⑰⑱⑲⑳ⓐ ⓑ ⓒ ⓓ ⓔ ⓕ ⓖ ⓗ ⓘ ⓙ ⓚ ⓛ ⓜ ⓝ ⓞ ⓟ ⓠ ⓡⓢ ⓣ ⓤ ⓥ ⓦ ⓧ ⓨ ⓩ ㊀㊁㊂㊃㊄㊅㊆㊇㊈㊉

◊ ◦☼ ▣ ▤ ▥ ❤ 。◕‿◕。♩ ♭ ♪ の▦ ▩ ◘ ◙ ◈ ♫★☆⊕◎Θ﹏﹋﹌【】〖〗※-『』√∴卐 ≈░ ▒ ∵∴§∮♡♪♬๑•ิ.•ั๑♠♣♧✖♂☼▶▷◀◁★☆⊙☺☻☼♠

→ ♧ ぃ £ ๑۩۞۩๑ ✲ ❈ ✿ ✲ ❈ ➹ ~.~ ◕‿-。 ☀☂☁【】┱ ┲ の♈ ➸ ✓ ✔ ✕ ✖ ✟

☜ ☞ ╰☆╮☎ ☏ ⊙ ◎ ☺ ☻ ► ◄ ♨ ◐ ◑ ♦ ♠ ♣ ✣ ✤ ✥ ✦ ✧ ✩ ✫ ✬ ✭ ✮ ✯ ✰ ✱ ✲ ✳ ❃ ❂
❁ ❀ ✿ ✾ ✽ ✼ ✻ ✺ ✸ ✷ ✶ ✵ ✴ ❄ ❅ ❆ ❇ ❈ ❉ ❊ ❋ ❖ (¤^_^¤) べoべ ⊹⊱⋛⋋۰•● ๑۩ﺴ *.:
。❀*゚’゚・✿.。❤ ●•۰. ◕。◕ 。◕‿◕。╰。✎。╮ ✲:‧。o(>""<)o o(‧”’‧)o ♥ ♡ (◡‿◡✿)
(。→‿←。) (≧ε≦o) (≧∇≦) (ㄒoㄒ) o(╥﹏╥)o ⋌⋚⊰⊹ ⓛⓞⓥⓔ

♟ ☼ ☀ o O # 【】ψ ▓ ► ◄ ▒ ░ ♀♂ √ ╮╭ ╯╰ ァ ┱ ┲ ☆ ★ ♫ ♬ ♪♩♭♪ ▶ △ ▲ γ ō 凸
∩∪ ╦ ╩ ⊙ ◎ ▀ ▁ ▂ ▃ ▄ ▅ ▆ ▇ █ ▋▌▍┋ ︻ ︼ ¤ ▽ ㄒ ︶︿ ε >< ┘┌ ∵ ∴ ∷ ︹ ︺ ╬ ╋ ω
㊣ § ■ Θ I し↑↑↓↓← → ↘↙ ↔↕〓 ☆ ★┣┓┏┫×╰ノ◢ ◣ ◥ ◤ Ω ж ф ю Ю ━╃ ╄━ 卍 ┛┗ ┓┏ ◇ ◆
ㄨ⌒ ※ × ◎ ☂ ☜ ☞ ❤ ♡ ♥『』Ψ № ∑ ⌒〖〗@ξζ∮ ▓$ @ * &♦

๑۩๑۩۞۩๑۞۩๑❤ ☄ ✂ ☇ ☈ ⊙ ☊ ☋ ☌☍♞ (◡‿◡✿) εїз © ☸ ☹ ๑•ิ.•ั๑ ♂ ♀ → ╃ ♥ ☑ ☒☢ ☸ ☹ ☺ ☻ΩЖ ۞ ₣₪░▒▓Đ ŧːΦ Ќ

☂ ♨ ☎ ☏ ☆ ★ △ ▲ ♠ ♣ ♧ ♟ ♂ ♀ ♥ ❤ ♡ ♫ ♬ ♪ ♩ ♭ ♪ ☜ ☞ ⊙ ◎ ☺ ☻ ⊕ ¤ ☼ o O
♋ ㊝ ► ◄ ◢ ◣ ◥ ◤ ▽ ▧ ▨ ▣ ▤ ▥ ▦ ▩ ◘ ◙ ▓ ▒ ░ ■ Cafe № @ ㊣ ™ ℡ 凸 ☃ ❣.•● ➸
❝❞ o(‧”’‧)o 。◕‿◕。 べoべ ⊹⊱⋛⋋ ⋌⋚⊰⊹ ◈ ♦ ◊ ◦ ◇ ◆.۰•● ❤ ●•۰.๑۩۞۩๑✿ ﻬஐ╃✖ *°♡﹢
ﺴ ﺴ....ஐ☀ ﻬஐஐ

♡.1 ⊙●○①⊕◎Θ⊙¤㊣★☆♀◆◇◣◢◥▲▼△▽⊿◤ ◥ 

♡.2 ▆ ▇ █ █ ■ ▓ 回 □ 〓≡ ╝╚╔ ╗╬ ═ ╓ ╩ ┠ ┨┯ ┷┏

♡.3 ┓┗ ┛┳⊥﹃﹄┌ ┐└ ┘∟「」↑↓→←↘↙♀♂┇┅ ﹉﹊﹍﹎╭

♡.4 ╮╰ ╯ *^_^* ^*^ ^-^ ^_^ ^︵^ ∵∴∥︱ ︳︴﹏﹋﹌︵︶︹︺

♡.5 【】〖〗@:!/ " _ < > `,.。≈{}~ ~() _ -『』√ $ @ * & # ※

♡.6 卐 々∞Ψ ∪∩∈∏ の ℡ ぁ §∮“”ミ灬ξ№∑⌒ξζω* ㄨ ≮≯ +

♡.7 -×÷﹢﹣±/=∫∮∝ ∞ ∧∨ ∑ ∏ ∥∠ ≌ ∽ ≦ ≧ ≒﹤﹥じ

♡.8 ☆veve↑↓⊙●★☆■♀『』◆◣◥▲Ψ ※◤ ◥ →№←㊣∑⌒〖〗@

♡.9 ξζω□∮〓※∴ぷ▂▃▅▆█ ∏卐【】△√ ∩¤々♀♂∞①ㄨ≡↘↙▂

♡.10 ▂ ▃ ▄ ▅ ▆ ▇ █┗┛╰☆╮ ≠ ▂ ▃ ▄ ▅

♡.1..°∴ ☆...°

♡.2 ♡o(╥﹏╥)o ♥♡ じ☆ve【 오빠 사랑해요 】*° ^_^…….♧♧

♡.3 ┢┦aΡpy ♡^_^♡ ☜♥☞ ☞ ☜ 

♡.4 ︻︼─一 ▄︻┻┳═一 ▄︻┳一 ▄︻┻═┳一 ▄︻┳-一

♡.5 ▄︻┻═┳ ︻┳═一 ▄︻┳一. ▄︻┳═一 ︻┳═一oO

♡.6 -─═┳︻ ∝╬══→ ::======>> ┈━═☆ ┣▇▇▇═─

♡.19 Chris’ Blog™ ♪ ♬ ๑•ิ.•ั๑ ♠ ♣ ✖

♡.20 ♂ ♀ ♥ ♡ ☜ ☞ ☎ ☏ ⊙ ◎ ☺ ☻► ◄ ▧ ▨ ♨ ◐ ◑ ↔ ↕ ▪ ▫

♡.21 ☼ ♦ ▀ ▄ █ ▌ ▐ ░ ▒ ▬ ♦ ◊ ◦ ☼ ♠ ♣ ▣ ▤ ▥

♡.22 ▦ ▩ ◘ ◙ ◈ ♫ ♬ ♪ ♩ ♭ ♪ の ☆→ あ ぃ £ ❤ 。◕‿◕。

♡.ゃōゃ ⊙▂⊙ ⊙0⊙ ⊙︿⊙ ⊙ω⊙ ⊙﹏⊙ ⊙△⊙ ⊙▽⊙

♡.◑▂◐ ◑0◐ ◑︿◐ ◑ω◐ ◑﹏◐ ◑△◐  ◑▽◐

♡.∩▂∩ ∩0∩ ∩︿∩ ∩ω∩ ∩﹏∩ ∩△∩ ∩▽∩

♡.●▂●  ●0●  ●︿●  ●ω●  ●﹏●  ●△●  ●▽●

♡.∪▂∪ ∪0∪ ∪︿∪ ∪ω∪ ∪﹏∪ ∪△∪ ∪▽∪

♡. ≧▂≦ ≧0≦ ≧︿≦ ≧ω≦ ≧﹏≦ ≧△≦ ≧▽≦

♡. >▂< >0< >︿< >ω< >﹏< >△< >▽<

♡. ╯▂╰ ╯0╰ ╯︿╰ ╯ω╰ ╯﹏╰ ╯△╰ ╯▽╰

♡. +▂+ +0+ +︿+ +ω+ +﹏+ +△+ +▽+

♡. ˋ▂ˊ ˋ0ˊ ˋ︿ˊ ˋωˊ ˋ﹏ˊ ˋ△ˊ ˋ▽ˊ

♡. ˇ▂ˇ ˇ0ˇ ˇ︿ˇ ˇωˇ ˇ﹏ˇ  ˇ△ˇ ˇ▽ˇ

♡. ˙▂˙ ˙0˙ ˙︿˙ ˙ω˙ ˙﹏˙ ˙△˙ ˙▽˙

♡. ≡(▔﹏▔)≡ ⊙﹏⊙∥∣° ˋ︿ˊ﹀-# ╯︿╰﹀ (=‵′=)

♡. <(‵^′)>  o(‧""‧)o  (-__-)b \ _ /

♡.  ̄□ ̄||  ——\\(˙<>˙)/——   <("""O""")>

♡. (#‵′)凸  (‵▽′)ψ  (°ο°)~ @  (^人^) (*‧↓˙*)

♡. (O ^ ~ ^ O)  [>\/<] ↓。υ。↓ (;°○° ) ( > c < )

♡. 8 y 1 2 3 4 5 6 7 8 9 与 0-=、`

♡.☀☁☂☃☄❉❊❋❖❤❥❦❧☇☈⊙☊☋☌☍☑☒☢ ☸ ☹ ☺ ☻ ☼ ☽

♡.☾♠♡♢♣♤♥♦♧ ♨ ♩ ✙ ✈ ✉ ✌ ✁ ✎ ✐ ❀ ✰ ❁ ❤ ❥ ❦❧

♡.➳ ➽ 〠 〄 ㍿ ♝ ♞ ➳➴➵㊚㊛㊙℗♯♩♪♫♬♭♮ ☎☏☪♈♨ ºº₪¤큐

♡.« » ™♂✿♥㊣♀♀♂© ® ⁂ ℡ↂ░ ▣ ▤ ▥ ▦ ▧ ▨

♡.▩☯♋♛♞♕✈✎✏┇┅✐✌✍✡✓✔✕✖ ♂ ♀ ♥ ♡

♡.☜ ☞ ☎ ☏ ⊙ ◎ ☺ ☻ ► ◄ ◐ ◑ ↔ ↕☼ ♦♦ ◊ ◘

♡.◙✗✘✚✪✣✤✥✦✧✩✫✬✭✮✯✰

♡.ぁあぃいぅうぇえぉおか がきぎくぐけ

♡.げこごさざしじすずせぜそぞただちぢっつづてでとどなにぬねのはば

♡.ぱひびぴふぶぷへべぺほぼぽまみむめも

(*∩_∩*)′ ❤。❤ ♠♥♣●︶ε︶●♦

=^。^=oοО o(≧﹏≦)o o(‧”’‧)o

♡~⌒ō⌒~ ..°∴ ☆...°♡ ミ●﹏⊙ミ

⊙▂⊙ ⊙0⊙ ⊙︿⊙  ⊙ω⊙   ⊙﹏⊙  ⊙△⊙  ⊙▽⊙

∪▂∪  ∪0∪  ∪︿∪  ∪ω∪  ∪﹏∪  ∪△∪  ∪▽∪

+▂+  +0+  +︿+  +ω+  +﹏+ +△+  +▽+

︽⊙_⊙︽ (⊙_⊙) (@口@) Σ(@)( ̄ ̄)+ Σ(⊙▽⊙")

SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE

SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE

Following three questions are many time asked on this blog.

How to insert data from one table to another table efficiently?
How to insert data from one table using where condition to anther table?
How can I stop using cursor to move data from one table to another table?

There are two different ways to implement inserting data from one
table to another table. I strongly suggest to use either of the method
over cursor. Performance of following two methods is far superior over
cursor. I prefer to use Method 1 always as I works in all the case.

Method 1 : INSERT INTO SELECT
This method is used when table is already created in the database
earlier and data is to be inserted into this table from another table.
If columns listed in insert clause and select clause are same, they are
are not required to list them. I always list them for readability and
scalability purpose.

USE AdventureWorks
GO
    
----Create TestTable
CREATE TABLE TestTable (FirstName VARCHAR(100), LastName VARCHAR(100))
    
----INSERT INTO TestTable using SELECT
INSERT INTO TestTable (FirstNameLastName)
    
SELECT FirstNameLastName
    
FROM Person.Contact
    
WHERE EmailPromotion 2
    
----Verify that Data in TestTable
SELECT FirstNameLastName
    
FROM TestTable
    
----Clean Up Database
DROP TABLE TestTable
GO

Method 2 : SELECT INTO
This method is used when table is not created earlier and needs to be
created when data from one table is to be inserted into newly created
table from another table. New table is created with same data types as
selected columns.

USE AdventureWorks
GO
    
----Create new table and insert into table using SELECT INSERT
SELECT FirstNameLastName
            
INTO TestTable
    
FROM Person.Contact
    
WHERE EmailPromotion 2
    
----Verify that Data in TestTable
SELECT FirstNameLastName
    
FROM TestTable
    
----Clean Up Database
DROP TABLE TestTable
GO

Both of the above method works with database temporary tables
(global, local). If you want to insert multiple rows using only one
insert statement refer article SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL.

Reference : Pinal Dave (http://www.SQLAuthority.com)

Data import / export with SQL Server Express using DTS Wizard

Data import / export with SQL Server Express using DTS Wizard

There are IMHO two major annoyances with SQL Server Express :
 – No Server Agent
 – No Import / Export function (called Data Transformation Services – DTS in SQL Server 2000)
 
Missing the Server Agent means you have to make your own backup (or
other) scheduling, but luckily DTS is possible – it is just not
installed as default with SQL Server Express (SSE). It’s very strange
to me why Microsoft did not just include in the standard install so
that it was available from SQL Server Studio, but I’ll settle for just
being happy that it exists at all!

Check if you already have it by looking for this file: c:\%programfiles%\Microsoft SQL Server\90\DTS\Binn\dtswizard.exe. If you don’t have a ‘DTS’ directory (or even a ‘90′ directory) it has not been installed.

Here is how you get it:
 – It is included in the SQL Server Express Edition Toolkit
– and only that. It you have installed another version of SSE, it works
fine to install this package afterwards without uninstalling the
others. Get it here: http://go.microsoft.com/fwlink/?LinkId=65111
– The DTS Wizard is included in the option “Business Intelligence Development Studio” so be sure to select that for install 
– If you have installed another version of SSE, the installer might report that there is nothing to install. Override this by checking the checkbox that displays the version number (in the installer wizard)

After install has finished, the DTS Wizard is available at
c:\<programfiles>\Microsoft SQL Server\90\DTS\Binn\dtswizard.exe
you might want to make a shortcut, or even include it on the tools menu of SQL Studio.

Tag Cloud