Article View: cn.bbs.comp.database
Article #920Re: ���ʴ洢��̲�����ִ�Сдô��
From: Galaxy��VOLUNTEERS
Date: Sat, 02 Aug 2008 04:00
Date: Sat, 02 Aug 2008 04:00
34 lines
2366 bytes
2366 bytes
����Բ�һ�����stored procedure��collation
�Ҽ�-��properties-��extended properties-��collation
�ҵ�ij��stored procedure��collationΪLatin1_General_CI_AS_KS_WS
����������ı����
�磺
����Chinese_PRC_CS_AI_WS
ǰ�벿�ݣ�ָUNICODE�ַ�Chinese_PRC_ָ��Դ�½������UNICODE���������
�������ĺ�벿�ݼ��� ���壺
����_BIN ����������
����_CI(CS) �Ƿ���ִ�Сд��CI����֣�CS���
����_AI(AS) �Ƿ����������AI����֣�AS��֡�����
����_KI(KS) �Ƿ���ּ�������,KI����֣�KS��֡�
_WI(WS) �Ƿ���ֿ�� WI����֣�WS��֡�
�� �� shaqlala (Kobe) �Ĵ������ᵽ: ��
: create PROCEDURE [dbo].[aspnet_UsersInRoles_FindUsersInRole]
: @ApplicationName nvarchar(256),
: @RoleName nvarchar(256),
: @UsernameToMatch nvarchar(256)
: .......................ʡ������
: ������ڵ���ʱ�ڶ�������д����roleName���ͻ��Ҳ�����������û�����ƵĶ�Ϊ
: ���⣿
: ���õ���SQLServer 2005Express
--
I thought what I'd do was, I'd pretend I was one of those deaf-mutes
Or should I?
You know what I��d like to be? I mean if I had my goddam choice, I��d just be
the catcher in the rye and all.
[m[1;33m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.145.15][m
Technical Details
Message-ID:
<4bIDYC$bSh@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,9caca569015649c8 X-Google-Attributes: gid101948,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS) Newsgroups: cn.bbs.comp.database Subject: Re: ���ʴ洢��̲�����ִ�Сдô�� Date: 02 Aug 2008 04:00:56 GMT Organization: ��ˮ˼Դ Message-ID: <4bIDYC$bSh@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1217649516.A Lines: 33