, give you a grudge, it is more miserable, the consequences, it is difficult to predict.
It's different to be a salesman, you have to think about these things, do customers often care whether the competitor to rob a single, partners have any other action, the customer should always be careful to speak, pay attention to every detail, know how to look at the color, do not want every word is so pleasant, but must not offend customers, Otherwise, customers want to talk to others about the contract,
consequences, it is difficult to predict.It's different to be a salesman, you have to think about these things, do customers often care whether the competitor to rob a single, partners have any other action, the customer should always be careful to speak, pay attention to every detail, know how to look at the color, do not want every word is so pleasant, but must not offend customers, Otherwise, customers want to talk to others about the contract, you still cheerfully in the dark, every day to
Label:1. Row to column: First, the initial data: Data after conversion: Second, the conversion of the statement: --statistics on the number of staff in various positions in various departments:SELECT T.job, SUM (DECODE (t.job, ' clerk ', 1, NULL)) as COUNT1, SUM (DECODE (T.job, ' salesman ', 1, NULL)) as COUNT2, SUM (DECODE (t.job, ' president ', 1, NULL)) as COUNT3, SUM (DECODE (t.job, ' MANAGER ', 1, NULL)) as COUNT4, SUM (DECODE (t.job, ' ANALYST ', 1, NULL)) as COUNT5From EMP TGROUP by T.j
select * FROM Dbo.pvtcustorders
3 Select Custid,years,qty
4 from Dbo.pvtcustorders
5 Unpivot (Qty for years in ([2002],[2003],[2004])) as up
6 GO
7--A dynamic scenario for a career change: Unpivot, Sql2005 and later version
8-because the line is dynamic so here is the information_schema. The columns view gets the columns to construct the rows, and the XML processing is also used.
9 DECLARE @SQL NVARCHAR (4000) =n ";
The SET @SQL =stuff ((SELECT N ', ' +quotename (column_name) from INFORM
ORDER BY User_name,courseYou can also make use of the insert all into ... Select to first build a table test_tb_grade3:SQL code:1 CREATE TABLE Test_tb_grade32 (3 user_name VARCHAR2 (CHAR),4 COURSE VARCHAR2 (CHAR),5 Score FLOAT6)Then execute the following sql:SQL code:1 Insert All2 into Test_tb_grade3 (User_name,course,score) VALUES (user_name, ' languages ', Cn_score)3 into Test_tb_grade3 (User_name,course,score) VALUES (user_name, ' math ', Math_score)4 into Test_tb_grade3 (User_name,course,sc
People of different ages may have different feelings and ideas. Some people suddenly find themselves confused about their future and do not know what to do in the future. Some people want to go abroad with gold plating, improve their own quality,
1, I am 23 years old this year.
2, just engaged in PHP, know the work experience of predecessors can let me go a lot less detours, sincere advice.
Reply content:Don't quite agree upstairs to answer anonymously.
The improvement of technology is the
A prestigious international
ComputerWorld (Domestic "
The American original of Computer World) was written by a woman journalist two days ago.
"Thetop10dead (ordying) Computerskills" (Ten dead and dying it technologies and occupations) a
I have entered the programming industry for more than 2 years. Sometimes I feel like I'm not very good at being a programmer.
1, find yourself learning new things a little passive
2, learn new things when they feel a little slow, not quickly start
September 8, Tuesday, on a day class, there are four days class, not counted overtime, think about the heart tired, you oscer you okay?@ Bear two : One day a programmer saw God. God: Lad, I can satisfy you with a wish. Programmer: I hope the Chinese
Relative to the elementary level that is constantly on the road of developmentCIO (Chief Information Officer)Or quasiCIOThose who have passed the initial career period and entered the career PeriodCIO --Let's call it the postCIOPerson. AfterCIOMost
"At the age of 35, your technical career is over ." This statement has been recognized by many people in the IT industry, and many IT people worry about their future. In fact, from another perspective, the end of a technical career means the
In recent years, the talent market in China has been oversupply, and the employment of college students has become a common concern in the society. Some people joked that "Graduation is equal to unemployment ". For this phenomenon, the most
Question: At present many young people are under the pressure of life, feel that their wages to make ends meet, looking at the side to do it's friends income all over million, even if the programmer is to eat "youth rice", but also want to go to do
This section describes in detail the DNS server's rndc configuration, enabling DNS resolution logs and refreshing cache using rndc, reload the configuration file, and disabling the DNS server. Once rndc is configured, these operations can be performed on both local and remote servers. The DNS Service is currently a relatively secure service. It not only changes t
)
#./Configure-prefix =/usr/local/named-enable-threads# Make make install !)
# Ls/usr/local/named/(view the directory after installation)Bin etc include lib man sbin var first generates a control key for master-slave data encryption.#/Usr/local/named/sbin/rndc-confgen-a-c bkjia. key-k bkjia
The generated/bkjia. key is also uploaded to the Master/Slave server.
Enter/usr/local/named/etc, and generate rndc. c
is installed. The releasegz is bind-9.4.2.tar.gz.For ease of use in other operating systems, we still install it in the source code package. First from the ISC home page (http://www.isc.org/index.pl? /Sw/bind/index. php) software package.Decompress:
# Pwd/Opt/wacos/encle# Gunzip bind-9.4.2.tar.gz# Tar-xvf bind-9.4.2.tar
Configure compilation and installation. BIND is normally installed in the/usr/local directory, but you can adjust the -- prefix parameter settings. In this example, IPv6 is not
In NS NS2.
In MX 10 mail
NS1 in a 172.16.100.1
Ns2-in A 172.16.100.2
Mail in a 172.16.100.2
Pop in a 172.16.100.4
WWW in a 172.16.100.1
WWW in a 172.16.100.3
DNS log file path/var/log/messages:
[[Email protected] etc] # service named start
[[Email protected] etc] # tail/var/log/messages
An error may occur during synchronization. You need to add one more NS record. When adding an NS server, you must add one record.
Rndc: Used to remotely manage DNS
authoritative DNS server in each domain is also called the primary NDS server.
The primary DNS server will have a secondary DNS server, while the data on the secondary DNS server will only be synchronized and copied from the primary DNS server. When it is working, the data in your region will be updated regularly, and the slave DNS can not only copy data from the master DNS server, but also from other slave DNS servers, in this way, if you set a slave DNS server in a region, you can share the
must run the/dev/Random Device chroot ", it also reminds us to run "rndc-confgen-a" to generate a correct configuration file-random key. The system uses/usr/local as the root directory. Therefore, bind9 command files are stored in the/usr/local/sbin directory and/usr/local/bin directory. After BIND 9 is installed, the system automatically creates a "bind" user with UID 53 and a "bind" group with GID 53 for BIND services...
I like the powerful feature
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.