Forum Replies Created

Viewing 15 posts - 5,116 through 5,130 (of 5,356 total)

  • RE: How to pronounce SQL

    Hi to all,

    quote:


    Obviously America is the king of the acronymn world. I seem to remember that one of the US Navy...

  • RE: Storing Document (xls) in tables

    Hi Joseph,

    agree with Andy. Blob's aren't always bad, though sometimes it seems to me like a philosophical question whether to store binary data in a db or on the file...

  • RE: How to keep and restore the deleted records?

    Hi ljmonteiro,

    quote:


    a5xo3z1 use a "status" field ( I add also a timestamp , and a user field ). But adding a column...

  • RE: link

    Hi Bavineni,

    quote:


    Is there any site like this for java/c++.


    Antares686 reminded me of http://www.codeguru.com. for C++.

    If...

  • RE: auto grow

    Hi jrose,

    quote:


    Just to verify - Does the Date Time Modified only get updated when an Auto Grow takes place or when the...

  • RE: scheduling stored procedure

    Create a job

    Add a step

    Name it what you like

    type Transact-SQL Script

    choose appropriate db

    type 'EXEC sp_name'

    schedule it to run daily at your time

    Cheers,

    Frank

  • RE: PM's/Management Vs DBAs

    Hi Patrick,

    quote:


    I have worked with several project managers who maintained this facade of not dealing with the day-to-day grind of actually writing...

  • RE: Text/Image Datatype in Stored Procedure.

    Hi ramesh_kondaparthy,

    DECLARE @text varchar(8000)

    SELECT @text=<your_textfield> FROM <table>

    Now you should do your manipulation

    At the end there (should?) be a UPDATE <table> SET <textfield> = @text

    I'm not quite sure on this for...

  • RE: auto grow

    Hi DRBuckingham,

    quote:


    Also, the date/time stamp of the files change when you stop/start your SQL Server (or a reboot occurs).


  • RE: Ad-Hoc Queries - Access or SQL Scripts

    I think going the way to first learn to hand code and then move to something visual is better then vice versa. Take away the visual tools and see who...

  • RE: Forum Stats

    Hi dbaguy,

    quote:


    We keep the member list page deleted because we don't want our members to be spammed by a program that scans...

  • RE: Evaluating a string arithmatic expression

    This is getting really interesting.

    We should make a competition from it. Who's next?

    Cheers,

    Frank

  • RE: ADO timeout

    I increased the default value only in a small self-made tool that stores (large) binary data into one certain db. If filesize gone beyond ~5-6 MB I ran into timeout...

  • RE: ADO timeout

    Hi hoodg,

    MSDN says default value is 15 seconds for connection Timeout (CommandTimeout = 30 seconds).

    Maybe you need to increase also CommandTimeout like this

    With cnnAttach

    .CommandTimeout = your...

  • RE: Evaluating a string arithmatic expression

    Hi David,

    quote:


    Hey try this surreal solution. I doubt perfomance would justify it.


    your solution has indeed...

Viewing 15 posts - 5,116 through 5,130 (of 5,356 total)