Improve the utilization rate of mining CPU

1. 建立一个函数，函数如下
CREATE FUNCTION [dbo].[f_num_chn] (@num numeric(14,5))
RETURNS varchar(100) WITH ENCRYPTION
AS
BEGIN
DECLARE @n_data VARCHAR(20),@c_data VARCHAR(100),@n_str VARCHAR(10),@i int
SET @n_data=RIGHT(SPACE(14)+CAST(CAST(ABS(@num*100) AS bigint) AS varchar(20)),14)
SET @c_data=''
SET @i=1
WHILE @i<=14
BEGIN
SET @n_str=SUBSTRING(@n_data,@i,1)
IF @n_str<>' '
BEGIN
IF not ((SUBSTRING(@n_data,@i,2)='00') or
((@n_str='0') and ((@i=4) or (@i=8) or (@i=12) or (@i=14))))
SET @c_data=@c_data+SUBSTRING('零壹贰叁肆伍陆柒捌玖',CAST(@n_str AS int)+1,1)
IF not ((@n_str='0') and (@i<>4) and (@i<>8) and (@i<>12))
SET @c_data=@c_data+SUBSTRING('仟佰拾亿仟佰拾万仟佰拾圆角分',@i,1)
IF SUBSTRING(@c_data,LEN(@c_data)-1,2)='亿万'
SET @c_data=SUBSTRING(@c_data,1,LEN(@c_data)-1)
END
SET @i=@i+1
END
IF @num<0
SET @c_data='负数'+@c_data
IF @num=0
SET @c_data='零圆'
IF @n_str='0'
SET @c_data=@c_data+'整'
RETURN (@c_data)
END

调用
select [dbo].[f_num_chn](120)

2. Unknown_Error

3. 14. Make friends with yourself. In your QQ blacklist group, right-click to pop up the dialog box, select "add bad list", enter your own QQ number, and then pull yourself to your friend group The premise must be that your QQ personal authentication is "allow anyone to list me as a friend.". 15. Change the personal image photos of QQ space at will. Enter their own QQ space, in the address input http://izone.qq.com/client/index.htm?uin= (add your QQ number after the equal sign), enter, then select 'personal block' on the top, and then select 'show my picture' on the left. Enter the picture address here and click OK. 16. You can chat with anyone you want. First of all, you must know which machine the person is sitting on, and then use a tool: QQ sixth sense, download address (valid for a long time): http://hackol.com/soft/2006/04/qqd6g.rar If you don't know how to use the software, you can ask me. 17. Change QQ gender to any word. Download address (long term) http://hackol.com/soft/2006/03/qq2--6.rar 18. QQ paid service means no payment. QQ payment service can be opened by mobile phone, as we all know; From the 20th of every month to the end of the month, you can use your mobile phone to open the charging service. There is no charge for that month, as we all know. For example, if you open QQ membership after the 20th of the month: set QQ avatar, clone friends... These are free, as long as you cancel the QQ membership service before the 1st of next month. After the cancellation of QQ Avatar has changed into their favorite, friends QQ also successfully cloned. In short, as long as you have a mobile phone, from the 20th to the end of each month, you apply for paid service without dection. During this period, you can play as you like, and remember to cancel it before charging on the 1st of next month. It should be noted that a service will be charged if it is opened twice in the same month. 19. The secret of making the shopping coupon of QQ show never expire. This secret collection is very useful for those who steal qq COINS, because they can't be given away. They can only be given away by changing them into shopping vouchers. If the stolen QQ coins are not used to buy or send QQ shows, they don't have to use them. I believe many people know that the use period of QQ show shopping vouchers is valid for the current month, and it will all disappear on the 1st of next month, so many people have to use up QQ shopping vouchers before they expire. OK, let's start the demonstration. First of all, we need to explain one thing. This process must be done between the 25th and 31st of the month to be useful. You don't need to know the reason. Just follow me. Login QQ mall http://qqshow.qq.com Click "photo studio" above, and enter your own QQ number in the "initiate group photo" text. Once again, you must enter your own QQ number. After the operation, click "initiate group photo" to enter the purchase area of group photo items, where you need to spend the remaining balance of shopping vouchers, If you can't spend all the coupons at one time, you can take a group photo several times until there is no coupons in your account. Otherwise, the remaining coupons will disappear next month. After payment, you can log in to another group photo QQ and receive the system information of "waiting for your confirmation of group photo request". Click the "view" button to enter the "group photo request information" page and select "ignore" for all, Now you don't have to pay attention to anything. On the 1st of next month, Tencent will refund all the expenses of last month's group photo to your account Here is a supplementary point: if there are QQ coins and shopping vouchers on QQ at the same time, the shopping vouchers will be paid first when consuming) 20. A dime will permanently open all charging services of QQ. If you need a mobile phone's waste card (only 10 cents left), enter the http://mobile.qq.com/mo2.shtml To apply for a mobile phone login password, first enter your mobile phone number, and then fill in the additional code. After confirmation, you will receive a verification code. The application is successful, and then all Tencent services are opened on QQ, Because the mobile phone password is the only certificate that can use other functions, Tencent will cancel your mobile phone account regularly. As long as you change the mobile phone password once a month, it will not be cancelled. The website that changes the password is the same as the website just now. You can see the button to change the password in the login mobile phone interface. Taobao those owners 50 yuan for netizens to permanently open all fee business is to use this technique from leisure teahouse

4. First of all, SQL can't realize case conversion. If you don't realize it, you can use stored procere
Second, to realize case conversion, you can take out the number of each bit from the high to the low of mathematics, convert it into upper case through array, and then add the unit. Form a string, such as 1020 form one thousand two hundred yuan. Create an array in advance, the first item of the array corresponds to one, and the second item corresponds to two
second processing, from the low bit to the high bit, finds the first non-zero bit, and then takes this bit as the starting point to reserve zero for all characters between this bit and the next non-zero bit.

5. Generally, it can't be charged directly. I need to go to a special platform for exchange. I didn't know how to shop before, and then I often go to the Wanji card game point card recharge platform for exchange~

6. Yes, of course. It just finished yesterday

7. The city of Brussels has a history of more than 1000 years

although there is no shocking scenery in Brussels, every scenic spot is worth savoring. If you're tired of going downtown, it's also a good choice to find a small shop on the street and have a waffle

8.

Hello, Zhonggong ecation is at your service

the current affairs and politics of Shandong civil service examination reference materials are continuously updated in 2013. I hope that the students who review the current affairs and politics hot spots in preparing for the examination can see our help. Thank you and wish you success in preparing for the examination

if you have any questions, you are welcome to ask the public ecation enterprises