HotFrost
Last Activity: Sep 18 '08, 01:34 PM
Joined: Nov 29 '06
Location:
-
it did the trick. Thank you! -
The inserted and deleted tables are empty ? (trigger operation)
Hello everyone,
i am trying to work with linked servers...
The local server is the one used by UPS worldwide software (it is Microsoft SQL Server Desktop Engine, v 8.00.2050). The linked server is 2005 MS server.
on update/insert event for some table i hooked up the trigger that connects to linked server and updates the record in some DB.
To test, i create a stored procedure that updates... -
wild characters in stored procedures with parameters?
Hello everyone,
i wonder if someone can give me some idea how and what is the right way to use wild characters in stored procedures with parameters...
Assuming that
@searchs_text is the parameter...
this:
WHERE last_name LIKE '%' + @search_text + '%'
seems does NOT work..
any help in this matter will be greatly appreciated.
thank you!
No activity results to display
Leave a comment: