tryCREATE PROCEDURE [query_myLoadDB] (@CompanyName [varchar](30),@ifWorker[bit])
AS
declare @SQL varchar(255)
if (@ifWorker=true)
select 付款单位 from mymain group by 付款单位
else
begin
set @SQL = "select 领票人 from " + @CompanyName + " group by 领票人"
exec @SQL
end
AS
declare @SQL varchar(255)
if (@ifWorker=true)
select 付款单位 from mymain group by 付款单位
else
begin
set @SQL = "select 领票人 from " + @CompanyName + " group by 领票人"
exec @SQL
end
解决方案 »
- 想要个免费的PDF417控件,开发环境为VB6.0,大家帮帮忙.
- 请问一个关于datagrid控件中记录颜色控制的问题,急,谢谢了先
- 上传FTP的问题
- 在何处实现类的继承?也就是在哪里进行编码?
- 怎么在vb中访问hosts文件?
- TextBox怎样扑捉焦点--------急急!!!再线等待?????????????
- 我下载了别人的控件想用,引用后提示我“该部件的许可证信息没有找到。在设计环境中,没有合适的许可证使用该功能。”
- 如何调整水晶报表的页面为横向?
- 新问题!急待解决!
- 谁能告诉我Commondialog如何同时打开文件?
- access的问题
- 我刚刚开始学习B/S结构的程序设计,请问各位哪里可以下载到这方面的资料?顺便散分。
select 领票人 from @CompanyName group by 领票人sql语句不能这样写的
declare @sql char
select @sql = 'select 领票人 from'+ @CompanyName+' group by 领票人'
CREATE PROCEDURE dbo.aa
@CompanyName varchar(30),
@ifWorker bit
AS
declare @sql char
if (@ifWorker=1)
select 付款单位 from mymain group by 付款单位
else
select @sql = 'select 领票人 from'+ @CompanyName+' group by 领票人'
go
CREATE PROCEDURE [query_myLoadDB] (@CompanyName [varchar](30),@ifWorker[bit])
AS
if (@ifWorker=1)
select 付款单位 from mymain group by 付款单位
else
select 领票人 from CompanyName group by 领票人
AS
declare @SQL varchar(255)
if @ifWorker = 1
select 付款单位 from mymain group by 付款单位
else
begin
set @SQL = 'select 领票人 from ' + @CompanyName + ' group by 领票人'
exec @SQL
end
关注,UP
go
CREATE PROCEDURE [query_myLoadDB] (@CompanyName [varchar](30),@ifWorker[bit])
AS
if (@ifWorker=1)
select 付款单位 from mymain group by 付款单位
else
begin
select @SqlString = N'select 领票人 from '
select @sqlString = @SqlString + @CompanyName
select @Sqlstring = @Sqlstring + N' group by 领票人'
exec sp_executesql @sqlstring
end
AS
declare @sqlstring nvarchar(500)
if (@ifWorker=1)
select 管理类型 from administer group by 管理类型
else
begin
select @SqlString = N'select 产品名称 from '
select @sqlString = @SqlString + @CompanyName
select @Sqlstring = @Sqlstring + N' group by 产品名称'
print @sqlstring
exec sp_executesql @sqlstring
end
CREATE PROCEDURE [query_myLoadDB] (@CompanyName [varchar](30),@ifWorker[bit])
AS
declare @SqlString nvarchar(500)
if (@ifWorker=1)
select 付款单位 from mymain group by 付款单位
else
begin
select @SqlString = N'select 领票人 from '
select @sqlString = @SqlString + @CompanyName
select @Sqlstring = @Sqlstring + N' group by 领票人'
exec sp_executesql @Sqlstring
end
exec @sql
sql语句是要拚着用的
'这样调用 myloaddb '0','c2',objname
On Error GoTo Err
Dim strL As String
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
With cn
.CursorLocation = adUseClient
.Open "Provider=SQLOLEDB;Server=" + ServerName + ";Database=myinvoice;Uid=sa;Pwd=" + ServerPassword + ";"
If ifWorker Then
strL = "query_myloaddb '0','" + strCompany + "'"
Else
strL = "query_myloaddb '1',' '"
End If
End With
myObj.Clear
With rs
.CursorLocation = adUseClient
.ActiveConnection = cn
'此处有错误提示:未能找到存储过程 'select 领票人 from c2 group by 领票人'
.Open strL
While Not rs.EOF
myObj.AddItem .Fields(0).Value
.MoveNext
Wend
End With
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
Exit Sub
Err:
ShowError
End Sub