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

    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
  • 0
    Liked

    Accessing Registry using XPs (contd..) – TSQL - Part 3

    We can use the xp_regwrite undocumented extended stored procedure to write new entries to Windows registry. You need to provide the key path, A new key will be created if it does not exist. The following code will add a new entry in startup programs list in registry: -- © 2011 – Vishal......

    Vishal Gajjar  Posted on May 11 2011 8:55PM
    Profile · Blog
  • 0
    Liked

    Accessing Registry using XPs – TSQL - Part 2

    While xp_regread read values from registry under exact path specified. To read instance specific registry entries from registry you can use xp_instance_regenumvalues and xp_instance_regread. xp_instance_regread translates the given path to instance-specific path in the registry: for example, execu......

    Vishal Gajjar  Posted on May 10 2011 9:02PM
    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]