Windows LiveWindows Live™

Zheng CHEN

BI开发 in 纽约_华尔街(wall St.)

 

Zheng isn't in your network.  Add Zheng

What's new with Zheng

Oct. 5
Zheng joined Yun Xu's network | Add Yun Xu to your network
Sept. 14
Zheng changed occupation to BI开发
Aug. 14
Zheng joined kerryqg19's network | Add kerryqg19 to your network
Aug. 4
Zheng added a blog entry sqlserver中if语句的使用
"declare @A int declare @B int select @A = ... select @B = ... if @A = 1   select @A = 12   select @B = @B-1  (注：此句报错，无法执行) else   select @A = @A-1 逐将语句改为： if @A..."
Aug. 3
Zheng added a blog entry 列出Server上5张最大的表
" 列出Server上5张最大的表         遍历所有数据库，但不包括系统数据库。列出表所在数库名，表名，表的大小，表的记录数。非常有趣，T-SQL 看下面： 1: create table #t(d nvarchar(MAX),t nvarchar(MAX),r int,x nvarchar(100),..."
Aug. 3
Zheng added a blog entry SQL 数字转换英文函数
" SQL 数字转换英文函数 CodeUSE [WWERP]GO/****** 对象:  UserDefinedFunction [dbo].[fun_currencyENG]    脚本日期: 08/02/2009 15:58:03 ******/SET ANSI_NULLS ONGOSET QUOTED_IDE..."
July 27
Zheng added a blog entry INFORMIX中去掉和恢复数据库写日志的方法
"   1、去掉数据库写LOG，目的是为了加快导入海量数据速度。$>ontape -s -N db_name   --修改为无日志模式   数据库不含日志，即不支持事务，对数据库的任何修改都不会记录到逻辑日志中去2、恢复数据库写LOG$>ontape -B -s db_name   --修改为buffer_log  ..."
July 24
Zheng joined Miss Gabriella's network | Add Miss Gabriella to your network
July 17
Zheng added a blog entry 不显示删除回复显示所有回复显示星级回复显示得分回复 sql同表级联更新
"VB+SQL2000 数据库内容 ID 型号ID  型号  原材料ID  原材料名称 比例  价格  金额 1  C101    MM101  Y101      RMC      0.5    10    5 1  C101    MM101  Y102      RTF      0.5    18    9 2 ..."
July 17
Zheng added a blog entry 将一个文本文件导入数据库，采用OPENROWSET方法
"目的：将一个文本文件导入数据库，采用OPENROWSET方法 问题： 1、文本文件的分隔符是"    ",要把这个大空格替换成“，”号读入数据库后才可以分开各个列，否则显示为一列。怎样解决？ 2、文本文件中有一列是“账号”，该列在文本文件中显示为：010015320000094801，但读入数据库后变成科学记数法，显然..."
More updates
 

Notes (3)

Please wait...
Sorry, the note you entered is too long. Please shorten it.
You didn't enter anything. Please try again.
Sorry, we can't post your note right now. Please try again later.
To post a note you need permission from your parent. Ask for permission
Your parent has turned off notes.
Sorry, we can't delete your note right now. Please try again later.
You've exceeded the maximum number of notes that can be posted in one day. Please try again in 24 hours.
Your account has had the ability to post notes disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
Complete the security check below to finish posting your note.
The characters you type in the security check must match the characters in the picture or audio.

To post a note, sign in with your Windows Live ID (it's your Hotmail, Messenger, or MSN account). Sign in


Don't have a Windows Live ID? Sign up
刘 迪wrote:
wats up
Sept. 14
小琼 李wrote:
恭喜~
May 10
斌wrote:
加油，好运就要降临在你身上了，坚持住！祖国人民支持你
Feb. 20