Forum Replies Created

Viewing 15 posts - 316 through 330 (of 362 total)

  • RE: Syntax error converting datetime from character string (stored procedure)

    [font="Verdana"]

    Does your problem get solved by Amol’s suggestion or still you are facing any?

    Do let us know the exact scene.

    Mahesh

    [/font]

  • RE: how to set flag for one table?

    [font="Verdana"]

    dhanuhere (4/10/2008)


    Hi all,

    I am not great in sqlserver i am bascicaly asp.net professional.

    I want to set a column as flag for indicating user edit data time .somAeone suggest me set...

  • RE: Interview guidelines

    [font="Verdana"]

    I would like to thank you all for such a kind support. I get a better idea, what kind of questions (technical and non-technical as well) can be asked in...

  • RE: Row level lock

    [font="Verdana"]

    patel mayur m (4/10/2008)


    Hello Mahesh

    Thanks for a prompt reply

    But the problem is that we have more than one user. Invoice saving process will not take more than 3 to 4...

  • RE: Row level lock

    [font="Verdana"]

    patel mayur m (4/9/2008)


    Hello

    I have one scenario for that i don't know how to fulfill.

    Let take example. User-A is reading row now at the same time if user B is...

  • RE: Interview guidelines

    [font="Verdana"]

    Grant Fritchey (4/9/2008)


    You call out of TSQL to WMI process to launch a .NET app... right?

    Gant, I am not getting you?

    Mahesh[/font]

  • RE: Truncate can be rollbacked or not?

    [font="Verdana"]

    For more details check out the attached file here. I got this information online, 3-4 months ago. I just saved the information regarding to the difference between Delete and Truncate....

  • RE: Replace Count* with 0 if Null

    [font="Verdana"]

    Mitchel T (4/8/2008)


    Hi:

    I have the following query that may return null if certain dates are selected, I want to display 0 instead of a blank but cannot figure it out:

    *...

  • RE: Splitting

    [font="Verdana"]

    karthikeyan (4/8/2008)


    yes you are correct,we can seperate it in the DTS itself.

    But i want to do this with sql query.

    If this is so, I would suggest do it at...

  • RE: Splitting

    [font="Verdana"]

    karthikeyan (4/8/2008)


    Yes,I used DTS import/export wizard.

    Then whats the problem dude? Tell the DTS comma is the delimeter in the file, so it will separate the fields and will treat them...

  • RE: Splitting

    [font="Verdana"]

    karthikeyan (4/8/2008)


    Andras,

    I already did what you have mentioned.

    TableName: Imp_Text

    Remarks

    50,Karthik,1982,+91-044-994012345,5000.00

    60,Vijay,1974,+91-044-998012345,8000.00

    70,Arun,1992,+91-044-992012345,6500.00

    Now i want to split it in the below format.

    50 Karthik 1982 +91-044-994012345 5000.00

    60 Vijay 1974...

  • RE: SQL Server migration

    [font="Verdana"]

    fyi ...

    http://www.sqlservercentral.com/articles/Administration/2987/

    Thanks,

    Mahesh

    [/font]

  • RE: Connectivity to SQL Server, Oracle & MySQL

    [font="Verdana"]

    Bob Crowley (4/7/2008)


    Check out the Microsoft Patterns and Practices Enterprise Library.

    http://msdn2.microsoft.com/en-us/library/aa480453.aspx

    The Data Access Application Block is what you want to look at.

    I used it once in an...

  • RE: Select Top 1 Query

    [font="Verdana"]In what context you need help from us? Does the query is taking much time to execute? What exact the problem you are facing? Does it throwing any error? Please...

  • RE: Convert Row Values into Column

    [font="Verdana"]

    karthikeyan (4/7/2008)


    My Team is using SQL2000 and Sybase12.5.3.

    It is not working in Sybase12.5.3.

    But the thing is, Sybase and Sqlserver are almost same in some generic query execution.

    if we take our...

Viewing 15 posts - 316 through 330 (of 362 total)