ÈçºÎ¼ì²éSQL Server ÄÚ´æÆ¿¾±
DBCC memorystatus
--²éѯ»º³åÇø³ØÏûºÄµÄÄÚ´æ×ÜÁ¿°üÀ¨AWE
SELECT
SUM(multi_pages_kb+virtual_memory_committed_kb+shared_memory_committed_kb+
awe_allocated_kb) AS [Used by BPool, kb]
from sys.dm_os_memory_clerks WHERE type='MEMORYCLERK_SQLBUFFERPOOL'
--È·ÈÏÄÇЩÄÚ²¿×齨ÇÔÈ¡ÁË»º³åÇø³ØÖеĴ󲿷ֵÄÒ³Ãæ
SELECT TOP 10 type, SUM(single_pages_kb) AS stolen_mem_kb
from sys.dm_os_memory_clerks
GROUP BY type ORDER BY SUM(single_pages_kb) DESC
--È·ÈÏÔÚ»º³åÇø³ØÍâ·ÖÅäÁËÄÚ´æµÄÄÚ²¿×齨
SELECT type, SUM(multi_pages_kb) AS memory_allocated_kb
from sys.dm_os_memory_clerks
WHERE multi_pages_kb!=0
GROUP BY type
Ïà¹ØÎĵµ£º
1¡¢°´Ê±¼äÅÅÐò
select * from tbl_lms_loginhistory order by loginhistory_logintime desc
2¡¢
ÔÚÒ»¸öÊý¾Ý¿âÖÐÊÇÏÂÁеÄÑù×Ó
³µ´Î Éí·ÝÖ¤ºÅ
27 1
27 2
45 1
25 1
45 2
ÏÖÔÚÎÒÏë »ñµÃµÄÊÇ
³µ´Î ³Ë×ø´ÎÊý
25 1
27 3
45 2
ÇëÎÊ£¬ÎÒµÄSQLÓï¾ä¸ÃÔõôд£¿
select ³µ´ ......
SQL_Plus²Ù×÷ÃüÁî ¸½Â¼B SQL*PLUS
SQL*PLUS ÊÇOracleÌṩµÄÒ»¸ö¹¤¾ß³ÌÐò£¬Ëü²»½ö¿ÉÒÔÓÃÓÚ²âÊÔ£¬ÔËÐÐSQLÓï¾äºÍPL/SQL¿é£¬¶øÇÒ»¹¿ÉÒÔÓÃÓÚ¹ÜÀíOracleÊý¾Ý¿â
1.Æô¶¯sql*plus
ΪÁËʹÓÃsql*plus£¬±ØÐëÊ×ÏÈÒªÆô¶¯sql*plus¡£Oracle²»½öÌṩÁËÃüÁîÐкÍͼÐνçÃæµÄsql*plus£¬¶øÇÒ»¹¿ÉÒÔÔÚwebä¯ÀÀÆ÷ÖÐÔËÐÐ.
  ......
1 ²éѯsqlÓÅ»¯
1.1 Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò£¨Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧORACLE£©
½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí¡£ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí ......
ÔÚ´æ´¢¹ý³ÌÖÐʹÓÃÊÂÎñ£¬ÒÔÏÂΪģ°å£º
CREATE PROCEDURE testPro
AS
/**//* ------- ÊÂÎñ¿ªÊ¼---------- */
BEGIN TRANSACTION tran_test
/**//* -------- ±£´æÊÂÎñ----------*/
SAVE TRANSACTION tran_test
/**//* -------- Êý¾Ý²Ù×÷---------*/
INSERT [table1] ( [content] ) VALUES ( '43332' )
/**//*---- ......
Ò»¡¢°´Ö¸¶¨·ûºÅ·Ö¸î×Ö·û´®£¬·µ»Ø·Ö¸îºóµÄÔªËØ¸öÊý£¬·½·¨ºÜ¼òµ¥£¬¾ÍÊÇ¿´×Ö·û´®ÖдæÔÚ¶àÉÙ¸ö·Ö¸ô·ûºÅ£¬È»ºóÔÙ¼ÓÒ»£¬¾ÍÊÇÒªÇóµÄ½á¹û¡£
CREATE function Get_StrArrayLength
(
@str varchar(1024), --Òª·Ö¸îµÄ×Ö·û´®
@split varchar(10) --·Ö¸ô·ûºÅ
)
......