My Blog List

hotinit.com. Powered by Blogger.

Search This Blog

Best way to write a dynamic querry

Wednesday, 29 June 2011

CREATE PROCEDURE sp_getUser

@username varchar(200) = NULL

AS

DECLARE @sql nvarchar(4000)

SELECT @sql = ' SELECT [name], [address] ' + 'FROM [USERS] Where [username]= ‘

SELECT @sql = @sql + ' [username] LIKE @username'

EXEC sp_executesql @sql, N'@username varchar(200)', @username

No comments:

Post a Comment

 

Blogger news

Blogroll

Most Reading

8.6/10