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

-
1. create table - Å×ÀÌºí »ý¼º
(213,051ȸ)
-
2. SELECT
(77,294ȸ)
-
3. insert into
(77,042ȸ)
-
4. Delete from
(76,948ȸ)
-
5. UPDATE - ÀÚ·á ¼öÁ¤
(78,186ȸ)
-
6. Group by
(76,886ȸ)
-
7. Union All
(77,120ȸ)
-
8. case when ~ end - Á¶°Ç 󸮹®
(77,229ȸ)
-
9. Çʵå¸í Ãâ·Â ¹æ¹ý
(77,158ȸ)
-
10. Not in °ú Not exists
(76,898ȸ)
-
11. replace() , convert()
(76,864ȸ)
-
12. Alter Table
(77,254ȸ)
-
13. °øÅë Å×ÀÌºí ½Ä(Common Table Expressions) °ú Àç±Í Äõ¸®
(76,952ȸ)
-
14. DISTINCT¸¦ ÀÌ¿ëÇÑ Áߺ¹ Á¦°Å
(76,875ȸ)
-
15. ·¹ÄÚµå Merge, ¿©·¯ ·¹ÄÚµå ÇÕÄ¡±â - FOR XML PATH('') , DISTINCT »ç¿ë
(77,057ȸ)
-
16. ´ë¼Ò¹®ÀÚ ±¸ºÐ - Korean_Wansung_CI_AS , Korean_Wansung_CS_AS
(77,187ȸ)
-
17. ±âÁ¸ Ä÷³À» IDENTITY ¼Ó¼ºÀ¸·Î º¯°æÇϱâ
(76,893ȸ)
-
18. DBMSº° µ¥ÀÌŸ ·£´ý ¼¿·ºÆ®Çϱâ (Random Row Select) - NEWID()
(76,739ȸ)
- Query¹® - Join & SubQuery

-
1. INNER JOIN
(84,995ȸ)
-
2. OUTER JOIN
(76,990ȸ)
-
3. Á¶ÀÎÀ» ÀÌ¿ëÇÑ ·©Å·(¼øÀ§) ±¸Çϱâ
(76,878ȸ)
-
4. À¯¿ëÇÑ Äõ¸® ¸ðÀ½.
(77,386ȸ)
-
5. µ¥ÀÌŸ º£À̽º°¡ ´Ù¸¥ Å×À̺í Query ¹æ¹ý
(76,928ȸ)
-
6. ¿©·¯ Å×À̺í Á¶ÀÎ Çϱâ(Multi Join)
(76,961ȸ)
-
7. SubQuery - Insert ¿¹Á¦
(76,921ȸ)
-
8. SubQuery - Select ¿¹Á¦
(76,693ȸ)
-
9. SubQuery - UPDATE ¿¹Á¦
(76,918ȸ)
-
10. SubQuery - Where Àý »ç¿ë ¿¹Á¦
(76,761ȸ)
-
11. SubQuery - Áߺ¹ µ¥ÀÌŸ °Ë»ç ¹× »èÁ¦ ¹æ¹ý
(77,048ȸ)
- ÀúÀå ÇÁ·Î½ÃÁ®

-
1. ÀúÀå ÇÁ·Î½ÃÁ®
(76,789ȸ)
-
2. ÀúÀå ÇÁ·Î½ÃÁ® ¸¸µé±â
(76,990ȸ)
-
3. ÀúÀå ÇÁ·Î½ÃÁ® µ¥ÀÌŸ Ãâ·Â
(77,761ȸ)
-
4. ÀúÀå ÇÁ·Î½ÃÁ® º¯¼ö ¼±¾ð
(76,926ȸ)
-
5. Á¦¾î¹® »ç¿ëÇϱâ
(77,267ȸ)
-
6. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ®
(76,685ȸ)
-
7. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ® - ³»¿ëº¸±â
(76,884ȸ)
-
8. ÀúÀå ÇÁ·Î½ÃÁ® - System ÇÁ·Î½ÃÁ® - DB ¶¼°í,ºÙÀ̱â
(76,898ȸ)
-
9. ÀúÀå ÇÁ·Î½ÃÁ® - ¿ø°Ý¼¹ö ¿¬°á (sp_addlinkedserver)
(76,999ȸ)
- ±âŸ À¯¿ëÇÑ Á¤º¸µé

-
1. Query °æ°ú½Ã°£ üũ ¹æ¹ý
(76,576ȸ)
-
2. ƯÁ¤ ÀÛ¾÷(Ãß°¡,»èÁ¦,¹é¾÷ µîµî) À» ¹Ýº¹ÀÛ¾÷À» ¼öÇà½ÃŰÀÚ.
(76,929ȸ)
-
3. ·Î±×ÆÄÀÏÀÌ ³Ê¹« Å©´Ù. ·Î±×ÆÄÀÏÀ» Ãà¼Ò½ÃŰÀÚ.
(76,569ȸ)
-
4. SQL ¼¹öÀÇ µ¥ÀÌÅÍ Å¸ÀÔ
(76,596ȸ)
-
5. MS_SQL Á¢¼Ó Æ÷Æ® º¯°æÇϱâ
(76,787ȸ)
-
6. ¾ÏÈ£È/º¹È£È - EncryptByPassPhrase() / DecryptByPassPhrase()
(76,728ȸ)
-
7. TimeoutÀÌ ¸¸·áµÇ¾ú½À´Ï´Ù. ÀÛ¾÷À» ¿Ï·áÇϱâ Àü ½Ã°£ÀÌ °æ°úµÇ¾ú°Å³ª ÀÀ´äÇÏÁö ¾Ê¾Ò½À´Ï´Ù.
(76,504ȸ)
-
8. MS-SQL ¿¡¼ ¿¬°áµÈ ¼¹ö (Linked Server )¿¡ MY-SQL DataBase ¼¹ö µî·Ï
(76,694ȸ)
-
9. µ¥ÀÌÅͺ£À̽º ¹é¾÷°ú º¹¿ø (BACKUP & RESTORE)
(76,177ȸ)
-
10. MSSQL Å×ÀÌºí µ¥ÀÌÅ͸¦ .sql ½ºÅ©¸³Æ®·Î MySQL·Î °¡Á®¿À±â
(76,282ȸ)
-
11. DB(µ¥ÀÌÅͺ£À̽º)¸¦ »ç¿ëÁßÀ̶ó »èÁ¦ÇÒ ¼ö ¾øÀ»¶§ Á¶Ä¡¹æ¹ý
(75,733ȸ)
-
12. datetime °ú smalldatetimeÀÇ Â÷ÀÌ
(73,793ȸ)
- MS SQL - SYSTEM VIEW

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