Forum Replies Created

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

  • RE: Strange...Cannot create procedure.

    Chirag (5/26/2008)


    Hi

    create procedure PositionInsert_sp

    as

    begin

    select 'd'

    end

    Just for fun, have you tried to alter?

    alter procedure PositionInsert_sp

    as

    begin

    select 'd'

    end

  • RE: Automatically start MS SQL Server

    Why do we keep talking about scripts. There is no need for one. Go to

    Control-Panel -> Administrative tools -> Services...

    Find the "SQL Server *" services. the...

  • RE: Automatically start MS SQL Server

    Jeff Moden (5/26/2008)


    One thing that you should be made aware of... Unless you're installing the Developer's Edition of SQL Server, it must run on a Windows Server.

    Express edition is can...

  • RE: Reindexing problem(Please help)

    I think you misunderstood the comments made by theSQLGuru. No disrepect was directed towards you. You are not the problem here. You are just doing what you...

  • RE: Reindexing problem(Please help)

    I have a question. Are you using 2000, or 2005?

    The reason is that the http://support.microsoft.com/kb/902388 matches your issue exactly.

    Can you send us exactly what you type when you are...

  • RE: User Defined Function - Passing and Processing a Table

    Jeff Moden (4/28/2008)[/bIt really would help if the OP would post exactly what output is expected from the input in the original post, though.

    I agree with all your points, I...

  • RE: User Defined Function - Passing and Processing a Table

    Jeff Moden (4/25/2008)


    rbarryyoung (4/16/2008)


    I am confused. Why isn't robert's answer sufficient?

    I agree... why is everyone still looking for an aggegate function and passing columns of data when Robert's very...

  • RE: Seeing Double

    So here is your "it's the weekend and there are no important games on" assignment.

    Sorry, but being from Pittsburgh and a hockey fan, I disagree with that comment. In...

  • RE: Seeing Double

    Steve,

    You asked for a "Good" reason to allow duplicate indexes.

    Oracle doesn't allow them. 🙂

  • RE: Seeing Double

    1) ColA,ColB and ColA are not the same, and should be allowed (although this is rare situation)

    a) This only makes sense when ColB impacts the size of the...

  • RE: SQL Server Express DAC

    "Is it possible...", "How would you change the default...", etc.

    There were many ways that this question could have been worded to make this a valid question, but "By Default" is...

  • RE: HELP --- SQL Programming

    BEGIN TRANSACTION

    ;WITH tblDesc AS (

    SELECT proj_id,

    [desc] FROM tblTest

    WHERE proj_id NOT LIKE '%.%'

    )

    UPDATE tblTest

    SET [desc] = tblDesc.[desc]

    FROM tblTest

    INNER JOIN tblDesc

    ON SUBSTRING(tblTest.proj_id,1,LEN(tblDesc.proj_id)) = tblDesc.proj_id

    WHERE...

  • RE: HELP --- SQL Programming

    The issue here is a bad design.

    Basically what you are calling the top level project should be a table of it's own.

    In fact you should have at least...

  • RE: select number from database with comma

    Of course I found another bug 🙁 Big Floats can't have more that 15 digits precision, however obviously 1E40 won't fit in a bigint. oops. Sorry, going...

  • RE: select number from database with comma

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    CREATE FUNCTION [BigMoney]

    (

    @value float

    )

    RETURNS VARCHAR(500)

    AS

    BEGIN

    DECLARE @numreal BIGINT, @num BIGINT,

    @Result VARCHAR(200)

    ...

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