Forum Replies Created

Viewing 15 posts - 31 through 45 (of 191 total)

  • RE: Order My Data

    CREATE UNIQUE CLUSTERED INDEX IDX_A ON #temp1(a,i)

    Did I miss the part that said the combination of a and i will be unique? It is in the given dataset,...

    December 2, 2013 at 5:56 am

    #1670089

  • RE: SOUNDEX

    I had to spend more time researching cursors than SOUNDEX. I've never used one in my life. Not sure I would have used one here either. Seems...

    November 26, 2013 at 9:12 am

    #1669191

  • RE: Orphaned users

    sknox (10/31/2013)

    The following T-SQL code creates database users which map to the Windows groups. Every member of those groups, when logging into SQL Server, will have the rights of those...

    October 31, 2013 at 6:54 am

    #1663030

  • RE: Orphaned users

    I clearly need some educatin' here. I'm very much not an administrator, so bear with me.

    "TestWindowsUser is in a domain group that is a member of db_owner and another...

    October 31, 2013 at 6:37 am

    #1663024

  • RE: ISNUMERIC(varchar)

    Hugo Kornelis (10/15/2013)

    As others have said, TRY_CONVERT in SQL Server 2012 fills that gap.

    Ah yes, I must have glossed over it due to the "2012" part. I try not to...

    October 15, 2013 at 2:56 pm

    #1658723

  • RE: ISNUMERIC(varchar)

    Hugo Kornelis (10/15/2013)

    ISNUMERIC returns 1 if the input can be converted to a numeric data type. It doesn't bother to tell you which data type.

    I've yet to discover what numeric...

    October 15, 2013 at 2:36 pm

    #1658715

  • RE: Try.. Catch..

    timwell (10/9/2013)

    Does this explanation from the MSDN forums answer the question?

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/258beea6-f797-4b28-9ba5-aec36b9bc3b2/error-handling-in-user-defined-functions?forum=transactsql

    "Transact-SQL errors [...] are treated differently inside a function. In functions, such errors cause the execution of the function...

    October 9, 2013 at 11:19 am

    #1657239

  • RE: Try.. Catch..

    Narud (10/9/2013)

    Nice question. I knew the answer because I tried to use try/catch inside an UDF a few months ago. 🙂

    "Hey, I've got an idea! Oh... no I don't."...

    October 9, 2013 at 8:47 am

    #1657191

  • RE: Try.. Catch..

    I only knew the answer because I'd tried it before. Since the ISNUMERIC() function is fundamentally broken, I tried creating a function that would actually try to cast the value...

    October 9, 2013 at 6:38 am

    #1657114

  • RE: Executing Dynamic SQL

    Toreador (9/26/2013)

    I knew it was going to fail due to the data type, but any of the options was feasible so it came down to a guess as to which...

    September 26, 2013 at 6:00 am

    #1653510

  • RE: Between & Collation

    Ed Wagner (8/29/2013)

    In the ASCII character set [...] A is 65 while a is 97. To have them sort differently here is somewhat counter-intuitive [...].

    Don't get me wrong here,...

    August 29, 2013 at 8:26 am

    #1646009

  • RE: How does SQL pronounce SQL?

    Hugo Kornelis (6/30/2013)

    ronmoses (6/28/2013)

    It doesn't strike me as a particularly useful function, especially given these examples:

    SOUNDEX and DIFFERENCE can be useful, but you have to know their specifications. Here is...

    July 1, 2013 at 5:54 am

    #1628667

  • RE: How does SQL pronounce SQL?

    Hugo Kornelis (6/30/2013)

    So the title of the post is misleading

    Not intentionally so, of course 🙂

    Thank you for the added information, those results make perfect sense now.

    ron

    June 30, 2013 at 11:31 am

    #1628558

  • RE: How does SQL pronounce SQL?

    BarneyL (6/28/2013)

    While I wouldn't trust the results without checking them by eye (or expect all cases to be found) DIFFERENCE can be used as a quick and dirty way of...

    June 28, 2013 at 9:05 am

    #1628322

  • RE: How does SQL pronounce SQL?

    It doesn't strike me as a particularly useful function, especially given these examples:

    SELECT SOUNDEX('cent') --C530

    SELECT SOUNDEX('scent') --S253

    SELECT DIFFERENCE('cent','scent') --2, a very weak match

    SELECT SOUNDEX('through') --T620

    SELECT SOUNDEX('threw') --T600

    SELECT DIFFERENCE('through','threw') --3,...

    June 28, 2013 at 6:37 am

    #1628275

Viewing 15 posts - 31 through 45 (of 191 total)