摘要：一、单语句表值函数ALTER function [dbo].[uf_get_jxc_da_sum](@dt char(8),@dt2 char(8))RETURNS table asreturn( select aa.outlet_id,aa.store_id as storespace_id,aa.supp_id as supplier_id,aa.aid, aa.q as curr_q, aa.ea as curr_ea , aa.ra as curr_ra,aa.dj_ea as curr_dj_ea, quota_q ,quota_ea ,quota_... 阅读全文

摘要：create procedure sp_clearmemasbegin dbcc freeproccache dbcc freesessioncache dbcc freesystemcache('all') dbcc dropcleanbuffers exec sp_configure 'max server memory',256 exec('reconfigure') waitfor delay '00:00:05' exec sp_configure 'max server memory',21474836 阅读全文

摘要：SELECT session_id, request_id, start_time, status, command, sql_handle--,statement_start_offset, statement_end_offset, plan_handle, database_id, user_id --,connection_id, blocking_session_id, wait_type, wait_time, last_wait_type, wait_resource, open_transaction_count, open_resultset_count, transacti 阅读全文

摘要：exec sp_msforeachtable "exec sp_spaceused '?'" 阅读全文