Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • Reply To: Choosing Rows or Range 

    select sum(UnitPrice) over (partition by SalesOrderID) price, SalesOrderID from [Sales].[SalesOrderDetail]

    and see below output for above query. output

     

    Can you please share the query with Range?

     

    May 31, 2021 at 9:53 am

    #3890163

  • Reply To: Space allocated to the databases by disk letters

    Make sure you want to move all database or particular database.

    For all database above query is fine but for particular database can we use below queries,

    SELECT DB_NAME(database_id)...

    May 20, 2021 at 10:57 am

    #3885751

Viewing 2 posts - 1 through 2 (of 2 total)