🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: cn.bbs.comp.database
1 messages
1 total messages Started by Galaxy��VOLUNTEERS��Database Sun, 24 Jan 2010 11:04
Re: ���ʹ���dynamic sql ������
#249
Author: Galaxy��VOLUNTEERS��Database
Date: Sun, 24 Jan 2010 11:04
21 lines
1779 bytes
�������ǰ�@stu_Name��Ϊ�ַ�������
����������ŵ��������
�� �� raulyin (aabbcc) �Ĵ������ᵽ: ��
: ������һ��ѧ��ɼ��?��Ҫ��ÿ��ѧ��ijɼ���ȡ�������������һ�ű?������־�
: ��ѧ������֡�����google֮���Լ�����д��һ�����µĴ���
: DECLARE @Vstu_Name nvarchar(50)
: DECLARE @SQLString nvarchar(max)
: DECLARE @ParmDef nvarchar(max)
: /*Build the SQL query*/
: SET @SQLString = 
:    N'SELECT *
:        INTO [TrafficData].[dbo].[@stu_Name]
:        FROM [TrafficData].[dbo].[TestGrade]
: .................������ʡ�ԣ�

--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.194.37]
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads