Forum Replies Created

Viewing 7 posts - 1 through 8 (of 8 total)

  • RE: SQL server SORT order problem

    To clarify, by 'contrary ascii code', I meant not respecting the ASCII binary values, which is demonstrated by my code snippet so does yours. Thanks for the confirmation!

    Cullen

    Dare to Question -- Care to Answer

    Time is like water in a sponge, as long as you are willing you can always squeeze some.

    --Lu Xun, Father of Modern Chinese Literature

  • RE: Field choice questions

    Thanks very much!

    Cullen

    Dare to Question -- Care to Answer

    Time is like water in a sponge, as long as you are willing you can always squeeze some.

    --Lu Xun, Father of Modern Chinese Literature

  • RE: Field choice questions

    Thanks GSquared,

    Timestamp field will be around, right?

    create table Test (

    ID int identity primary key,

    rowversion Timestamp, -- Is this how it should be used in...

    Cullen

    Dare to Question -- Care to Answer

    Time is like water in a sponge, as long as you are willing you can always squeeze some.

    --Lu Xun, Father of Modern Chinese Literature

  • RE: Field choice questions

    Thanks GSquared!

    The document talks about "timestamp syntax for rowversion data type" being deprecated. Can you enlighten me as to what timestamp syntax is?

    Cullen

    Dare to Question -- Care to Answer

    Time is like water in a sponge, as long as you are willing you can always squeeze some.

    --Lu Xun, Father of Modern Chinese Literature

  • RE: Field choice questions

    Thanks Steve, K. for the comments/suggestions.

    Is there any danger of of varchar or char data type being dropped in future releases of MSSQL as image, ntext and text types are?

    Cullen

    Dare to Question -- Care to Answer

    Time is like water in a sponge, as long as you are willing you can always squeeze some.

    --Lu Xun, Father of Modern Chinese Literature

  • RE: Best practice in Saving, Deleting and Updating Data

    Thanks Jo for link as well as list. Truely appreciate it!

    Cullen

    Dare to Question -- Care to Answer

    Time is like water in a sponge, as long as you are willing you can always squeeze some.

    --Lu Xun, Father of Modern Chinese Literature

  • RE: Best practice in Saving, Deleting and Updating Data

    Joe,

    Thanks for the reply!

    Is there any article anywhere that warns about pitfalls that are not documented in books online?

    Or a best practice in SQL database programing?

    Cullen

    Dare to Question -- Care to Answer

    Time is like water in a sponge, as long as you are willing you can always squeeze some.

    --Lu Xun, Father of Modern Chinese Literature

Viewing 7 posts - 1 through 8 (of 8 total)