
ºÜ»ù´¡µÄsqlÓï¾äµÄʹÓÃʾÀý
24£®Îª¡°Ñ§Éú¡±±í´´½¨Ò»¸öÒÀÀµÓÚ¡°Ñ§ºÅ¡±µÄΨһµÄ¡¢·Ç¾Û¼¯µÄË÷Òý
Create unique nonclustered index stu_int on students(sno)
25£®Í¨¹ýÓαêÖðÐжÁÈ¡¡°Ñ§Éú¡±±íµÄ¼Ç¼
Declare stu_cur cursor for
Select * from students for read only Open stu_cur Fetch stu_cur Close stu_cur Deallocate stu_cur
°Ù¶ÈËÑË÷¡°77cn¡±»ò¡°Ãâ·Ñ·¶ÎÄÍø¡±¼´¿ÉÕÒµ½±¾Õ¾Ãâ·ÑÔĶÁÈ«²¿·¶ÎÄ¡£Êղر¾Õ¾·½±ãÏ´ÎÔĶÁ£¬Ãâ·Ñ·¶ÎÄÍø£¬Ìṩ¾µäС˵½ÌÓýÎÄ¿âSQLÓï¾ä´´½¨Ñ§ÉúÐÅÏ¢Êý¾Ý¿â±íµÄʾÀý(8)ÔÚÏßÈ«ÎÄÔĶÁ¡£
Ïà¹ØÍÆ¼ö£º
