In Oracle11g, use sysdba to connect to ASM. SQLconnassysdbaSQLalterdiskgroupDATAmount; alterdiskgroupDATAmount * ERRORatline1: ORA-15032: notallalterationsperformedORA-15260: permissiondeniedonASMdiskgroupORA-15260: permiss
In Oracle 11g, use sysdba
There is a problem with code highlighting. Replace @ str with @ str during testing.
There is a problem with code highlighting. Replace @ str with @ str during testing.
The Code is as follows:
The Code is as follows:
Use tempdb
Go
If (object_id ('fn
Files are physical representations of databases. File groups can include files distributed in multiple logical partitions to achieve load balancing.
Files are physical representations of databases. File groups can include files distributed in
When I was helping a friend get a server, when I needed to delete a user in a database, the following error message was prompted: The selected user has an object, so how can I solve this problem?
When I was helping a friend get a server, when I
Requirement: enter an Arabic number, give the corresponding Chinese Characters in uppercase, and write it as a stored procedure or function.
Requirement: enter an Arabic number, give the corresponding Chinese Characters in uppercase, and write it as
In the mssqlserver stored procedure, the bulkinserttablefrom path + file has fixed paths and the file name is not fixed.
In the mssql server Stored Procedure, bulk insert table from ''path + file', fixed path, and unfixed file name Implementation
Clear MSSQL logs and setrecoverysimple
Clear MSSQL logs and set recovery simple
The database on the server has been using several log files for a long time.
I think we can discard the previous log files, so we can clean up the previous log
Share a paging Stored Procedure
Share a paging Stored Procedure
The Code is as follows:
/*
* @ Curentpage current page
* @ Pagesize number of records per page
* @ TableName: Table Name
* @ Key primary key (Auto sort)
* @ Where query Condition
1)
There are two servers installed with two databases. One is the master server and the other is the slave server. The following functions synchronize the database of the master database to the slave database in real time, make their data content
I installed sqlserver before and deleted it later. Now, "a previously installed program has created a suspended file on the installation computer. You must restart the computer before running the installer. Unable to proceed. Now I met again and
Analyze the master database in SQL to find out what the master database is mainly used.
Analyze the master database in SQL to find out what the master database is mainly used.
Table sysdatabases: stores database information in the DBMS.
Select
Write the count (*) value to another table.
Write the count (*) value to another table.
1. Write Data to another table in the same database:
The Code is as follows:
Use db1
Go
Create table t1 (
Item varchar (100 ),
Prov varchar (100 ),
Qty
How does one add a column in the query result to indicate the number of records? Add a column to display the number of rows
How does one add a column in the query result to indicate the number of records? Add a column to display the number of rows
SQL basic functions
SQL basic functions
SQL Server basic functions
1. String function length and Analysis
Datalength (Char_expr) returns the number of characters in the string, but does not contain spaces
Substring (expression, start, length
Clever solution for SQL query of continuous number segments
Clever solution for SQL query of continuous number segments
There is a clever SQL technique on ITPUB. Learn it and record it here.
The initial problem was as follows:
I have a table
An SQL statement is used to obtain the post that someone participates in and the total score of the post.
An SQL statement is used to obtain the post that someone participates in and the total score of the post.
Select a. *, B. SumPoint from
In an SQL statement, if the value of a text field is null, you can use the select * from table where field. However, if the data type of this field is text or ntext, the preceding SQL statement will go wrong.
In an SQL statement, if the value of a
Five Ways to Improve SQL Performance
Five Ways to Improve SQL Performance
Release date: 4/1/2004 update date: 4/1/2004
Johnny Papa
Sometimes, in order to make the application run faster, all the work is to make small adjustments here or there. Ah,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service