Forum Replies Created

Viewing 15 posts - 4,231 through 4,245 (of 5,356 total)

  • RE: Concatenation

    quote:

    Have tried this......DATALENGTH only return the length that I have set when formatting the fields which can of course be viewed in...

    August 15, 2003 at 6:17 am

    #470089

  • RE: Concatenation

    What I meant with fixed-length, is you normally use char data type, when you expect the stored values to be of the same length. When they vary in size you...

    August 15, 2003 at 4:51 am

    #470080

  • RE: Concatenation

    quote:

    Hmmm, wasnt aware of a LTRIM and RTRIM function in SQL..whats the syntax for that?

    LTRIM(expression)

    August 15, 2003 at 4:48 am

    #470079

  • RE: Concatenation

    Hi Andrew,

    quote:

    I have a field which is constructed of 4 other fields, all of value char. Below is the SQL statement Ive...

    August 15, 2003 at 4:38 am

    #470076

  • RE: Table Column Data_Type - int to English?

    Another trick could be to look at adovbs.inc, which also contains those enums

    Cheers,

    Frank

    August 15, 2003 at 4:27 am

    #470073

  • RE: Import Excel spreadsheet to .adp file

    quote:

    Are we? Shows how much I pay attention. Sorry alicejwz, my ignorance

    August 15, 2003 at 1:07 am

    #470067

  • RE: SQL Server script

    Hi Jac,

    well, this is just a wild guess.

    Can you create Mysql as linked server in SQL Server??

    BOL has an example linked server->access ODBC database

    After you scripted the db structure and...

    August 15, 2003 at 12:56 am

    #470064

  • RE: Import Excel spreadsheet to .adp file

    Hi alicejwz

    as far as I understand this you are trying to import to an existing table, right?

    I mean no table which content gets deleted regularly, but a table with...

    August 15, 2003 at 12:25 am

    #470062

  • RE: Reading the Tran Log

    Hi gfahrlander,

    quote:

    I seem to recall a way to read the transaction log without spending thousands of $$$ for a third party tool....

    August 15, 2003 at 12:08 am

    #470061

  • RE: ascii codesets

    Hi aruram,

    quote:

    Where can I find the ascii codes for different characters supported by various sql collations ?

    August 14, 2003 at 11:56 pm

    #470060

  • RE: What is the best way to change passwords

    Hi SQLBill,

    quote:

    I have some ideas now. I'm not sure ASP will work for me, I'll have to check into it more. I'm...

    August 14, 2003 at 11:48 pm

    #470059

  • RE: Do you think DBA is a desirable job?

    Hi, my friend Patrick,

    quote:

    Laughing. Someone who you vaguely know is an acquaintance. Like the guy down the block...

    August 14, 2003 at 11:39 pm

    #470058

  • RE: Do you think DBA is a desirable job?

    quote:

    Tschuss (did I spell that right?)

    almost! I think the small mistake is due to...

    August 14, 2003 at 11:32 pm

    #470057

  • RE: Reindexing the system tables

    Hi Gabor,

    just forwarding another reply

    ...

    Anyway, have you tryed to use the dbcc dbrepair option?

    I have tried it against a test DB:

    alter database sice set single_user

    go

    dbcc dbrepair('northwind', repairindex, syscolumns, 1)

    before...

    August 14, 2003 at 11:17 pm

    #470056

  • RE: Do you think DBA is a desirable job?

    quote:

    You can call me anything you like so long as you take pity on me when I post a problem with my...

    August 14, 2003 at 8:33 am

    #469968

Viewing 15 posts - 4,231 through 4,245 (of 5,356 total)