Forum Replies Created

Viewing 15 posts - 10,966 through 10,980 (of 13,460 total)

  • RE: Bug in CHARINDEX ?

    virgil i hope this might help: fiddling wiht TEXT fields is tough...here's a procedure i wrote to do find and replace in TEXT fields. I know this works on huge...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 16, 2009 at 9:17 am

    #1010268

  • RE: Adding a tip to a hyperlink

    i think what you want is to add the "title" attribute to your a href tag.

    Click Here.

    looks like this:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 16, 2009 at 8:54 am

    #1010246

  • RE: Convert RTF data

    wow i could make an article on SSC over this...lots of questions below got my thoughts flowing.

    VB6 can be used, but it was l8imited to 8000 chars due to the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 16, 2009 at 6:32 am

    #1010124

  • RE: How to redirect a port in sql server

    I'm not sure you have your arms around how SQL server uses ports.

    SQL server cannot listen to multiple ports. one port per instance default is 1433, as you know, and...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 15, 2009 at 10:39 pm

    #1010018

  • RE: Convert RTF data

    Oleg I'm glad you found a solution here. this thread started back in 2005, and has produced a lot of great ideas and solutions. people find it and it often...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 15, 2009 at 4:12 pm

    #1009949

  • RE: alphabetical vs. chronological order

    chburns (6/15/2009)

    I am having a problem returning records in sql. I am trying to retrieve the first record in a table (chronologically), but when I use a min function...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 15, 2009 at 9:32 am

    #1009730

  • RE: Can select from db (read) but cannot write

    Dorian Gray (6/15/2009)

    I am at my wits end - any help will be appreciated. I have a tester connecting to a SQL2K5 db installed on my pc at work...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 15, 2009 at 9:25 am

    #1009727

  • RE: Can select from db (read) but cannot write

    oops double post sorry folks...continue below

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 15, 2009 at 9:25 am

    #1009726

  • RE: How to redirect a port in sql server

    if your developers are on the same network, then I don't believe it can be done.

    each instance of SQL server listens to one port...no problem.

    a router can take traffic from...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 15, 2009 at 6:17 am

    #1009583

  • RE: How to redirect a port in sql server

    guptaajay1985 (6/15/2009)

    Then why we use alias can anyone clarify

    alias? I'm not clear on your question. which alias are you referring to?

    You might use port forwarding because you have 10...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 15, 2009 at 5:41 am

    #1009565

  • RE: How to redirect a port in sql server

    port forwarding is not handled by SQL Server, it is typically handled by a router that establishes the firewall between your internal network and the internet.

    here's a screen shot of...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 15, 2009 at 5:20 am

    #1009558

  • RE: Inserted records with a subsequence number

    An Identity column will not meet your requirement, since you need it to reset back to 1 with each claim number.

    as you've probably already found, there's no inbuilt way...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 14, 2009 at 7:25 am

    #1009293

  • RE: Lost Data! Can I query for what happened?

    Object:Deleted would be the dropping of a table, foe example. the default trace only tracks object level events: CREATE/ALTER/DROP of database objects (DDL)

    you would need a DML trace(Data Manipulation)

    I'm adding...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 12, 2009 at 10:41 am

    #1008806

  • RE: Does SQL Server 2000 has a 'WITH' CLAUSE

    do you mean using the WITH clause with a Common Table expression, or do you mean where you use the WITH clause to use a hint, like WITH(TABLOCKX)?

    a CTE would...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 12, 2009 at 10:09 am

    #1008781

  • RE: Specific Update???

    I think you have two choices; raise an error like you were planning, but you could also use an INSTEAD OF trigger, and ignore any changes to the ID column,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 12, 2009 at 10:01 am

    #1008775

Viewing 15 posts - 10,966 through 10,980 (of 13,460 total)