Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked



Upload Image Close it
Select File

My Experiments with SQLServer
Browse by Tags · View All
SQLServer 126
SQLServer 2008 R2 91
SQLServer 2008 86
SQLServer 2005 82
SQL 60
Database 59
Sql And Me 57
Tips & Tricks 28
SQL Server 27
SQL FAQ 26

Archive · View All
May 2011 25
June 2011 21
July 2011 21
August 2011 19
April 2011 16
January 2013 4
May 2012 3
April 2012 3
October 2011 3
February 2013 2

Vishal Gajjar's Blog

  • 0
    Liked

    Using Built-in System Function – $PARTITION

    you can use @PARTITION TSQL function to check which partition will be mapped to a specified column value. For example if you have a partition function with four partitions as below: -- © 2011 – Vishal (http://SqlAndMe.com) CREATE PARTITION FUNCTION PartFunc01 (INT) AS RANGE FOR VAL......

    Vishal Gajjar  Posted on May 23 2011 7:10AM
    Profile · Blog
  • 0
    Liked

    How to get difference between two dates – TSQL

    To calculate the difference between two dates, you can use DATEDIFF() function. The DATEDIFF() function returns the number of days/month/years and time between two dates. Syntax: DATEDIFF (date part, start date, end date) For example, to calculate time left till Independence Day, you can use: --......

    Vishal Gajjar  Posted on May 22 2011 7:12AM
    Profile · Blog
  • 0
    Liked

    How to add/subtract days from a date – TSQL

    To add or subtract days from a date, you can simply use: -- © 2011 – Vishal (http://SqlAndMe.com) SELECT GETDATE() AS 'Today', GETDATE() + 10 AS '10 Days Later', GETDATE() - 10 AS '10 Days Earlier' Result Set: Today 10 Days Later ......

    Vishal Gajjar  Posted on May 20 2011 7:16AM
    Profile · Blog
  • 0
    Liked

    How to get first Monday of Week/Month – TSQL

    Following queries can be used to get First Monday of a week/month: -- © 2011 – Vishal (http://SqlAndMe.com) -- Monday of Current Week SELECT DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()), 0), 'Monday of Current Week' UNION ALL -- First Monday of the Month: SELECT ......

    Vishal Gajjar  Posted on May 18 2011 8:23PM
    Profile · Blog
  • 0
    Liked

    How to get First and Last day of a Year – TSQL

    Yesterday, I posted bout How to get the First and Last day of a Month. Same can be modified to calculate first/last day of a given year: – © 2011 – Vishal (http://SqlAndMe.com) – First/Last Day of the Year: SELECT DATEADD(YEAR, DATEDIFF(YEAR, 0, DATEADD......

    Vishal Gajjar  Posted on May 17 2011 8:26PM
    Profile · Blog
  • 0
    Liked

    How to get First and Last day of a month – TSQL

    Following queries can be used to get the first/last days of a month. To get first day of a month use: -- © 2011 – Vishal (http://SqlAndMe.com) -- First Day Previous/Current/Next Months SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 1, 0), 'First Day of Prev......

    Vishal Gajjar  Posted on May 16 2011 8:30PM
    Profile · Blog
  • 0
    Liked

    Undocumented Extended Stored Procedures – XPs

    xp_fixeddrives is a useful extended stored procedure which returns amount of free space available in MB, for all local hard drives. -- © 2011 – Vishal (http://SqlAndMe.com) EXEC master..xp_fixeddrives drive MB free —– ———– C 91884 S 5......

    Vishal Gajjar  Posted on May 14 2011 8:34PM
    Profile · Blog
  • 0
    Liked

    How to check SQL Server version – TSQL

    The most common way to check SQL Server is to use @@VERSION configuration function. It returns version, architecture, OS version and build date for current instance. -- © 2011 – Vishal (http://SqlAndMe.com) SELECT @@VERSION AS [Version] Version —————&......

    Vishal Gajjar  Posted on May 13 2011 1:40PM
    Profile · Blog
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]