Executes a Transact-SQL statement or batch that can be reused many times, or one that has been built dynamically. The Transact-SQL statement or batch can contain embedded parameters.
Syntax:
EXECUTE sp_executesql
N'SELECT * FROM Book
WHERE BookID= @bookid',
N'@bookId int',
@bookId= 100;
Syntax:
EXECUTE sp_executesql
N'SELECT * FROM Book
WHERE BookID= @bookid',
N'@bookId int',
@bookId= 100;
No comments:
Post a Comment