Viewing 15 posts - 16 through 30 (of 310 total)
Is the truncation in Query Analyser or your app? If the former, check the Query Analyser setting in Tools/Options/Results tab/Max characters per column.
If you are returning a dataset, I...
January 9, 2008 at 1:57 am
no problem, Geoff. If you only need to check when the user is accessing a data area (eg customer details), then you only need to check the database as...
November 21, 2007 at 3:07 am
What latency can you afford? One solution is to poll the database at a suitable frequency from the external device. You only need to look for a flag...
November 21, 2007 at 2:27 am
I think we're still technology fixated - you don't need a pen drive or any other IT hardware to steal a few social security numbers or bank details - a...
November 16, 2007 at 6:30 am
There is no such thing as perfect security in any context, whether physical or data. All you can do is make it dificult for the less sophisticated bad guys....
November 16, 2007 at 1:56 am
Nobody can know all the syntax of any language - and anybody who claims they can probably is lying. Not test, yes - for problem solving ability and ability...
November 15, 2007 at 2:04 am
In 2005, this would be a perfect job for the CLR. Using the RichTextBox control seems the simplest as it has rtf and plain text properties. Write as...
October 25, 2007 at 1:42 am
ADO has a Date datatype which can be passed to a SQL Server parameter and works fine both from Visual Basic 6 and in C# and VB.NET. Presumably in...
October 11, 2007 at 3:40 am
If you are inputting your dates from a front end through ADO then you can and should pass dates as dates. If you must use strings then I always...
October 11, 2007 at 2:01 am
Having a relationship table makes it easy to maintain a history as you can give each record a start and end date and perhaps a status if relevant. This can...
August 29, 2007 at 1:54 am
I saw this recently. Scared me and haven't tested it but ...
August 17, 2007 at 2:09 am
To expand on Sugesh's post,
SELECT SUM(Column1) FROM MyTable would be OK because SUM() is an aggregate expression. SELECT Column1 + Column2 FROM MyTable is not OK because this is an...
July 17, 2007 at 1:52 am
There are some great threads on this site but this has to be one of the stars. A great explanation guys. Thanks.
July 11, 2007 at 1:59 am
Truncate isn't logged so, if you want logging (otherwise just truncate anyway - it's faster), delete first, then truncate.
June 8, 2007 at 1:45 am
Viewing 15 posts - 16 through 30 (of 310 total)