Forum Replies Created

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

  • RE: Max DB Size for SQL Server Express

    where is express edition mentioned in question.

  • RE: Authentication Problem

    Thank you dear for your reply. I know all this. But by this they can see all databases present on server.although they can't access them.but i had a condition they...

  • RE: Store a file & Retrive it in Sql Server

    It could be any where, but both place should be accessible by sql server account. It will work on a network path too or a remote location.

  • RE: Store a file & Retrive it in Sql Server

    --Configure advance options

    sp_configure 'show advanced options', 1;

    go

    reconfigure;

    go

    sp_configure 'Ole Automation Procedures', 1;

    go

    reconfigure;

    go

    execute above code first. Then use this script, modify the script according to need like path. remove above code and...

  • RE: Detach & Attach Procedure

    Sure. @Perry Whittle,

    But what, if you have more than 50 or 100 databases or each database has multiple ldf & log files.

    Will you write the query.

    The script is for those...

  • RE: Counting values

    Sure, Explanation is wrong -

    You can understand this by below query :

    CREATE TABLE mytable ( myid INT, mychar VARCHAR(10) );

    GO

    INSERT mytable

    ( myid,...

  • RE: IMPLICIT_TRANSACTIONS & BEGIN TRAN

    good question.

  • RE: NULL Aggregates

    doubt on this question.

    Review once again.. :-):-):-)

  • RE: Parse out the first 3 characters

    MMartin1 (10/31/2014)


    Vimal Lohani (8/17/2014)


    I didn't find any error with the code :

    DECLARE @i TABLE( mychar VARCHAR(50)

    ,deriv as SUBSTRING(mychar,1,3) --Use this

    ,newderiv as left(mychar,3)); --Or use this

    INSERT @i VALUES ('Steve'), ('Stephan'), ('Stephanie')

    , ('Sterling'),...

  • RE: Friday Shirts

    -7

    Haha,

    Steve, Is it fix.(Universal Truth)

  • RE: Primary key vs Unique key

    +1

  • RE: SETSPN

    +1

  • RE: Unpivot

    StefanMayer (10/16/2014)


    After correcting the spelling mistakes ( if you run this query on a case sensitive instance) you will receive 2 rows!

    What do you mean by correcting spelling mistakes and...

  • RE: Unpivot

    twin.devil (10/15/2014)


    Comments posted to this topic are about the item <A HREF="/questions/unpivot/117130/">Unpivot</A>

    HAHA,

    Still wrong answer

    admin has not tested it.

    Answer should be two rows.

    OrderID ProductName ProductQty

    1 ...

  • RE: Create a stored procedure

    The answer is right for this kind of procedure :

    CREATE PROCEDURE my_sp AS

    SELECT id FROM my_table

    The answer is Wrong for below procedure

    CREATE PROCEDURE my_sp AS

    SELECT Column FROM my_table

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