- MS-SQL ±âº» ±Å¸®¹®¹ý

-
1. create table - Å×ÀÌºí »ý¼º
(192,323ȸ)
-
2. SELECT
(69,892ȸ)
-
3. insert into
(69,659ȸ)
-
4. Delete from
(69,564ȸ)
-
5. UPDATE - ÀÚ·á ¼öÁ¤
(70,798ȸ)
-
6. Group by
(69,503ȸ)
-
7. Union All
(69,734ȸ)
-
8. case when ~ end - Á¶°Ç 󸮹®
(69,843ȸ)
-
9. Çʵå¸í Ãâ·Â ¹æ¹ý
(69,774ȸ)
-
10. Not in °ú Not exists
(69,512ȸ)
-
11. replace() , convert()
(69,480ȸ)
-
12. Alter Table
(69,865ȸ)
-
13. °øÅë Å×ÀÌºí ½Ä(Common Table Expressions) °ú Àç±Í Äõ¸®
(69,570ȸ)
-
14. DISTINCT¸¦ ÀÌ¿ëÇÑ Áߺ¹ Á¦°Å
(69,494ȸ)
-
15. ·¹ÄÚµå Merge, ¿©·¯ ·¹ÄÚµå ÇÕÄ¡±â - FOR XML PATH('') , DISTINCT »ç¿ë
(69,675ȸ)
-
16. ´ë¼Ò¹®ÀÚ ±¸ºÐ - Korean_Wansung_CI_AS , Korean_Wansung_CS_AS
(69,807ȸ)
-
17. ±âÁ¸ Ä÷³À» IDENTITY ¼Ó¼ºÀ¸·Î º¯°æÇϱâ
(69,509ȸ)
-
18. DBMSº° µ¥ÀÌŸ ·£´ý ¼¿·ºÆ®Çϱâ (Random Row Select) - NEWID()
(69,334ȸ)
- Query¹® - Join & SubQuery

-
1. INNER JOIN
(75,653ȸ)
-
2. OUTER JOIN
(69,609ȸ)
-
3. Á¶ÀÎÀ» ÀÌ¿ëÇÑ ·©Å·(¼øÀ§) ±¸Çϱâ
(69,501ȸ)
-
4. À¯¿ëÇÑ Äõ¸® ¸ðÀ½.
(70,001ȸ)
-
5. µ¥ÀÌŸ º£À̽º°¡ ´Ù¸¥ Å×À̺í Query ¹æ¹ý
(69,550ȸ)
-
6. ¿©·¯ Å×À̺í Á¶ÀÎ Çϱâ(Multi Join)
(69,584ȸ)
-
7. SubQuery - Insert ¿¹Á¦
(69,545ȸ)
-
8. SubQuery - Select ¿¹Á¦
(69,318ȸ)
-
9. SubQuery - UPDATE ¿¹Á¦
(69,542ȸ)
-
10. SubQuery - Where Àý »ç¿ë ¿¹Á¦
(69,385ȸ)
-
11. SubQuery - Áߺ¹ µ¥ÀÌŸ °Ë»ç ¹× »èÁ¦ ¹æ¹ý
(69,672ȸ)
- ÀúÀå ÇÁ·Î½ÃÁ®

-
1. ÀúÀå ÇÁ·Î½ÃÁ®
(69,415ȸ)
-
2. ÀúÀå ÇÁ·Î½ÃÁ® ¸¸µé±â
(69,614ȸ)
-
3. ÀúÀå ÇÁ·Î½ÃÁ® µ¥ÀÌŸ Ãâ·Â
(70,366ȸ)
-
4. ÀúÀå ÇÁ·Î½ÃÁ® º¯¼ö ¼±¾ð
(69,548ȸ)
-
5. Á¦¾î¹® »ç¿ëÇϱâ
(69,881ȸ)
-
6. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ®
(69,312ȸ)
-
7. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ® - ³»¿ëº¸±â
(69,499ȸ)
-
8. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ® - DB ¶¼°í,ºÙÀ̱â
(69,527ȸ)
-
9. ÀúÀå ÇÁ·Î½ÃÁ® - ¿ø°Ý¼¹ö ¿¬°á (sp_addlinkedserver)
(69,626ȸ)
- ±âŸ À¯¿ëÇÑ Á¤º¸µé

