Viewing 13 posts - 1 through 14 (of 14 total)
GilaMonster, thanks for the response. But I do not know how to do that. Can you show me a small example?
June 22, 2014 at 9:58 pm
What I wanted to do was instead of putting @num=@number,@typ=@type in
exec sp_executesql @sql,@params,@num=@number,@typ=@type
is it possible to put only those parameters that I want to put. Basically to reduce the...
June 22, 2014 at 9:56 pm
My question is, in the sp_executesql's parameter section (the last one), can I define the parameters dynamically? That is, I dont want to feed all the parameters but a selected...
June 22, 2014 at 4:45 am
Thanks! That was what I was looking for! I was not aware of catch-all queries previously.
June 21, 2014 at 8:36 pm
Any suggestions from anyone, please?
November 16, 2013 at 7:23 am
Thanks for the quick reply..... It worked with that
December 9, 2011 at 8:32 am
Thanks Gus...
But I only have SQL Server 2005, so I will have to work with it..... It has to be a web application, so I am trying to find a...
July 22, 2011 at 9:07 am
Thanks, and I get both your points.
I have one more related question.
Is it possible for me to search for occurrence of full stop (0x2E in varbinary) between two...
July 21, 2011 at 11:32 am
Hi,
From the above discussions, I understand that I will not be able to extract the text portion directly from the varbinary field. So, as a walk around, will it...
July 21, 2011 at 10:30 am
SOrry, my mistake.....
And thanks a lot, it works....
Now, I am trying for a method to point to this location in the document, when I open it in the front...
July 21, 2011 at 10:19 am
GSquared (7/19/2011)
Do you mean something like this?
DECLARE@VB VARBINARY(100) = CAST('This Is My String' AS VARBINARY(100)),
@Sub VARBINARY(100) = CAST('Is' AS VARBINARY(100));
SELECT CHARINDEX(@Sub, @VB);
Actually, no. I...
July 20, 2011 at 3:41 am
Hi Jeff,
I am in search of a similar solution for my FTS project. Can you please have a look at my query on "Freetext query to get surrounding portion...
July 19, 2011 at 11:51 am
I have a large number of documents in the db. So I don't think that is an option.
Anyone know any other options?
July 19, 2011 at 10:18 am
Viewing 13 posts - 1 through 14 (of 14 total)