Forum Replies Created

Viewing 15 posts - 2,206 through 2,220 (of 15,381 total)

  • RE: sql2012 patch update

    Lavanyasri (10/8/2015)

    Hi all,

    i am planning to apply sql 2012 sp2 on cluster with mirror environment. please let me know how to do that .

    environment is 2 node and 4 node...

    October 8, 2015 at 2:06 pm

    #1832408

  • RE: apply sp3 on cluster server

    Lavanyasri (10/8/2015)

    Hi all,

    i am pallning to apply sql 2008 r2 sp3 on cluster with mirror environment. please let me know how to do that .

    environment is 2 node and 4...

    October 8, 2015 at 2:06 pm

    #1832407

  • RE: How to make Soundex functions include the first letter

    trapnell (10/8/2015)

    I need DIFFERENCE('Kolton','Colton') to equal 4 rather than 3.

    But SOUNDEX keeps the first letter of the word:

    SOUNDEX('Kolton') = K435

    SOUNDEX('Colton') = C435

    Does anyone know a workaround?

    Thanks,

    Tom

    Not really sure what you...

    October 8, 2015 at 10:25 am

    #1832352

  • RE: multi-part identifier could not be bound

    Dean Mincic (10/7/2015)

    I think that's ok to set the isolation level to READ UNCOMMITTED if you know what to expect.. dirty reads and all other side effects (personally I've never...

    October 8, 2015 at 7:17 am

    #1832279

  • RE: How to create a view dynamically thru a procedure

    immanuel2112 (10/7/2015)

    Hi,

    I tried to using the suggestion we have in this thread. But when executing it i am getting the 2 errors,

    1. Msg 156, Level 15, State 1, Line 4...

    October 7, 2015 at 3:35 pm

    #1832160

  • RE: multi-part identifier could not be bound

    cthorn112 (10/7/2015)

    Greetings Everyone,

    I scoured the forum and internet trying to figure out what is wrong with this query. Aside from it being hard on the eyes I cannot pin point...

    October 7, 2015 at 3:31 pm

    #1832159

  • RE: Syntax help please - How do I update a column with a sequence of numbers starting from 1

    Some ddl and sample data would help here but this should demonstrate one way of doing this.

    create table #HH835HP

    (

    SomeValue uniqueidentifier

    , ID_1 int

    , CHKDTS int

    );

    insert #HH835HP

    select top 10 NEWID(), ROW_NUMBER() over...

    October 7, 2015 at 3:16 pm

    #1832153

  • RE: Build search condition dynamic

    This has the trademark appearance of a catch-all query. You need to read this article about this type of query so you understand some options for performance. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

    October 7, 2015 at 7:27 am

    #1831988

  • RE: Spam Spam Bacon and Spam

    Dave Convery (10/5/2015)

    We're just looking at this now, but it's likely that it's just a URL structure that our spam filter hasn't learned yet. It should start to fade away...

    October 5, 2015 at 9:24 am

    #1831438

  • RE: Spam Spam Bacon and Spam

    Lowell (10/5/2015)

    agreed. they added code that insta-deletes anything Celko posts(thank you for that!), so they can reuse that same code, and just add something that detects the new user spamming...

    October 5, 2015 at 8:22 am

    #1831402

  • RE: Spam Spam Bacon and Spam

    Alvin Ramard (10/5/2015)

    Guess I'd better get another bottle of BBQ sauce. 😀

    I wish there was a way to get back at those spammers. They won't stop until it costs...

    October 5, 2015 at 8:06 am

    #1831394

  • RE: easy, very easy to answer

    Ed Wagner (10/3/2015)

    I worry if the stuff above is what they're teaching on the site you're using.

    I took a peek at the khanacademy site...holy cow the sql stuff is hideous....

    October 5, 2015 at 7:27 am

    #1831376

  • RE: easy, very easy to answer

    John Rowan (10/2/2015)

    I agree with Sean here that the use of TEXT datatype is not good here. Since they are using Text, Sean's query still will not work. ...

    October 5, 2015 at 7:24 am

    #1831375

  • RE: Replace chars in a string

    GrassHopper (10/2/2015)

    I have a GUI that displays the SQL queries that are built in the application. It is built in ms access using SQL Server Linked tables. There...

    October 2, 2015 at 3:39 pm

    #1831181

  • RE: easy, very easy to answer

    gcombina 73810 (10/2/2015)

    *** this is my second attempt ****

    SELECT mood, released, title FROM songs

    WHERE mood = "epic" OR released >1990;

    Because you have epic in double quotes. In sql server...

    October 2, 2015 at 2:52 pm

    #1831178

Viewing 15 posts - 2,206 through 2,220 (of 15,381 total)