Forum Replies Created

Viewing 15 posts - 46 through 60 (of 122 total)

  • RE: How to kill ?

    I am doing through UI.

    right click > Kill Process

    June 23, 2016 at 8:06 am

    #1886542

  • RE: SQL Search icon

    comments please

    April 3, 2016 at 6:01 am

    #1869360

  • RE: SQL query

    Ok. not an issue. Is it possible to write this in pure SQL way ? (so that I don't face database migration issue later)

    My query works fine....

    June 4, 2015 at 8:53 am

    #1803032

  • RE: SQL query

    Dear @ChrisM@Work

    I had

    .....from student_dtl order by intDtlId desc)

    did you miss this ?

    I wanted to join with the latest record of every profile in this table.

    June 4, 2015 at 8:44 am

    #1803028

  • RE: issue with datetime

    >>>SELECT CONVERT(datetime, '29/01/2014', 103)

    what does 103 do here ?

    September 29, 2014 at 11:49 pm

    #1749044

  • RE: issue with datetime

    BWFC (9/26/2014)

    spectra (9/26/2014)

    >>>>Remove the CONVERT and you'll be doing the date range check you want.

    how do you convert 26/09/2014 to Date ?

    then you can use Cast(CreatedOn as date)

    No.......you misunderstood my...

    September 26, 2014 at 8:12 am

    #1748516

  • RE: issue with datetime

    >>>>Remove the CONVERT and you'll be doing the date range check you want.

    how do you convert 26/09/2014 to Date ?

    September 26, 2014 at 8:00 am

    #1748509

  • RE: issue with datetime

    BWFC (9/26/2014)

    I'm struggling to understand what you need. Is that the only row you need returning? Can you post some sample data please.

    I have these records ..

    sample data:

    ------------------

    2014-09-26...

    September 26, 2014 at 7:30 am

    #1748493

  • RE: issue with datetime

    BWFC (9/26/2014)

    What exactly is the problem? You need to be very careful using BETWEEN with datetime. You're much better using >= and <=.

    Column has a value 2014-09-24 14:49:35.190...

    September 26, 2014 at 7:02 am

    #1748475

  • RE: how to shutdown ?

    Steve Jones - SSC Editor (9/20/2014)

    You can also right click the instance in Management Studio and select "stop" or click the button in the toolbar if it is visible.

    Thanks

    September 20, 2014 at 9:37 pm

    #1746904

  • RE: how to shutdown ?

    DBA From The Cold (9/19/2014)

    Safest way is through the SQL Server Configuration Manager.

    Right click the database engine service and choose stop. Be aware this will immediately stop the service!

    There is...

    September 20, 2014 at 9:34 pm

    #1746903

  • RE: how to shutdown ?

    DBA From The Cold (9/19/2014)

    Safest way is through the SQL Server Configuration Manager.

    Right click the database engine service and choose stop. Be aware this will immediately stop the service!

    what is...

    September 19, 2014 at 10:42 pm

    #1746852

  • RE: easy tool to capture data changes

    Yes ...I run that query and I get output which prints "Enterprise Edition". 🙂

    Thank you .

    Now I can use your script.

    However i am worried at one...

    July 27, 2014 at 5:21 am

    #1732656

  • RE: easy tool to capture data changes

    I am not quite sure whether its called Enterprise version or not.

    Could you please have a look at this ...

    Can I use your script in this database ?

    July 27, 2014 at 5:04 am

    #1732654

  • RE: easy tool to capture data changes

    We are deviating from the solution.

    The Sql Server Edition is more important

    its a SQL Server 2008 General sub forum ...right ? version is of course Sql Server...

    July 27, 2014 at 4:12 am

    #1732645

Viewing 15 posts - 46 through 60 (of 122 total)