Viewing 15 posts - 3,481 through 3,495 (of 5,103 total)
If the images do not change often then it may be OK and you can have a different backup strategy for it but if they do I think it may...
June 29, 2005 at 2:58 pm
June 29, 2005 at 2:54 pm
"Not likely, I'm only one of many good t-sqler here. I just happen to post more than the average"
That "more" should have been written in red bold italics...
June 29, 2005 at 2:39 pm
What SP level is that SQL Server. I think I've seen this before!!!
June 29, 2005 at 2:03 pm
Well, Kinda commandLine .NET - DOS Automation
June 29, 2005 at 1:46 pm
Just so you know there IS COBOL for .NET ... not necessarily that old ![]()
http://www.adtools.com/products/windows/netcobol.html
June 29, 2005 at 1:25 pm
Isn't this neater?
Select Category, TranCount, (TranCount * 100.0 / Total) AS TranCountPct
FROM
(SELECT Category, COUNT(*) AS TranCount
FROM TableName x
GROUP BY Category ) C
cross join
(SELECT COUNT(*) Total FROM TableName) T
June 29, 2005 at 1:20 pm
You could also use this and loop through all DB
http://vyaskn.tripod.com/sql_server_search_and_replace.htm
may be using sp_MSforeachdb ![]()
June 29, 2005 at 12:41 pm
This is a nice question for the MS folks, I am pretty sure most of us can't answer this one because it requires input directly from the actual developers/ Architects.
But...
June 29, 2005 at 11:32 am
Oh, and if my answer still does not convince you have a look at some of the difficuties that this guy had to undergo
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=194787
just to perform something very...
June 29, 2005 at 11:23 am
I don't know Pervasive DB either but I am pretty sure that the cast Construct is a MS proprietary thing. You should find out what are the functions used there...
June 29, 2005 at 11:18 am
Viewing 15 posts - 3,481 through 3,495 (of 5,103 total)