-
1. Query °æ°ú½Ã°£ üũ ¹æ¹ý
(69,224ȸ)
-
2. ƯÁ¤ ÀÛ¾÷(Ãß°¡,»èÁ¦,¹é¾÷ µîµî) À» ¹Ýº¹ÀÛ¾÷À» ¼öÇà½ÃŰÀÚ.
(69,579ȸ)
-
3. ·Î±×ÆÄÀÏÀÌ ³Ê¹« Å©´Ù. ·Î±×ÆÄÀÏÀ» Ãà¼Ò½ÃŰÀÚ.
(69,214ȸ)
-
4. SQL ¼¹öÀÇ µ¥ÀÌÅÍ Å¸ÀÔ
(69,246ȸ)
-
5. MS_SQL Á¢¼Ó Æ÷Æ® º¯°æÇϱâ
(69,429ȸ)
-
6. ¾ÏÈ£È/º¹È£È - EncryptByPassPhrase() / DecryptByPassPhrase()
(69,354ȸ)
-
7. TimeoutÀÌ ¸¸·áµÇ¾ú½À´Ï´Ù. ÀÛ¾÷À» ¿Ï·áÇϱâ Àü ½Ã°£ÀÌ °æ°úµÇ¾ú°Å³ª ÀÀ´äÇÏÁö ¾Ê¾Ò½À´Ï´Ù.
(69,160ȸ)
-
8. MS-SQL ¿¡¼ ¿¬°áµÈ ¼¹ö (Linked Server )¿¡ MY-SQL DataBase ¼¹ö µî·Ï
(69,350ȸ)
-
9. µ¥ÀÌÅͺ£À̽º ¹é¾÷°ú º¹¿ø (BACKUP & RESTORE)
(68,827ȸ)
-
10. MSSQL Å×ÀÌºí µ¥ÀÌÅ͸¦ .sql ½ºÅ©¸³Æ®·Î MySQL·Î °¡Á®¿À±â
(68,923ȸ)
-
11. DB(µ¥ÀÌÅͺ£À̽º)¸¦ »ç¿ëÁßÀ̶ó »èÁ¦ÇÒ ¼ö ¾øÀ»¶§ Á¶Ä¡¹æ¹ý
(68,392ȸ)
-
12. datetime °ú smalldatetimeÀÇ Â÷ÀÌ
(66,453ȸ)
- MS SQL - SYSTEM VIEW

-
1. MS SQL View - ½Ã½ºÅÛ ºä
(72,096ȸ)
-
2. dm_exec_connections - ·Î±×ÀÎÁ¤º¸, Á¢¼ÓIP, Á¢¼Ó½Ã°£ ¾Ë¾Æº¸±â
(69,215ȸ)
-
3. INFORMATION_SCHEMA.COLUMNS , columns - Å×À̺íÀÇ Çʵå Á¤º¸¸¦ »Ì¾Æº¸ÀÚ
(69,191ȸ)
-
4. objects , tables - Å×À̺í Á¤º¸¸¦ »Ì¾Æº¸ÀÚ
(69,072ȸ)
-
5. objects , sysindexes - Å×ÀÌºí ·¹ÄÚµå COUNT ¸¦ »Ì¾Æº¸ÀÚ
(69,202ȸ)
-
6. databases - DB¸ñ·ÏÀ» »Ì¾Æº¸ÀÚ
(69,714ȸ)
-
7. sys.sysaltfiles - DB DATA¿ë·®°ú LOG ÆÄÀÏ ¿ë·®À» È®ÀÎÇØ º¸ÀÚ.
(69,070ȸ)
-
8. dm_exec_query_stats , dm_exec_sql_text - CPU »ç¿ë·®ÀÌ ¸¹Àº Äõ¸®¹®À» ã¾Æ¶ó.
(108,922ȸ)
À̸ÞÀÏ ¹®ÀÇ : cak0280@nate.com
Copyright 2000 By ENTERSOFT.KR All Rights Reserved.
|
|