SQL Server ÎÞÕʺŻòÍü¼ÇÃÜÂëµÇ½ÎÊÌâ
Question 1£º
Êý¾Ý¿âµÄÑé֤ģʽΪWindowsÑéÖ¤£¬É¾³ýÁËMS SQL ServerÕʺÅBUILTIN\Administrators,µÇ½²»ÉÏSQL Server¹ÜÀíÆ÷£¿
Answer£º
1.ÖØÐÂÔËÐÐMS SQL SERVERµÄ°²×°³ÌÐò£¬ÔÚ“°²×°Ñ¡ÏçÃæÀïÑ¡Ôñ“¸ß¼¶Ñ¡Ï¬ÏÂÒ»²½ºóÑ¡Ôñ“×¢²á±íÖؽ¨”£¬½ÓÏÂÀ´¸ú°²×°¹ý³Ì²î²»¶à£¬×¢ÒâÔÚÑ¡Ôñ“Éí·ÝÑé֤ģʽ”µÄʱºòÑ¡Ôñ“»ìºÏģʽ”£¬Ä¿µÄÊÇʹsaÕÊ»§ÓÐЧ¡£
2.Öؽ¨Íê³ÉÒÔºó£¬Óòéѯ·ÖÎöÆ÷£¬Ê¹ÓÃsaÕÊ»§µÇ¼£¬ÔÚ²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐ sp_grantlogin 'builtin\administrators'£¬ÕâÑù¾Í»Ö¸´windowsÉí·ÝÑéÖ¤ÁË¡£
Question 2£º
Êý¾Ý¿âµÄÑé֤ģʽΪ»ìºÏÑéÖ¤£¬ÎÞsaÕʺŵÄÃÜÂ룬ɾ³ýÁËMS SQL ServerÕʺÅBUILTIN\Administrators,µÇ½²»ÉÏSQL Server¹ÜÀíÆ÷£¿
Answer£º
1.°ÑMSsqlserver·þÎñÍ£Ö¹£¬°Ñ master.mdfºÍmastlog.ldf Îļþ¿½±´³öÀ´¡£
2.ÔÚ±ðµÄsqlserver·þÎñÆ÷ÉÏ£¬°ÑÎļþ¸½¼Ó³ÉÊý¾Ý¿âAAA(Êý¾Ý¿âÃû³Æ×Ô¼º¾ö¶¨£¬ÕâÀï¼ÙÉèÊÇAAA),È»ºóÖ´ÐÐ update AAA..sysxlogins set password=null where name='sa'
3.°Ñmaster.mdfºÍmastlog.ldfÁ½¸öÎļþ¸²¸Çµ½SQL Server°²×°Ä¿Â¼µÄdataĿ¼Ï£¬Æô¶¯SQL Server£¬´ËʱsaÃÜÂëΪ¿Õ.
Ïà¹ØÎĵµ£º
½ñÌìÔÚÏîÄ¿ÖÐÓÐÒ»ÎÊÌ⣬ÔÚÍøÉϲéѯÁËcaseµÄÓ÷¨£¬Ìû³öÀ´ºÍ´ó¼Ò·ÖÏíÏ¡£
ÎÊÌâÃèÊö£ºÔÚÒ»ÕűíÖÐÓÐÒ»×Ö¶ÎbitÀàÐÍ£¬±íʾ´ËÌõÊý¾ÝÊÇ·ñ±»Ëø¶¨£¬ÔÚÒ³ÃæÉÏÓÐÒ»°´Å¥ÊǶԴËÌõÊý¾Ý½øÐÐËø¶¨ºÍ½âËøµÄ£¬Ñ¡ÔñÒ³ÃæÖеÄÊý¾Ý£¬µã»÷Õâ¸ö°´Å¥£¬Èç¹ûÕâÌõÊý¾ÝÊÇËø¶¨µÄ£¬¾Í½âËø£»Èç¹ûÊÇδ˵¶¨µÄ¾ÍËø¶¨£¬ÕâÑù¾ÍÓÃÒ»ÌõÓï¾äÀ´ÊµÏÖ¡£ºóÀ´Ï ......
Introducing Oracle Database 11g
List the features of Oracle Database 11g
Discuss the basic design, theoretical and physical aspects of a relational database
Categorize the different types of SQL statements
Describe the data set used by the course
Log onto the database using the SQL Develope ......
1.¶Á³ö±íÖеÄ×Ö¶ÎÃû
ResultSet rs = test.selectSql("SELECT * from datainfo");
java.sql.ResultSetMetaData md=rs.getMetaData(); //¶Á³öÊý¾Ý¿âµÄ×Ö¶ÎÃû
int nColumn=md.getColumnCount(); //×Ö¶Î×ÜÊý
for(int i=0;i<nColumn;i++)
& ......
µ÷Óà MS SQL ±êÁ¿Öµº¯Êý£¬Ó¦¸ÃÔÚº¯ÊýÇ°Ãæ¼ÓÉÏ "dbo."£¬·ñÔò»á±¨ “²»ÊÇ¿ÉÒÔʶ±ðµÄ ÄÚÖú¯ÊýÃû³Æ”´íÎó¡£ÀýÈç
DECLARE @WhichDB TINYINT;
SELECT @WhichDB = user_GetWhichDB(1);--¿´¿´ÊÇÄĸöÊý¾Ý¿âµÄ
=================================================
-- ......
¸ÐлÌ῵µÂÂÞ¼ÓµÄͶµÝ
¾ÍÏñµ±Ä겨ʿ¶ÙµÄ°®¹úÕßΪ·´¿¹Ó¢¹úÖØË°µÄÐж¯Ò»Ñù£¬NoSQLµÄÖ§³ÖÕßÃÇ´Ó¸÷µØÓ¿À´£¬·ÖÏíËûÃÇÈçºÎÍÆ·»ºÂý¶ø°º¹óµÄ¹ØϵÊý¾Ý¿âµÄ±©Õþ£¬ÔõÑùʹÓøüÓÐЧºÍ¸ü±ãÒ˵ķ½·¨À´¹ÜÀíÊý¾Ý£¬ËûÃÇ¿ªÊ¼¶ÔSQL˵²»£¡NoSQL×éÖ¯ÉϸöÔÂÔھɽðɽµÄÐж¯ÈÃÈËÎŵ½ÁËÊý¾Ý¿â¸ïÃüµÄζµÀ£¬ºÃÏñÒ»¸öÏÖ´úITÒµ°æµÄ²¨ ......