Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ms sql server ´´½¨Óû§


SQL code
´´½¨½ÇÉ«£¬Óû§£¬È¨ÏÞ
/*--ʾÀý˵Ã÷
ʾÀýÔÚÊý¾Ý¿âpubsÖд´½¨Ò»¸öÓµÓбíjobsµÄËùÓÐȨÏÞ¡¢ÓµÓбítitlesµÄSELECTȨÏ޵ĽÇÉ«r_test
Ëæºó´´½¨ÁËÒ»¸öµÇ¼l_test£¬È»ºóÔÚÊý¾Ý¿âpubsÖÐΪµÇ¼l_test´´½¨ÁËÓû§ÕË»§u_test
ͬʱ½«Óû§ÕË»§u_testÌí¼Óµ½½ÇÉ«r_testÖУ¬Ê¹Æäͨ¹ýȨÏ޼̳лñÈ¡ÁËÓë½ÇÉ«r_testÒ»ÑùµÄȨÏÞ
×îºóʹÓÃDENYÓï¾ä¾Ü¾øÁËÓû§ÕË»§u_test¶Ô±ítitlesµÄSELECTȨÏÞ¡£
¾­¹ýÕâÑùµÄ´¦Àí£¬Ê¹ÓÃl_testµÇ¼SQL ServerʵÀýºó£¬ËüÖ»¾ßÓбíjobsµÄËùÓÐȨÏÞ¡£
--*/
USE pubs
--´´½¨½ÇÉ« r_test
EXEC sp_addrole 'r_test'
--ÊÚÓè r_test ¶Ô jobs ±íµÄËùÓÐȨÏÞ
GRANT ALL ON jobs TO r_test
--ÊÚÓè½ÇÉ« r_test ¶Ô titles ±íµÄ SELECT ȨÏÞ
GRANT SELECT ON titles TO r_test
--Ìí¼ÓµÇ¼ l_test,ÉèÖÃÃÜÂëΪpwd,ĬÈÏÊý¾Ý¿âΪpubs
EXEC sp_addlogin 'l_test','pwd','pubs'
--ΪµÇ¼ l_test ÔÚÊý¾Ý¿â pubs ÖÐÌí¼Ó°²È«ÕË»§ u_test
EXEC sp_grantdbaccess 'l_test','u_test'
--Ìí¼Ó u_test Ϊ½ÇÉ« r_test µÄ³ÉÔ±
EXEC sp_addrolemember 'r_test','u_test'
--¾Ü¾ø°²È«ÕË»§ u_test ¶Ô titles ±íµÄ SELECT ȨÏÞ
DENY SELECT ON titles TO u_test
/*--Íê³ÉÉÏÊö²½Öèºó,Óà l_test µÇ¼,¿ÉÒÔ¶Ôjobs±í½øÐÐËùÓвÙ×÷,µ«ÎÞ·¨¶Ôtitles±í²éѯ,ËäÈ»½ÇÉ« r_test ÓÐtitles±íµÄselectȨÏÞ,µ«ÒѾ­ÔÚ°²È«ÕË»§ÖÐÃ÷È·¾Ü¾øÁ˶ÔtitlesµÄselectȨÏÞ,ËùÒÔl_testÎÞtitles±íµÄselectȨÏÞ--*/
--´ÓÊý¾Ý¿â pubs ÖÐɾ³ý°²È«ÕË»§
EXEC sp_revokedbaccess 'u_test'
--ɾ³ýµÇ¼ l_test
EXEC sp_droplogin 'l_test'
--ɾ³ý½ÇÉ« r_test
EXEC sp_droprole 'r_test'
SQL code
--1. ´´½¨Ê¾Àý»·¾³¡£
Ê×ÏÈʹÓÃÏÂÃæµÄ´úÂë´´½¨Ò»¸öµÇ¼l_test£¬²¢ÇÒΪµÇ¼ÔÚÊý¾Ý¿âpubsÖд´½¨¹ØÁªµÄÓû§ÕË»§u_test£¬²¢ÇÒÊÚÓèÓû§ÕË»§u_test¶Ô±ítitlesµÄSELECTȨÏÞ£¬ÓÃÒÔʵÏֵǼl_testÁ¬½Óµ½SQL ServerʵÀýºó£¬¿ÉÒÔ·ÃÎʱítitles¡£È»ºó´´½¨ÁËÒ»¸öÓ¦ÓóÌÐò½ÇÉ«r_p_test£¬ÊÚÓè¸Ã½ÇÉ«¶Ô±íjobsµÄSELECTȨÏÞ£¬ÓÃÒÔʵÏÖ¼¤»îr_p_testʱ£¬ÔÊÐí·ÃÎÊÌØ¶¨µÄ±íjobs¡£
USE pubs
--´´½¨Ò»¸öµÇ¼ l_test, ÃÜÂë pwd, ĬÈÏÊý¾Ý¿â pubs
EXEC sp_addlogin 'l_test','pwd','pubs'
--ΪµÇ¼ l_test ÔÚÊý¾Ý¿â pubs ÖÐÌí¼Ó°²È«ÕË»§ u_test
EXEC sp_grantdbaccess 'l_test','u_test'
--ÊÚÓ谲ȫÕË»§ u_test ¶Ô titles ±íµÄ SELECT ȨÏÞ
GRANT SELECT ON titles TO u_test
--


