Article View: cn.bbs.comp.database
Article #1918Re: ��SQL����һ����ı�������ôд��
From: �����������
Date: Wed, 14 Sep 2005 15:30
Date: Wed, 14 Sep 2005 15:30
30 lines
1990 bytes
1990 bytes
������web��Ӧ�ó���������ݴ洢����������
��������Զ���洢��̣�����sql server(����֧�ִ洢��̵�DBMS����)Ϊ��������˵�����������ƴ洢��̣�
//*********************
use ��ݿ���
go
create procedure ChangeTableName
(
@OldName varchar(30),
@NewName varchar(30)
)
as
EXEC sp_rename @OldName, @NewName
go
//#############�����洢��̽���
Ȼ����Ϳ����������κ�Ӧ�ó���������ָ���ı����ˣ����������ᵽ����
master��ݿ������ע����ݵĹ����Ͳ������ˣ���Ϊϵͳ�洢��̻��Լ��㶨�ġ�
�� �� yytoday (��!!) �Ĵ������ᵽ: ��
: ����һ��SQL���
: лл
--
[m[1;35m�� ��Դ:�����Ļ����� bbs.cqupt.edu.cn��[FROM: bbs.cqupt.edu.cn][m
Technical Details
Message-ID:
<4KBldk$Z1a@bbs.cqupt.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsfeeder.wxs.nl!news-out2.kabelfoon.nl!newsfeed.kabelfoon.nl!bandi.nntp.kabelfoon.nl!202.194.15.150.MISMATCH!bbsnews.sdu.edu.cn!news.uestc.edu.cn!CQUPTShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,7f3545abf366f22 X-Google-Attributes: gid101948,public X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsfeeder.wxs.nl!news-out2.kabelfoon.nl!newsfeed.kabelfoon.nl!bandi.nntp.kabelfoon.nl!202.194.15.150.MISMATCH!bbsnews.sdu.edu.cn!news.uestc.edu.cn!CQUPT From: ask@bbs.cqupt.edu.cn-SPAM.no (���������ε���) Newsgroups: cn.bbs.comp.database Subject: Re: ��SQL����һ����ı�������ôд�� Date: 14 Sep 2005 15:30:51 GMT Organization: ���Ļ����� Message-ID: <4KBldk$Z1a@bbs.cqupt.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: DataBase/M.1126710910.80 Lines: 30