Create Function dbo.uf_GetRs
(
@Year int
)
Returns Table
As
Return(
SELECT a.ID,a.RName
FROM Table1 a
Where Year(a.Date)=@Year)
如何在上面函数中加入下面内容
declare @BDate char(10)
set @BDate =@Year+'-01-01'最后把@Year用@BDate替换
(
@Year int
)
Returns Table
As
Return(
SELECT a.ID,a.RName
FROM Table1 a
Where Year(a.Date)=@Year)
如何在上面函数中加入下面内容
declare @BDate char(10)
set @BDate =@Year+'-01-01'最后把@Year用@BDate替换
解决方案 »
- 请教一下各位简单的Left Join问题??
- 求一个简单的SQL语句
- 老师们来看看,这个联合查询怎么查都查不出来。2个表,其中一个表是二级栏目的分类
- 误删了windows登陆名,现在完全登陆不上去了。。。
- 存储过程语句
- SQL2000中如何实现SHA1加密?
- 最佳组合问题 数据库中有一个产品表。产品有一个属性是point 然后会员也有一个point,有一个地方需要找出6个产品,他们point之和最接近于用户point
- 我的SQL库怎样通过网络莲接到服务器上的SQL?
- 两个小问题
- 连接不到到数据库。HELP!!急急急!
- 储存过程!!!高手请指教
- deny connect to database engine 和 disable login
(
@Year int
)
Returns Table
As
Return(
SELECT a.ID,a.RName
FROM Table1 a
Where Year(a.Date)=@Year+'-01-01' )
insert into Table1 select 1,'a','2008-01-01'
insert into Table1 select 2,'b','2008-11-29'
create Function dbo.uf_GetRs
(
@Year int
)
Returns Table
As
Return(
SELECT a.ID,a.RName
FROM Table1 a
Where convert(varchar(10),a.Date,120)=ltrim(@Year)+'-01-01') select * from dbo.uf_GetRs(2008)
ID RName
1 a
(
@Year int
)
Returns Table
As
Return(
SELECT ID,RName
FROM Table1
Where Date=@Year+'-01-01')
(
@Year int
)
Returns Table
As
Return(
SELECT ID,RName
FROM Table1
Where Date=rtrim(@Year)+'-01-01')
(
@Year int
)
Returns Table
As
Return(
SELECT a.ID,a.RName
FROM Table1 a
Where a.Date=cast(@Year as varchar(4))+'-01-01' )
(
@Year int
)
Returns Table
As
Return(
SELECT ID,RName
FROM Table1
Where Date=@Year+'-01-01')
Create Function dbo.uf_GetRs
(
@Year int
)
Returns Table
As
Return(
SELECT a.ID,a.RName
FROM Table1 a
Where a.Date=@Year+'-01-01' )
set @BDate =@Year+'-01-01' 最后把@Year用@BDate替换
create proc dbo.uf_GetRs
@Year int
as
declare @BDate varchar(10)
set @BDate =rtrim(@Year)+'-01-01'
SELECT a.ID,a.RName FROM Table1 a Where a.Date=@BDate
create table Table1(id int,RName varchar(50),date datetime)
insert into Table1 select 1,'a','2008-01-01'
insert into Table1 select 2,'b','2008-11-29'
create Function dbo.uf_GetRs
(
@Year int
)
Returns Table
As
declare @BDate char(10)
set @BDate =@Year+'-01-01'
Return(
SELECT a.ID,a.RName
FROM Table1 a
Where convert(varchar(10),a.Date,120)=ltrim(@BDate ))
Create Function dbo.uf_GetRs
(
@Year int
)
Returns Table
As
begin
declare @BDate char(10)
set @BDate =@Year+'-01-01'
Return(
SELECT a.ID,a.RName
FROM Table1 a
Where Year(a.Date) = @BDate ) end
go
直接加不就行了么
Create Function dbo.uf_GetRs
(
@Year int
)
Returns Table
As
begin
declare @BDate char(10)
set @BDate =convert(varchar(4),@Year)+'-01-01'
Return(
SELECT a.ID,a.RName
FROM Table1 a
Where Year(a.Date) = @BDate ) end
go
第 16 行: 'BEGIN' 附近有语法错误。
Create Function dbo.uf_GetRs
(
@Year int
)
Returns @temp Table (ID int, RName varchar(20))
As
begin
declare @BDate varchar(10)
set @BDate =rtrim(@Year)+'-01-01'
insert @temp SELECT a.ID,a.RName FROM Table1 a Where a.Date=@BDate
return
end
create proc dbo.uf_GetRs
@Year int
as
declare @BDate varchar(10)
set @BDate =rtrim(@Year)+'-01-01'
SELECT a.ID,a.RName FROM Table1 a Where a.Date=@BDate