Programmer Group

For DBA, monitoring disk usage is a necessary task. There is no easy way to obtain disk space usage information. Here's a summary of the scripts saved over the years: The most commonly used way to view disk free space, which is a must-remember entry to DBA: -- View Disk Available Space EXEC master.dbo.xp_fixeddrives The xp_fixeddrives m ...

This paper implements a GridView with ASP.NET MVC 5. Its functions include paging, filtering, sorting, asynchronous execution of AJAX, and also support Responsive Web Design in appearance. The execution screen is shown in Fig. 1 below.ASP.NET MVC implements GridView and paging in many ways. This article refers to several articles of Code Projec ...

1. Introduction to PLSQL Oracle database extends SQL, and then adds some programming language features, which can control the execution process of SQL, and then realize some complex business functions. 1.1 Composition of PLSQL Component declare - It's the declaration part. begin - yes plsql ...

Four stored procedures are created, which are simple stored procedure without parameters, stored procedure with two input parameters IN, stored procedure with one input parameter IN, one output parameter OUT and stored procedure with two input and output parameters IN OUT. Create a global temporary emp table CREATE GLOBAL TEMPORARY TABLE e ...

1. Stored procedure structure 1.1 First stored procedure create or replace procedure proc1( p_para1 varchar2, p_para2 out varchar2, p_para3 in out varchar2 )as v_name varchar2(20); begin v_name := 'Zhang Sanfeng'; p_para3 := v_name; dbms_output.put_line('p_pa ...

Data constraints 1. Data constraints: Adding some data constraints to the table can achieve the effect of constraining users to manipulate data. 2. default constraints When no value is added to the field, a default value is given. If the value added to the field constrained by the default value is null, its field value is null. Cre ...

Reorg is mainly to rearrange the data to save unnecessary space use, at the same time, it can reduce the number of write buffers and improve performance. Reducing space occupancy can be achieved by reducing the high water level in surface space. In order to analyze various reorg cases, an experimental test was carried out in particular. 1. ...

Basics Create a database Determine whether the database exists before creating it if exists (select * from sysdatabases where name='databaseName') drop database databaseName go Create DATABASE database-name Delete the database drop database dbname Backup sql server Create a device for backing up data USE master EXEC sp_addumpdevi ...

commit method apply method summary Most people die at the age of 20 or 30. They become their own shadow. The future life is just to copy themselves day by day. —— Roman Rowland's John Christopher Today, I was asked a few basic questions. I didn't pay attention to them. I made an embarrassing reply. I took this opportuni ...

function Grammar for Defining Functions Practice calculating the sum of two numbers Adding Data to Exercise Functions Call function of exercise function view Characteristics of Views Adding and deleting views Add view Delete view Synonym SYNONYM grammar Practice synonyms cursor Classification of cursors Cursor syntax Pr ...