Help with dynamic sql - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Help with dynamic sql

Author

Topic

KenA
Starting Member

28 Posts

Posted - 2006-08-12 : 22:45:47

I´m trying to make this sql work:

alter procedure usp_dvds_selectbyfirstletter
(
@letter char(1)
)
as
begin
select * from dvds where bands like ' ''' + @letter + '%' + ''''
end

When I run usp_dvds_selectbyfirstletter 'a'

Nothing is returned???

»»» KenA

nr
SQLTeam MVY

12543 Posts

Posted - 2006-08-12 : 22:53:16

isn't dynamic sql

alter procedure usp_dvds_selectbyfirstletter
(
@letter char(1)
)
as
begin
select * from dvds where bands like @letter + '%'
end

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources