- MS-SQL ±âº» ±Å¸®¹®¹ý
-
1. create table - Å×ÀÌºí »ý¼º
(140,689ȸ)
-
2. SELECT
(51,477ȸ)
-
3. insert into
(51,253ȸ)
-
4. Delete from
(51,163ȸ)
-
5. UPDATE - ÀÚ·á ¼öÁ¤
(52,366ȸ)
-
6. Group by
(51,098ȸ)
-
7. Union All
(51,324ȸ)
-
8. case when ~ end - Á¶°Ç 󸮹®
(51,393ȸ)
-
9. Çʵå¸í Ãâ·Â ¹æ¹ý
(51,361ȸ)
-
10. Not in °ú Not exists
(51,106ȸ)
-
11. replace() , convert()
(51,077ȸ)
-
12. Alter Table
(51,450ȸ)
-
13. °øÅë Å×ÀÌºí ½Ä(Common Table Expressions) °ú Àç±Í Äõ¸®
(51,157ȸ)
-
14. DISTINCT¸¦ ÀÌ¿ëÇÑ Áߺ¹ Á¦°Å
(51,091ȸ)
-
15. ·¹ÄÚµå Merge, ¿©·¯ ·¹ÄÚµå ÇÕÄ¡±â - FOR XML PATH('') , DISTINCT »ç¿ë
(51,268ȸ)
-
16. ´ë¼Ò¹®ÀÚ ±¸ºÐ - Korean_Wansung_CI_AS , Korean_Wansung_CS_AS
(51,403ȸ)
-
17. ±âÁ¸ Ä÷³À» IDENTITY ¼Ó¼ºÀ¸·Î º¯°æÇϱâ
(51,095ȸ)
-
18. DBMSº° µ¥ÀÌŸ ·£´ý ¼¿·ºÆ®Çϱâ (Random Row Select) - NEWID()
(50,930ȸ)
- Query¹® - Join & SubQuery
-
1. INNER JOIN
(51,295ȸ)
-
2. OUTER JOIN
(51,195ȸ)
-
3. Á¶ÀÎÀ» ÀÌ¿ëÇÑ ·©Å·(¼øÀ§) ±¸Çϱâ
(51,099ȸ)
-
4. À¯¿ëÇÑ Äõ¸® ¸ðÀ½.
(51,570ȸ)
-
5. µ¥ÀÌŸ º£À̽º°¡ ´Ù¸¥ Å×À̺í Query ¹æ¹ý
(51,155ȸ)
-
6. ¿©·¯ Å×À̺í Á¶ÀÎ Çϱâ(Multi Join)
(51,179ȸ)
-
7. SubQuery - Insert ¿¹Á¦
(51,150ȸ)
-
8. SubQuery - Select ¿¹Á¦
(50,924ȸ)
-
9. SubQuery - UPDATE ¿¹Á¦
(51,151ȸ)
-
10. SubQuery - Where Àý »ç¿ë ¿¹Á¦
(50,997ȸ)
-
11. SubQuery - Áߺ¹ µ¥ÀÌŸ °Ë»ç ¹× »èÁ¦ ¹æ¹ý
(51,263ȸ)
- ÀúÀå ÇÁ·Î½ÃÁ®
-
1. ÀúÀå ÇÁ·Î½ÃÁ®
(51,001ȸ)
-
2. ÀúÀå ÇÁ·Î½ÃÁ® ¸¸µé±â
(51,223ȸ)
-
3. ÀúÀå ÇÁ·Î½ÃÁ® µ¥ÀÌŸ Ãâ·Â
(51,968ȸ)
-
4. ÀúÀå ÇÁ·Î½ÃÁ® º¯¼ö ¼±¾ð
(51,164ȸ)
-
5. Á¦¾î¹® »ç¿ëÇϱâ
(51,488ȸ)
-
6. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ®
(50,931ȸ)
-
7. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ® - ³»¿ëº¸±â
(51,114ȸ)
-
8. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ® - DB ¶¼°í,ºÙÀ̱â
(51,136ȸ)
-
9. ÀúÀå ÇÁ·Î½ÃÁ® - ¿ø°Ý¼¹ö ¿¬°á (sp_addlinkedserver)
(51,173ȸ)
- ±âŸ À¯¿ëÇÑ Á¤º¸µé
-
1. Query °æ°ú½Ã°£ üũ ¹æ¹ý
(50,865ȸ)
-
2. ƯÁ¤ ÀÛ¾÷(Ãß°¡,»èÁ¦,¹é¾÷ µîµî) À» ¹Ýº¹ÀÛ¾÷À» ¼öÇà½ÃÅ°ÀÚ.
(51,202ȸ)
-
3. ·Î±×ÆÄÀÏÀÌ ³Ê¹« Å©´Ù. ·Î±×ÆÄÀÏÀ» Ãà¼Ò½ÃÅ°ÀÚ.
(50,861ȸ)
-
4. SQL ¼¹öÀÇ µ¥ÀÌÅÍ Å¸ÀÔ
(50,894ȸ)
-
5. MS_SQL Á¢¼Ó Æ÷Æ® º¯°æÇϱâ
(51,058ȸ)
-
6. ¾ÏÈ£È/º¹È£È - EncryptByPassPhrase() / DecryptByPassPhrase()
(51,000ȸ)
-
7. TimeoutÀÌ ¸¸·áµÇ¾ú½À´Ï´Ù. ÀÛ¾÷À» ¿Ï·áÇϱâ Àü ½Ã°£ÀÌ °æ°úµÇ¾ú°Å³ª ÀÀ´äÇÏÁö ¾Ê¾Ò½À´Ï´Ù.
(50,815ȸ)
-
8. MS-SQL ¿¡¼ ¿¬°áµÈ ¼¹ö (Linked Server )¿¡ MY-SQL DataBase ¼¹ö µî·Ï
(50,998ȸ)
-
9. µ¥ÀÌÅͺ£À̽º ¹é¾÷°ú º¹¿ø (BACKUP & RESTORE)
(50,473ȸ)
-
10. MSSQL Å×ÀÌºí µ¥ÀÌÅ͸¦ .sql ½ºÅ©¸³Æ®·Î MySQL·Î °¡Á®¿À±â
(50,508ȸ)
-
11. DB(µ¥ÀÌÅͺ£À̽º)¸¦ »ç¿ëÁßÀ̶ó »èÁ¦ÇÒ ¼ö ¾øÀ»¶§ Á¶Ä¡¹æ¹ý
(50,059ȸ)
-
12. datetime °ú smalldatetimeÀÇ Â÷ÀÌ
(48,115ȸ)
- MS SQL - SYSTEM VIEW
-
1. MS SQL View - ½Ã½ºÅÛ ºä
(53,739ȸ)
-
2. dm_exec_connections - ·Î±×ÀÎÁ¤º¸, Á¢¼ÓIP, Á¢¼Ó½Ã°£ ¾Ë¾Æº¸±â
(50,880ȸ)
-
3. INFORMATION_SCHEMA.COLUMNS , columns - Å×À̺íÀÇ Çʵå Á¤º¸¸¦ »Ì¾Æº¸ÀÚ
(50,858ȸ)
-
4. objects , tables - Å×À̺í Á¤º¸¸¦ »Ì¾Æº¸ÀÚ
(50,741ȸ)
-
5. objects , sysindexes - Å×ÀÌºí ·¹ÄÚµå COUNT ¸¦ »Ì¾Æº¸ÀÚ
(50,873ȸ)
-
6. databases - DB¸ñ·ÏÀ» »Ì¾Æº¸ÀÚ
(51,347ȸ)
-
7. sys.sysaltfiles - DB DATA¿ë·®°ú LOG ÆÄÀÏ ¿ë·®À» È®ÀÎÇØ º¸ÀÚ.
(50,741ȸ)
-
8. dm_exec_query_stats , dm_exec_sql_text - CPU »ç¿ë·®ÀÌ ¸¹Àº Äõ¸®¹®À» ã¾Æ¶ó.
(89,759ȸ)
À̸ÞÀÏ ¹®ÀÇ : cak0280@nate.com
Copyright 2000 By ENTERSOFT.KR All Rights Reserved.
|
|