Forum Replies Created

Viewing 15 posts - 4,756 through 4,770 (of 18,926 total)

  • RE: That case filter

    bopeavy (7/20/2011)

    Ninja's_RGR'us (7/20/2011)

    --------------------------------------------------------------------------------

    Ninja's_RGR'us (7/20/2011)

    --------------------------------------------------------------------------------

    Toreador (7/20/2011)

    --------------------------------------------------------------------------------

    BenWard (7/20/2011)

    it affected 5 rows.

    or perhaps

    it returned "5 rows"

    Please Define "returned".

    Also affected might be too strong of a word here... no rows in datapages...

    July 20, 2011 at 7:12 am

    #1355570

  • RE: That case filter

    jcunningham (7/20/2011)

    Dah, thanks Ben. Sorry about that. What he was doing was passing in the condition through a variable. Here is the refined example.

    declare @foo as char(10),...

    July 20, 2011 at 7:10 am

    #1355567

  • RE: Indexes For Dummies

    Too large of a topic to cover all in here.

    http://www.sqlservercentral.com/articles/Indexing/68439/

    July 20, 2011 at 7:05 am

    #1355561

  • RE: Can we take a Backup of particular Table in a Database

    anil_kumar32 (7/20/2011)

    [font="Times New Roman"]

    How a table can be transfered from one file group to another file group??

    Regards,

    Anil K

    [/font]

    Recreate the clustered index on the new filegroup.

    July 20, 2011 at 7:04 am

    #1355558

  • RE: Exception handling with view creation

    arup chakraborty (7/20/2011)

    Hi Ninja,

    :):-) I have done the same way you have give. Actually just to enquiry is there any short cut or not.

    Thnaks ton,

    Arup

    No I think preventing here is...

    July 20, 2011 at 7:01 am

    #1355555

  • RE: That case filter

    Ninja's_RGR'us (7/20/2011)

    Toreador (7/20/2011)

    BenWard (7/20/2011)

    it affected 5 rows.

    or perhaps

    it returned "5 rows"

    😉

    Please Define "returned". :w00t:

    Also affected might be too strong of a word here... no rows in datapages were ever...

    July 20, 2011 at 6:49 am

    #1355545

  • RE: That case filter

    Toreador (7/20/2011)

    BenWard (7/20/2011)

    it affected 5 rows.

    or perhaps

    it returned "5 rows"

    😉

    Please Define "returned". :w00t:

    July 20, 2011 at 6:48 am

    #1355544

  • RE: That case filter

    OCTom (7/20/2011)

    😛

    It's good to know that even those will guru-like SQL Server knowledge make these types of mistakes. 😛

    This has happened to me (not this EXACT scenario) before. After looking...

    July 20, 2011 at 6:46 am

    #1355542

  • RE: That case filter

    jcunningham (7/20/2011)

    I had a developer telling me that his Where column like 'A%' was not returning all of the expected results. Took me forever to realize he was running...

    July 20, 2011 at 6:41 am

    #1355536

  • RE: That case filter

    calvo (7/20/2011)

    I noticed the extra UNION ALL and assumed the author got carried away with copy/paste.

    Exactly what happened when I first created the script... hence the start of the rest...

    July 20, 2011 at 6:39 am

    #1355534

  • RE: That case filter

    hakimali (7/20/2011)

    I consider most people on this forum SQL Gods and SQL Gurus (don't ask me who's who!), but in this case I have to say the question was improperly...

    July 20, 2011 at 6:34 am

    #1355530

  • RE: That case filter

    paul s-306273 (7/20/2011)

    OK, was the point of the question

    1 - to make us aware that we need to read things properly

    2 - to make the majority or readers look stupid

    or

    3...

    July 20, 2011 at 6:33 am

    #1355529

  • RE: That case filter

    Thomas Abraham (7/20/2011)

    Ninja's_RGR'us (7/20/2011)

    You're welcomed. So when's the last time you faced a similar issue like I did?

    I make mistakes all the time. People that type like I do...

    July 20, 2011 at 6:28 am

    #1355526

  • RE: potentially stupid question

    Yes you can.

    SS licenses are for the servers / database engines. Billy doesn't care that you have a tool on your laptop to connect remotely.

    P.S. Intellissence won't...

    July 20, 2011 at 6:22 am

    #1355518

  • RE: Exception handling with view creation

    arup chakraborty (7/20/2011)

    Hi Sartori,

    Thanks for the response. I am aware of that method but my question is, shall I put TRY-CATCH block inside the CREATE VIEW statement?

    Regards,

    Arup

    It's not the way...

    July 20, 2011 at 6:19 am

    #1355513

Viewing 15 posts - 4,756 through 4,770 (of 18,926 total)