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

-
1. create table - Å×ÀÌºí »ý¼º
(198,909ȸ)
-
2. SELECT
(72,243ȸ)
-
3. insert into
(72,009ȸ)
-
4. Delete from
(71,915ȸ)
-
5. UPDATE - ÀÚ·á ¼öÁ¤
(73,149ȸ)
-
6. Group by
(71,853ȸ)
-
7. Union All
(72,084ȸ)
-
8. case when ~ end - Á¶°Ç 󸮹®
(72,195ȸ)
-
9. Çʵå¸í Ãâ·Â ¹æ¹ý
(72,125ȸ)
-
10. Not in °ú Not exists
(71,863ȸ)
-
11. replace() , convert()
(71,830ȸ)
-
12. Alter Table
(72,217ȸ)
-
13. °øÅë Å×ÀÌºí ½Ä(Common Table Expressions) °ú Àç±Í Äõ¸®
(71,920ȸ)
-
14. DISTINCT¸¦ ÀÌ¿ëÇÑ Áߺ¹ Á¦°Å
(71,843ȸ)
-
15. ·¹ÄÚµå Merge, ¿©·¯ ·¹ÄÚµå ÇÕÄ¡±â - FOR XML PATH('') , DISTINCT »ç¿ë
(72,023ȸ)
-
16. ´ë¼Ò¹®ÀÚ ±¸ºÐ - Korean_Wansung_CI_AS , Korean_Wansung_CS_AS
(72,156ȸ)
-
17. ±âÁ¸ Ä÷³À» IDENTITY ¼Ó¼ºÀ¸·Î º¯°æÇϱâ
(71,861ȸ)
-
18. DBMSº° µ¥ÀÌŸ ·£´ý ¼¿·ºÆ®Çϱâ (Random Row Select) - NEWID()
(71,686ȸ)
- Query¹® - Join & SubQuery

-
1. INNER JOIN
(78,541ȸ)
-
2. OUTER JOIN
(71,960ȸ)
-
3. Á¶ÀÎÀ» ÀÌ¿ëÇÑ ·©Å·(¼øÀ§) ±¸Çϱâ
(71,849ȸ)
-
4. À¯¿ëÇÑ Äõ¸® ¸ðÀ½.
(72,349ȸ)
-
5. µ¥ÀÌŸ º£À̽º°¡ ´Ù¸¥ Å×À̺í Query ¹æ¹ý
(71,898ȸ)
-
6. ¿©·¯ Å×À̺í Á¶ÀÎ Çϱâ(Multi Join)
(71,933ȸ)
-
7. SubQuery - Insert ¿¹Á¦
(71,892ȸ)
-
8. SubQuery - Select ¿¹Á¦
(71,666ȸ)
-
9. SubQuery - UPDATE ¿¹Á¦
(71,890ȸ)
-
10. SubQuery - Where Àý »ç¿ë ¿¹Á¦
(71,734ȸ)
-
11. SubQuery - Áߺ¹ µ¥ÀÌŸ °Ë»ç ¹× »èÁ¦ ¹æ¹ý
(72,020ȸ)
- ÀúÀå ÇÁ·Î½ÃÁ®

-
1. ÀúÀå ÇÁ·Î½ÃÁ®
(71,764ȸ)
-
2. ÀúÀå ÇÁ·Î½ÃÁ® ¸¸µé±â
(71,962ȸ)
-
3. ÀúÀå ÇÁ·Î½ÃÁ® µ¥ÀÌŸ Ãâ·Â
(72,716ȸ)
-
4. ÀúÀå ÇÁ·Î½ÃÁ® º¯¼ö ¼±¾ð
(71,895ȸ)
-
5. Á¦¾î¹® »ç¿ëÇϱâ
(72,234ȸ)
-
6. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ®
(71,660ȸ)
-
7. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ® - ³»¿ëº¸±â
(71,846ȸ)
-
8. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ® - DB ¶¼°í,ºÙÀ̱â
(71,872ȸ)
-
9. ÀúÀå ÇÁ·Î½ÃÁ® - ¿ø°Ý¼¹ö ¿¬°á (sp_addlinkedserver)
(71,971ȸ)
- ±âŸ À¯¿ëÇÑ Á¤º¸µé

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

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