Ȩ > ±â¼úÁö¿ø > ¹¯°í´äÇϱâ

Question and Answer 205
Ref#: 86
MSSQLSERVER¿¡¼­ Å×ÀÌºí ¸¸µå´Â¹ýÀº?

· »ç¿ëÁ¦Ç°: All

Microsoft SQL Server ÇÁ·Î±×·¥ ¸Þ´ºÀÇ Enterprise Manager¸¦ »ç¿ëÇÏ¿© GUI ȯ°æ¿¡¼­ Å×À̺íÀ» ¸¸µé ¼ö ÀÖ½À´Ï´Ù.
¶ÇÇÑ, Query Analyzer¸¦ »ç¿ëÇÏ¿© ¾Æ·¡¿Í °°Àº SQL Script¸¦ ½ÇÇàÇÏ¿© ¸¸µé ¼öµµ ÀÖ½À´Ï´Ù.

CREATE TABLE tblBbs_Free (
index_num int NOT NULL , /* ÀϷùøÈ£ */
no int NOT NULL , /* ±Û¹øÈ£ */
re_level int NOT NULL , /* ´äº¯·¹º§(Á¾) */
ref int NOT NULL , /* ´äº¯¼ö(Ⱦ) */
id varchar (20) NOT NULL , /* ±Û¾´ÀÌ ID or Nick Name */
pass varchar (20) NOT NULL , /* ºñ¹Ð¹øÈ£ */
title varchar (500) NOT NULL , /* Á¦¸ñ */
content text NOT NULL , /* ³»¿ë */
writeday datetime NOT NULL , /* ¿Ã¸°ÀϽà */
readnum int NOT NULL , /* Á¶È¸¼ö */
ip char (16) NOT NULL , /* IP ÁÖ¼Ò */
filename varchar (30) NULL , /* ÷ºÎ ÆÄÀÏ */
down int NOT NULL , /* ´Ù¿î·Îµå¼ö */
recommend int NOT NULL , /* Ãßõ¼ö */
email varchar (50) NULL , /* ¸ÞÀÏ */
CONSTRAINT tblBbs_Free_PK PRIMARY KEY NONCLUSTERED
(
index_num
)
)

Enterprise Manager ¹× Query Analyzer ¸Þ´º´Â MSDE¸¦ ¼³Ä¡Çß´Ù¸é Client Tools¸¦ º°µµ·Î ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù.

[¹®ÀÇ ³»¿ë]

· »ç¿ëÁ¦Ç°: All

ÀÎÅÍÄ¡ ¼³Ä¡½Ã °°ÀÌ ¼³Ä¡µÇ´Â MSSQL SERVER¿¡¼­ Å×ÀÌºí ¸¸µå´Â ¹ýÀÌ ¾î¶»°Ô µÇ´ÂÁö¿ä????


ÀÛ¼ºÀÚ: cpyou
ÀÛ¼ºÀÏ: 2006-06-06 ¿ÀÀü 11:41:00
Á¶È¸¼ö: 3394

ÀÌÀü±Û: Intouch Data¸¦ ½Ç½Ã°£À¸·Î excel·Î Àоî¿À±â
´ÙÀ½±Û: È­¸é¸ØÃãÇö»ó

°ü·Ã±Û
Title Author Date Qry.
MSSQLSERVER¿¡¼­ Å×ÀÌºí ¸¸µå´Â¹ýÀº? anonymous 2006-06-06 3421
>> Re: MSSQLSERVER¿¡¼­ Å×ÀÌºí ¸¸µå´Â¹ýÀº? cpyou 2006-06-06 3394