SQLÓï¾ä?

SQL code:


create table order1 (ʱ¼ä varchar(30) primary key not NULL ,×èÖµ numeric(5,3) , ¹¦ÂÊ numeric(5,3))
INSERT INTO order1(ʱ¼ä,×èÖµ,¹¦ÂÊ )VALUES (convert(varchar,getdate(),21),123,333)



±¾ÈËÏëÔڸñíµÄʱ¼ä×Ö¶ÎÉϼÓÒ»¸ö¾Û¼¯Ë÷Òý£¬ÒÔÄêÔÂÈÕСʱΪµ¥Î»£¬Ôõôд£¿

---

SQL code:
create table order1 (ʱ¼ä varchar(30) primary key clustered not NULL ,×èÖµ numeric(5,3) , ¹¦ÂÊ numeric(5,3))

---

¼ÓÁËË÷ÒýÓô¦Ò²²»´ó òËÆÄãÓÃÁ˺¯Êý

---

SQL code:
create table order1 (
ʱ¼ä varchar(30) not NULL ,
×èÖµ numeric(5,3) ,
¹¦ÂÊ numeric(5,3),
PRIMARY KEY CLUSTERED
(
[ʱ¼ä]
) ON [PRIMARY] )

---

SQL code:
create index

---

SQL code:
create clustered index idx_text on order1(ʱ¼ä)

---

¶¼ÒѾ­Ö÷¼üÁË
»á¼ÓµÄ

---

ÒýÓÃ

¼ÓÁËË÷ÒýÓô¦Ò²²»´ó òËÆÄãÓÃÁ˺¯Êý

²»ÊǺÜÃ÷°×£¿£¿

---

Èç¹ûÊÇÐÞ¸