Forum Replies Created

Viewing 15 posts - 1 through 15 (of 793 total)

  • Reply To: Searching Strings

    In the explanation, to be precise, I would change "where the first number is not a 9"

    with "where the first char is not a 9"

  • Reply To: The SQL Variant Types

    Good catch!

    It is Interesting that NULL never has a BaseType, also if you cast it to a defined type (e.g. INT).

    SELECT *
    ,LEN(V.a)
    ,dataLENgth(V.a)
    ,SQL_VARIANT_PROPERTY(V.a, 'BaseType')
    FROM (VALUES
    (N'1')
    ,('2')
    ,('3')
    ,(NULL)
    ) AS...
  • Reply To: Saving Labor

    Try this (adjust for your needs), then execute the output script:

    set nocount on
    select DISTINCT 'exec sp_helptext ' AS '--','[' + o.name + ']' AS [ ],CASE OBJECTPROPERTY(o.id,'ExecIsTriggerDisabled')...
  • Reply To: Restoring a Certificate

    What's the syntax for "LOAD CERTIFICATE"? I cannot find it on BOL.

    I saw that CREATE CERTIFICATE or ALTER CERTIFICATE loads the certificate from a file.

  • Reply To: EXCEPT

    Jason- wrote:

    *** sorry for the spoilers; but my comment didn't make sense to me without them ***

    I debated with myself between "Zero records" and the more comprehensive "Returns distinct rows...

  • Reply To: EXCEPT

    Rune Bivrin wrote:

    Carlo Romagnano wrote:

    Of course the isolation level of the database should be as in the image

    1

    Of course! That's obviously clear from the questionđŸ˜‹

    The question is about the...

  • Reply To: EXCEPT

    Of course the isolation level of the database should be as in the image

    1

  • Reply To: EXCEPT

    Palani K wrote:

    I ran the query and see zero rows only, please verify your answer.

    If the query returns no row, it means that there are not uncommitted data (inserted or modified).

  • Reply To: EXCEPT

    For debug, I used this query to return all rows inserted or changed in all open transaction.

    How to reproduce the scenario:

    Start a transaction in one session, insert or modify data...

  • Reply To: Removing Text From All Rows

    If you assume that the string always starts with '\1\' (as the original post) and you do not know then length of text then you can use STUFF instead of...

  • Reply To: Removing Text From All Rows

    WITH ctePC
    AS ( SELECT expression
    FROM
    ( VALUES
    ...
  • Reply To: Implicit conversion from datetime to datetime2

    Good catch!

    Thanks.

  • Reply To: Row and Page Compression Facts

    From your link:

    Compression can allow more rows to be stored on a page, but does not change the maximum row size of a table or index.

    So, the "Compression can allow...

  • Reply To: Choosing Rows or Range

    Please, post an example with RANGE!

    I tried this one, so the right answer is PARTITION BY:

    SELECT SUM(object_id)OVER()

    ,SUM(object_id)OVER(PARTITION BY NULL)

    FROM sys.objects

    WHERE object_id < 100

  • Reply To: Create a Tally Function (fnTally)

    I use this function with recursion and @top of 1000000 is enough for me, but I don't n know if it performs better:

    -- by Carlo.Romagnano

    CREATE FUNCTION dbo.fn_tally(@top INT)

    RETURNS TABLE

    AS

    RETURN WITH...

Viewing 15 posts - 1 through 15 (of 793 total)