Viewing 15 posts - 16,141 through 16,155 (of 18,926 total)
Please do not cross-post, we monitor all boards.
Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=194832
June 28, 2005 at 10:23 am
Yes, but you can always grant access to the application only to view and insert new file/directory, not to delete them. That way you minimize the risk of errors.
June 28, 2005 at 10:20 am
I still have to see a situation where I need to do this. I'm sure it's gonna happen, but maybe not this year
June 28, 2005 at 10:11 am
check this out for more information on this method and why you shouldn't use it :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=189202
Also this may run faster if attribute_id is indexed :
declare @v1 int
set...
June 28, 2005 at 10:06 am
You can't update a text column like this, while I can't show you how I can tell you to go link into the books online for more information.
June 28, 2005 at 10:00 am
HTH.
June 28, 2005 at 9:59 am
Thanx. Looks like an index seek is just out of the question here, so the simplest conversion wins
.
June 28, 2005 at 9:52 am
I still need the sample data from the base table to rebuild the correct query.
June 28, 2005 at 9:44 am
This would denormalize the db, you simply need to select the data correctly when presenting it using inner joins. There's no need the ship all this data in the...
June 28, 2005 at 9:42 am
I thaught the other experts would provide more help than that
.
June 28, 2005 at 9:39 am
"And, since we don't have function indexes in SQL Server as in Oracle, it would be a rather unpleasant thing..."
This isn't 100% accurate :
IF Object_id('Employes2') > 0
DROP TABLE Employes2
GO
IF...
June 28, 2005 at 9:37 am
it's a good idea but it doesn't seem to work :
Select
cast('2005-05-02 14:56:52.493' as smalldatetime)
, cast ('2005-05-02 14:57:03.447' as smalldatetime)
, convert(varchar(16),'2005-05-02 14:56:52.493',20)
, convert(varchar(16),'2005-05-02 14:57:03.447',20)
2005-05-02 14:57:00
2005-05-02 14:57:00
2005-05-02 14:56
2005-05-02 14:57
June 28, 2005 at 9:34 am
You'll be better off in .net. The string manipulation is much easier there.
June 28, 2005 at 9:30 am
Viewing 15 posts - 16,141 through 16,155 (of 18,926 total)