Ïà¹ØÎĵµ£º

Sql ÀïÃæ ROW_NUMBER Ó¦Óó¡¾°

ROW_NUMBER ·µ»Ø°´Ò»¶¨¹æÔòÅÅÐòµÄµ±Ç°¼Ç¼¶ÔÓ¦µÄÐкÅ
±ÈÈçÎÒÃÇÓÐÕâÑùÒ»¸öÓ¦Óó¡¾°£º
ÏÖÔÚÓиö±ÈÈü£¬ÐèÒª´ÓÍøÉϲÎÈüÕß´Ó´ÓÍøÂçÉϱ¨Ãû£¬È»ºóÈ¥×îÔ籨ÃûµÄ5¸öÈ˲μӱÈÈü£¬Îª´ËÎÒÃÇʵÏÖÈçÏ£º
1.Ϊ´ËÎÒÃÇÒª½¨Á¢Ò»ÕűíÀ´±£´æ±¨Ãû²ÎÈüÕßµÄÐÕÃû¼°Æð±¨Ãûʱ¼ä
CREATE 
TABLE [dbo].[UserEnroll](
[UserName] [nvarchar] ......

SQLÓï¾ä´óÈ«

Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......

jspÓëSQL Server 2000 µÄÁ¬½Ó

ÖÕÓڸ㶨JSPÁ¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌâÁË
2008Äê01ÔÂ29ÈÕ ÐÇÆÚ¶þ 15:54
    ǰ¼¸Ì죬ƽƽͬѧһֱÔÚ¸ãJSP Á¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌ⣬һֱÁ¬²»ÉÏ£¬È»ºó½ÐÎÒÈ¥°ïËû¿´¿´£¬Æ¾×ÅÒÔǰµÄ¾­Ñ飬¸ãÁËÒ»¸öÏÂÎ磬ºÙºÙ£¡ÖÕÓÚ°ïËûÁ¬½ÓÉÏÁË£¬Ö÷Òª²½ÖèÈçÏ£º
    1¡¢ÐèÒªµÄ¶«Î÷´ó¼Ò¿ÉÒÔµ½Î ......

asp/asp.netÁ¬½Ósql anywhereÊý¾Ý¿â


<%
set conn= server.createobject("ADODB.connection")
conn.open "driver={sybase driver 10};"
"srvr=SYBASE;"
"UID=sa;"
"pwd=sybase;"
sql="select no from tab_st ......

sql Óï¾ä´¦Àí ÈÕÆÚ´¦Àí

DATENAME([Year],
      dbo.reservation.begintime) + N'Äê' + CAST(DATEPART([Month],
      dbo.reservation.begintime) AS varchar) + N'ÔÂ' + DATENAME([Day],
      dbo.reservation.begintime) + N'ÈÕ' + DATENAME([Hour], dbo.r ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