[edit]
1 SQL References #
- Unix Timestamp
- MySQL Linked Server 覯蠏
- T-SQL 襴
- LCS
- 覈 企 一危 觸蠍
- openrowset
- utf8 to unicode
- url encoding
- 貊 ろ 覲蟆
- isnull 譯殊
![[https]](/moniwiki/imgs/https.png)
Transitive closure clustering with CLR and JSON(https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/12/20/transitive-closure-clustering-with-clr-and-json/)
- Script Backup
- Reading and Writing Files in SQL Server using T-SQL(https://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/)
- Introduction to SQL Server Spatial Data(https://www.simple-talk.com/sql/t-sql-programming/introduction-to-sql-server-spatial-data/)
- SQL Server PowerShell Tips(https://www.mssqltips.com/sql-server-tip-category/81/powershell/)
- Math expression
- Tempdb and transaction log IO latencies
- OpenQuery襷り鍵
- UnixODBC誤
- 豢襷 sql jitter
- SQL Server HTTP Call蠍
- datetime to UTC(https://www.jitbit.com/maxblog/17-sql-server-how-to-convert-datetime-to-utc/)
![[http]](/moniwiki/imgs/http.png)
JSON Select - Easily query values from JSON(http://www.sqlservercentral.com/articles/JSON/128550/)
- 企殊伎誤 覲豺 覦煙-讌ろ碁Μ
- 朱 覦 レ 觸願鍵
- SQL Stored Procedure to Convert SQL Table Into HTML (v1.0)(http://www.symantec.com/connect/downloads/sql-stored-procedure-convert-sql-table-html-v10)
- Geek City: Accessing Distribution Statistics(http://sqlblog.com/blogs/kalen_delaney/archive/2013/01/18/accessing-distribution-statistics.aspx)
- RegEx for DBAs(http://www.sqlservercentral.com/articles/RegEx/88586/)
- Standardization with PBM(Policy Based Management)(http://www.sqlservercentral.com/articles/Policy+Based+Management+(PBM)/88486/)
- SQL Server 2012: RML, XEvent Viewer and Distributed Replay(http://blogs.msdn.com/b/psssql/archive/2012/04/06/sql-server-2012-rml-xevent-viewer-and-distributed-replay.aspx)
- 語 企覈 襴ろ
- Parsing HTML to SQL using SQLDOM(http://www.sqlservercentral.com/articles/HTML/88605/)
SQLDOM_core_923.sql
- Generating Charts and Drawings in SQL Server Management Studio(http://www.sqlmag.com/article/sql-server-management-studio-ssms/generating-charts-drawings-sql-server-management-studio-141994?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+windowsitpro%2FPtva+%28SQL%3EArticles%3ETop+Stories%29) 141994.zip
- Column Headers To Row Headers(http://www.sqlservercentral.com/scripts/Coalese/72471/)
- Disk Capacities(http://www.sqlservercentral.com/scripts/DISK/72323/)
- Retrieve Database Object permission scripts and Role members scripts(http://www.sqlservercentral.com/scripts/Permissions/72199/)
- SQL SERVER 2008 Data Dictionary(http://www.sqlservercentral.com/scripts/Data+Dictionary/72048/)
- A simple math expression solver(http://www.sqlservercentral.com/articles/Recursive+function/76077/)
- 企 螳 蠍磯蓋 糾
- isnumeric
- 蟯螻 螻 truncate
- 糾覲 螳煙
- 螳譬 讌螻
- 企
- 貎朱Μ螳 る 朱 蟾
- SQL Azure
- AD螻譟壱
- 3襴襷 貊る谿蠍
- 碁煙 企 碁煙 襷 貎朱Μ襷り鍵
- 螳豌伎 覃覈襴 覦 ろ 覈磯
- 螳 襦 螳 豺一
- SQL Server 2008 R2 螳蟆 覦
- 貎朱Μ 蟆郁骸襯 html襦 襷り鍵
- Partition Switch
- 襴 vs 觜
- 企 碁煙 覦 一 覲企慨蠍
- 蠏貎朱Μ襯 伎 Dumy企 襷り鍵
- 讌り骸 ろ(http://www.sqlskills.com/blogs/paul/CommonSQLServerMyths.pdf) CommonSQLServerMyths.pdf
- ろ 蟲
- Bulk Insert
- How to centralize your SQL Server Event Logs(http://www.sqlservercentral.com/articles/Monitoring/71390/)
- SQL Server CRUD-Generation from System Views(http://www.simple-talk.com/sql/t-sql-programming/sql-server-crud-generation-from-system-views/)
- Using CLR integration to compress BLOBs/CLOBs in SQL Server 2005(http://www.codeproject.com/KB/database/blob_compress.aspx)
- MSDN 殊企襴(http://msdn.microsoft.com/ko-kr/library/)
- 蠍一覲
- Trace Flags
- CPU覲 企 cscript
- VBS for WMI(http://www.geocities.jp/maru3128/wmi.html)
- WMI Class(http://msdn.microsoft.com/en-us/library/aa394173(VS.85).aspx)
- Hierarchical Data Structure Transformation in SQL(http://www.databasejournal.com/features/article.php/3898591/article.htm)
- SQL Server Cursor Workbench(http://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-cursor-workbench/?utm_source=simpletalk&utm_medium=email-main&utm_content=Workbench-20100920&utm_campaign=SQL)
- URL Encoding
- 2讌 覲螻 蠏貎朱Μ
- SQL Server Browser Service
- 讌 一危一 BETWEEN
- 譯朱朱7覯讌 襴襦 磯濠規蠍
- YYYYMMDDHHMISS_TO_DATETIME
- YYYYMMDD襦 襷 蟲蠍
- 蠏碁９
- TCP Port 願鍵
- SQL Server 襷り覲
- DB豌伎 貊 一危 谿剰鍵
- Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs(http://www.sqlservercentral.com/articles/Crosstab/65048/)
- Using tables as Queues(http://rusanu.com/2010/03/26/using-tables-as-queues/)
- 譬 覯襦 企 覲企 覦覯
- Exploring your database schema with SQL(http://www.simple-talk.com/sql/t-sql-programming/exploring-your-database-schema-with-sql/)
- open transactions with text and plans
- 觜襷 谿螳 覦 豢 覦覯
- 貎朱Μ 一危 覦 覯企 覦覯
- 讌螳 企 襷讌襷 讌語 蠍
- 譴覲 一危 蠍
- 觜語一
- 伎 覦覯1
- 螻豸牛 蟆
- れ豢
- Output
- 語螻炎啓 蟲蠍
- 一危磯伎れ 覈 企 蠍
- 旧 磯ジ 覦煙 焔 ろ
- OpenRowSet-Bulk
- DBCC 覈豪
- ANSI-SQL99
- Script to Export Permissions
- 伎 覲旧
- レ
- 碁 襦蠏語 DROP 企 谿城 覦覯
- 企殊伎誤IP(Client IP) 蠍磯 覦覯
- ろ
- °り規襴
- OpenQuery
- 覯蠏 谿場覲願鍵(http://bug.gd/)
- Upload new Attachment "checksum_io.docx"
- SP覿ろ ろ襴渚 襷り鍵
- 螻磯 貉 襷り鍵
- 谿語＾ 谿語＾麹 企 願鍵
- DB Identity螳 願鍵
- 譟壱蟆郁骸 ろ蠍
- 譯殊姶 蟲蠍
- 覈 企 TableDiff 覈轟 襷り鍵
- SSMS 焔伎 磯 SP
- 貉れ 襴
- ろる 螳 覲伎 螳豌 企蠍
- T-SQL Trace
- 襦蠏語//ろる/蟠
- DateDiff 蟲
- ろ襴渚碁 れ蠍
- Plan Guide
- SP 襴
- CRUD 貊襷り鍵
- SP ろ
- Code 一危 讌
- 貎朱Μ 蟆郁骸襯 朱 覦る 覦覯
- SQL2005 覯 れ
- Create Snapshot
- mssqlsystemresource 一危磯伎 伎 誤蠍
- Partitioned Table Info
- DDL Trigger
- Batch Window
- るジ DB 企 Synonym 襷り鍵
- DB 覈 SP 貉危狩蠍
- Binary(HEX) 豌企ゼ 覓語企 願鍵
- 襦 覦 轟 覓語 谿剰鍵
- TempDB 蠍郁鍵
- IP蟯
- 碁煙 覲 讌
- 碁煙 讌覲伎( or 譟郁覈)
- OpenDataSource
- 企 覦 貉 る (ロ襦)
- fn_hexstrTovarbin
- 語 SQL覓 覲願鍵
- 一危磯伎 覃 覲企願鍵
- SP 襷り覲 一危 願鍵
- SQL Server 2008 New features
- Upload new Attachment "DBPricing_kr.docx"
- ろ語 殊企 れ
- 碁煙 (2000覯)
- Upload new Attachment "SQL2008_vs_Oracle11g_KO_(2).docx"
- Job Script
- 企 覯襷 所鍵1
- 觜 SQL Server DB Library襯 覦壱 覦覯
- 0朱 蠍 る 覓伎 覦覯
- SQL Server 2008R2 Edition
- Using Certificates to Sign Stored Procedures(http://www.sqlservercentral.com/articles/Certificates/70170/)
- SQL Server 碁 DLL 蠍磯 COM 螳豌 (http://support.microsoft.com/kb/162361/ko)
- Dinamic Pivot
- 襷れ 豐覿 手讌 一危磯ゼ 豌襴る
- 覦一
- ろ蟇
- SQL Server 2012 Diagnostic Information Queries