- MS-SQL ±âº» ±Å¸®¹®¹ý
-
1. create table - Å×ÀÌºí »ý¼º
(88,850ȸ)
-
2. SELECT
(32,754ȸ)
-
3. insert into
(32,546ȸ)
-
4. Delete from
(32,484ȸ)
-
5. UPDATE - ÀÚ·á ¼öÁ¤
(33,635ȸ)
-
6. Group by
(32,420ȸ)
-
7. Union All
(32,627ȸ)
-
8. case when ~ end - Á¶°Ç 󸮹®
(32,656ȸ)
-
9. Çʵå¸í Ãâ·Â ¹æ¹ý
(32,677ȸ)
-
10. Not in °ú Not exists
(32,414ȸ)
-
11. replace() , convert()
(32,399ȸ)
-
12. Alter Table
(32,767ȸ)
-
13. °øÅë Å×ÀÌºí ½Ä(Common Table Expressions) °ú Àç±Í Äõ¸®
(32,480ȸ)
-
14. DISTINCT¸¦ ÀÌ¿ëÇÑ Áߺ¹ Á¦°Å
(32,408ȸ)
-
15. ·¹ÄÚµå Merge, ¿©·¯ ·¹ÄÚµå ÇÕÄ¡±â - FOR XML PATH('') , DISTINCT »ç¿ë
(32,580ȸ)
-
16. ´ë¼Ò¹®ÀÚ ±¸ºÐ - Korean_Wansung_CI_AS , Korean_Wansung_CS_AS
(32,727ȸ)
-
17. ±âÁ¸ Ä÷³À» IDENTITY ¼Ó¼ºÀ¸·Î º¯°æÇϱâ
(32,403ȸ)
-
18. DBMSº° µ¥ÀÌŸ ·£´ý ¼¿·ºÆ®Çϱâ (Random Row Select) - NEWID()
(32,222ȸ)
- Query¹® - Join & SubQuery
-
1. INNER JOIN
(32,628ȸ)
-
2. OUTER JOIN
(32,512ȸ)
-
3. Á¶ÀÎÀ» ÀÌ¿ëÇÑ ·©Å·(¼øÀ§) ±¸Çϱâ
(32,426ȸ)
-
4. À¯¿ëÇÑ Äõ¸® ¸ðÀ½.
(32,885ȸ)
-
5. µ¥ÀÌŸ º£À̽º°¡ ´Ù¸¥ Å×À̺í Query ¹æ¹ý
(32,498ȸ)
-
6. ¿©·¯ Å×À̺í Á¶ÀÎ Çϱâ(Multi Join)
(32,519ȸ)
-
7. SubQuery - Insert ¿¹Á¦
(32,487ȸ)
-
8. SubQuery - Select ¿¹Á¦
(32,269ȸ)
-
9. SubQuery - UPDATE ¿¹Á¦
(32,491ȸ)
-
10. SubQuery - Where Àý »ç¿ë ¿¹Á¦
(32,334ȸ)
-
11. SubQuery - Áߺ¹ µ¥ÀÌŸ °Ë»ç ¹× »èÁ¦ ¹æ¹ý
(32,581ȸ)
- ÀúÀå ÇÁ·Î½ÃÁ®
-
1. ÀúÀå ÇÁ·Î½ÃÁ®
(32,335ȸ)
-
2. ÀúÀå ÇÁ·Î½ÃÁ® ¸¸µé±â
(32,528ȸ)
-
3. ÀúÀå ÇÁ·Î½ÃÁ® µ¥ÀÌŸ Ãâ·Â
(33,258ȸ)
-
4. ÀúÀå ÇÁ·Î½ÃÁ® º¯¼ö ¼±¾ð
(32,511ȸ)
-
5. Á¦¾î¹® »ç¿ëÇϱâ
(32,811ȸ)
-
6. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ®
(32,265ȸ)
-
7. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ® - ³»¿ëº¸±â
(32,453ȸ)
-
8. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ® - DB ¶¼°í,ºÙÀ̱â
(32,479ȸ)
-
9. ÀúÀå ÇÁ·Î½ÃÁ® - ¿ø°Ý¼¹ö ¿¬°á (sp_addlinkedserver)
(32,516ȸ)
- ±âŸ À¯¿ëÇÑ Á¤º¸µé
-
1. Query °æ°ú½Ã°£ üũ ¹æ¹ý
(32,231ȸ)
-
2. ƯÁ¤ ÀÛ¾÷(Ãß°¡,»èÁ¦,¹é¾÷ µîµî) À» ¹Ýº¹ÀÛ¾÷À» ¼öÇà½ÃÅ°ÀÚ.
(32,574ȸ)
-
3. ·Î±×ÆÄÀÏÀÌ ³Ê¹« Å©´Ù. ·Î±×ÆÄÀÏÀ» Ãà¼Ò½ÃÅ°ÀÚ.
(32,242ȸ)
-
4. SQL ¼¹öÀÇ µ¥ÀÌÅÍ Å¸ÀÔ
(32,277ȸ)
-
5. MS_SQL Á¢¼Ó Æ÷Æ® º¯°æÇϱâ
(32,421ȸ)
-
6. ¾ÏÈ£È/º¹È£È - EncryptByPassPhrase() / DecryptByPassPhrase()
(32,372ȸ)
-
7. TimeoutÀÌ ¸¸·áµÇ¾ú½À´Ï´Ù. ÀÛ¾÷À» ¿Ï·áÇϱâ Àü ½Ã°£ÀÌ °æ°úµÇ¾ú°Å³ª ÀÀ´äÇÏÁö ¾Ê¾Ò½À´Ï´Ù.
(32,205ȸ)
-
8. MS-SQL ¿¡¼ ¿¬°áµÈ ¼¹ö (Linked Server )¿¡ MY-SQL DataBase ¼¹ö µî·Ï
(32,359ȸ)
-
9. µ¥ÀÌÅͺ£À̽º ¹é¾÷°ú º¹¿ø (BACKUP & RESTORE)
(31,868ȸ)
-
10. MSSQL Å×ÀÌºí µ¥ÀÌÅ͸¦ .sql ½ºÅ©¸³Æ®·Î MySQL·Î °¡Á®¿À±â
(31,685ȸ)
-
11. DB(µ¥ÀÌÅͺ£À̽º)¸¦ »ç¿ëÁßÀ̶ó »èÁ¦ÇÒ ¼ö ¾øÀ»¶§ Á¶Ä¡¹æ¹ý
(31,466ȸ)
-
12. datetime °ú smalldatetimeÀÇ Â÷ÀÌ
(29,523ȸ)
- MS SQL - SYSTEM VIEW
-
1. MS SQL View - ½Ã½ºÅÛ ºä
(35,121ȸ)
-
2. dm_exec_connections - ·Î±×ÀÎÁ¤º¸, Á¢¼ÓIP, Á¢¼Ó½Ã°£ ¾Ë¾Æº¸±â
(32,291ȸ)
-
3. INFORMATION_SCHEMA.COLUMNS , columns - Å×À̺íÀÇ Çʵå Á¤º¸¸¦ »Ì¾Æº¸ÀÚ
(32,270ȸ)
-
4. objects , tables - Å×À̺í Á¤º¸¸¦ »Ì¾Æº¸ÀÚ
(32,160ȸ)
-
5. objects , sysindexes - Å×ÀÌºí ·¹ÄÚµå COUNT ¸¦ »Ì¾Æº¸ÀÚ
(32,288ȸ)
-
6. databases - DB¸ñ·ÏÀ» »Ì¾Æº¸ÀÚ
(32,676ȸ)
-
7. sys.sysaltfiles - DB DATA¿ë·®°ú LOG ÆÄÀÏ ¿ë·®À» È®ÀÎÇØ º¸ÀÚ.
(32,139ȸ)
-
8. dm_exec_query_stats , dm_exec_sql_text - CPU »ç¿ë·®ÀÌ ¸¹Àº Äõ¸®¹®À» ã¾Æ¶ó.
(70,750ȸ)
À̸ÞÀÏ ¹®ÀÇ : cak0280@nate.com
Copyright 2000 By ENTERSOFT.KR All Rights Reserved.
|
|