Information générale
Titre:
Dynamic Where in Stored procedure
Hi,
The question is more about SQL Server.. but.. maybe someone help :)
I have a stored procedure which return resultset..
As interface I have search string which must provide fulltext search... in the code I build WHERE rule from search string and want to pass it to stored procedure..
Can anyone show me example is it possible to use sp parameter
AS
@wherestatement STRING in the stored procedure
Of course I can build the SQLExpression in my code and then using sqlcommand return resultset. but way with stored procedure helps me to bind storedprocedure resultset to Linq class and Linq class - bind to the datasource of the grid.
Thanks for help
Denis
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement