Forum Replies Created

Viewing 10 posts - 31 through 40 (of 40 total)

  • RE: Killing the DB :P

    I found a way....its the KILL statement.....KILL statement requires the SPID of the process to be killed, i wrote the following code to find the SPID's of my Database, but...

  • RE: Another VARCHAR Size limitation Problem :(

    yah thats wat i was thinking but u know i dont need to use the COL_LENTH function coz all my columns (except TimeStamp) will be DECIMAL(38,6) therefore each column will...

  • RE: Another VARCHAR Size limitation Problem :(

    ooooo guys where r u goin...

    the solution provided by Kory Becker was perfect, but after that i asked about the limit on the row width...

  • RE: Another VARCHAR Size limitation Problem :(

    Thanks alot, indeed an implementable idea, but in this case i want to know that how will i check that the row size of the table has reached to its...

  • RE: Two Problems

    First of all thanks for humiliating

    Ne ways...i asked the first problem just for my knowledge

  • RE: Sort Order for NULLS

    thanks alot the problem is solved

  • RE: Sort Order for NULLS

    Thanks alot...i think the problem is near to be solved after the resolution of the following error

    Actually in my case the data type...

  • RE: Sort Order for NULLS

    Ok Fine....Actually your solution works for select statement of one table but if i use a UNION operator then the following error occors

    "ORDER BY items must appear in the select list if...

  • RE: Sort Order for NULLS

    Sorry my fault actually the query was.

    SELECT Col1 FROM Table1

    ORDER BY Col1 ASC

    and the result is

    NULL

    NULL

    1

    2

    3

    4

    5

    Now I use your solution (Using 2147483647) But the error occors that the...

  • RE: Query Time Out Problem

    Thanks for the reply,

    But the problem is why should i set the timeout option in ODBC as i am running the query in Query Analyzer or even in Enterprise Manger.

    And...

Viewing 10 posts - 31 through 40 (of 40 total)