Default image in a table at creation time
-
Hi,
Can we insert a default value which is of the type image in a column of a table while creating that table.?
Thanx
-
Never heard of this before, so consider this only an educated guess.
I don't think you can use the usual DEFAULT on such a column. I guess you have to code additional logic to achieve what you're after.
But then again, maybe someone else has tried this before...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
we've done this before -
basically you have to create a trigger on insert for the table - if the datalength of the IMAGE field is 0 then call a VBSCRIPT package using ADO commands to append chunks to the image field.
bit of a fudge, but we found that was the best way to do it.
MVDBA
-
Mike,
is there a specific reason why you state
"In the UK get ..." ?
Just curious, why not elsewhere.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
because it's a dial up or onsite service offered by our company to identify possible problems or areas of improvement.
international phone calls and flights tend to be a little more expensive. However i'm sure if as a support agency we were asked to fullfill a support contract in the US or europe we could provide the same service.
the healcheck itself is a series of T-SQL scripts that analyses fragmentation, security, database design, free space, server statistics,integrity,table space, memory usage, service packs etc etc etc to give a snapshot of your server configuarion at a set point in time.
it pumps all of this out to pretty HTML pages with navigation and a set of manually written recommendations.
MVDBA
-
Aha, may I ask what the difference to the Best Practice Analyser is?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
it covers most of the things in the BPA, and the baseline security analyser, but also a few other things all in one package.
with the manually written recommendations it also provides details on future planning and takes into consideration business setups where they just plain can't afford more hardware. basically it's a lot less arbitrary than a fully automated tool.
It's designed to give junior DBA's, project managers and business users some understanding of the problems they are facing or don't know about. Then they can provide the adequate resources to deal with the issue.
It's for companies where they don't have the resources to have a permanent DBA, or the DBA is really an exchange or NT specialist (or god forbid a C++ developer). For an experienced High level DBA the healthcheck does little more than catalogue the server status and raise any undiscovered issues (like the BPA) at that point.
it also works on SQL 6.5,7,2005 express beta2 (and hopefully 2005) which BPA doesn't (yet)
It's still a work in progress as new mods are added all the time(procedural cache analysis etc etc), but due to the compactness of the code (282kb after winzip) you can take it anywhere on a floppy and deploy it on a customers server.
MVDBA
-
Thanks for that in depth explanation, Mike.
Hey, you're showing your age, when you know what a floppy is
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
hey i'm not that old!!
but i'm findig these QWERTY keyboard things a bit awkward compared to puch cards and kimball tags
MVDBA
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply