Forum Replies Created

Viewing 15 posts - 4,681 through 4,695 (of 7,429 total)

  • RE: Forcing SQL delete SA user, and create a new user

    And use oddball characters as this makes the hash encryption crack a less likely to succeed.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...

  • RE: Reporting from a continuosly populating table

    When you ask

    quote:


    How should I acheive a on line accurate reporting mechanism using this table ?

    Any workaround ? apart from automated...

  • RE: SCHEMABINDING on a View that UNIONs across DBs?

    Actually have you considerd using a Stored Procedure instead. You can pass parameters to take advantage of the underlying indexes for each databases table. VIews do this already but occasionally...

  • RE: Need to force proper case of sentence

    That or if you want and I can find. I started on an SP/Function that did proper case that would take into account things such as O'Hare instead of O'hare...

  • RE: SQL 7 Maintenance Plans

    Now Steve, what's the deal here. I know I have seen you in dozens of these conversations and quite honestly, I script my maintainence myself. However, bad experiences were had...

  • RE: Need to seperate fname and lname

    As long as you are sure that it is only first and lastname in the data the use CHARINDEX to find ' '. Once you know the position of the...

  • RE: Primary Key in a Table

    Then you are correct there is no absolutly need to add the extra column for another identity value if you will only have the one row for T_ID in the...

  • RE: Oracle Data Type not supported

    You will need to change instead to using the Oracle OLEDB provider instead. Microsoft quit making updates to the MS version and thus some datatypes are not supported by the...

  • RE: Comparing varchar datatypes with values like x.x.x

    Ok I will assume 6 is you major, .6 is your minor, and .667 is you revision. Try this.

    If minor has to be only 1 character in size and revision...

  • RE: WHAT TO WITH ALL THESE CODES?

    Can you explain your database to me and what the data is for each type, how they relate what you are doing.

    "Don't roll your eyes at me. I will tape...

  • RE: I may be asking for the world, but...

    Well, without knowing of any other application like that you probably could build something that could do quite easy depending on how the VB code is put together. Also, if...

  • RE: Primary Key in a Table

    First off Primary Key is defined as a column with unique values. If T_ID will have repeating values SQL will not allow you to use it, at least not by...

  • RE: Conditional Default constraints

    Only thru where insert code is done or thru a trigger. However you could make a column for the data to be instered without the default and then add a...

  • RE: Truth about Oracle and MSSQL...Help needed

    Read and completely agree with Chris, and I like the other article. The key is both have there strong point and there week points, it is just a matter of...

  • RE: Truth about Oracle and MSSQL...Help needed

    Thanks, I will take a look when I get a chance and feedback.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 15 posts - 4,681 through 4,695 (of 7,429 total)