Viewing 15 posts - 10,516 through 10,530 (of 18,923 total)
I mean how are is it to prevalidate the data? You know the datatype and you know the lengh (or range of value) of the target table.
Len(ColName) will validate the...
December 19, 2006 at 9:35 am
Without reading that article, I have a situation here where a bit column is very indexable since this flag is on for about 25 to 125 rows out of 30...
December 19, 2006 at 9:26 am
Depending on the cost of the query, maybe you can do this in a stored proc :
DECLARE @OutputColumns AS VARCHAR(1000) OUTPUT
CREATE TABLE #temp
Insert into #temp
YourQueryHere
Then scan the resultSet
I'm not...
December 19, 2006 at 9:22 am
1 - HTML is used to format and display the data so it's common to all database systems. What you normally see with sql server is ASP, ASP.NET and C#.net. ...
December 19, 2006 at 9:12 am
It's not unsupported for no reason
(unless it changed in 2005).
December 19, 2006 at 8:43 am
Care to extend your comments on this one
?
"views generally don't perform very well anyway"
December 19, 2006 at 8:40 am
Maybe but I still don't get his idea.
I can manually replace the occurance of "<" to ">" to something else but I need to know how to do it faster. ...
December 18, 2006 at 2:24 pm
The forum will benefit much more from 2 prolific posters with 2 very different work experience than just one zelus poster.
Thanx for the help!
December 18, 2006 at 2:20 pm
NP.
So when are you scheduled for that public humiliation session?
December 18, 2006 at 2:08 pm
This article may be of particular interest to you :
December 18, 2006 at 1:37 pm
1 - Can more than one parameter be search at the same time, if yes what is the limit?
2 - How many parameters are passed to this procedure?
3 - Which...
December 18, 2006 at 1:36 pm
I have no idea of what you are trying to say... can you show a working example with this data?
DECLARE @x AS VARCHAR(8000)
SET @x = ' <table>test3<font>sometext</font>tex2</table>'
SELECT PATINDEX ('<[^<>]*>', @x)
December 18, 2006 at 1:32 pm
That could make sens.... but then again, I ain't receiving any birthday letter from any gouvernemental agency so I guess it may be for some other reason
December 18, 2006 at 1:23 pm
Viewing 15 posts - 10,516 through 10,530 (of 18,923 total)