SQL Server – How to Find Total Number of Days in a Month

To Find out Total Number Of day in any month in Sql Server we have to write these Query :
Select datediff(day, GetDate(), dateadd(month, 1, GetDate()))
By using above query we can get total number of days for particular month.

Differences between Stored Procedures and Functions

  • Procedure can return zero or n values whereas function can return one value which is mandatory.
  • Procedures can have input/output parameters for it whereas functions can have only input parameters.
  • Procedure allows select as well as DML statement in it whereas function allows only select statement in it.
  • Functions can be called from procedure whereas procedures cannot be called from function.
  • Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.
  • We can go for transaction management in procedure whereas we can’t go in function.
  • Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.
  • UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section where as Stored procedures cannot be.
  • UDFs that return tables can be treated as another rowset. This can be used in JOINs with other tables.
  • Inline UDF’s can be though of as views that take parameters and can be used in JOINs and other Rowset operations.

Posted by on April 5, 2013 in SQL


Connect micromax A87 With PC If USB is Block

1. Download these files:

  •  jdk 32bit only from here
  • Android sdk from here
  • A87 drivers from here
  • adb_usb.ini (very imp) from here
  • Android Commander from here

2. Installing Android sdk

  • Install jdk (required for Android sdk)
  • Then install Android  sdk, if you get an error saying “Java SE development kit not found” then follow the steps below,
    • Press back and then Next again (works most of the times).
    • If it still shows the same error then you may have to set the path, Just goto control panel > search for “advance system settings” > open it > click “Environment variables” there you may find a variable named “JAVA_HOME” select it and click edit, if you dont find it then click new, in the variable name type “JAVA_HOME” and in variable value give the Path of your jdk installed for eg. (“C:\Program Files(x86)\Java\jdk1.7.0_07”). be sure that u specify you own version of jdk, just go and check your folders. now Click OK > Click OK > Click OK then try installing android sdk.
    • If you still get the same error, just check that the version of jdk you have installed and the version of Android sdk you are trying to install are both x86 / 32bit versions, if not then download again.
  • After installing open sdk manager form start, you will get a list of packages to install just select “android sdk platform-tools” and “google usb driver” unselect the rest, click install packages
  • After installing copy the adb_usb.ini file in “C:\Users\(your PC name)\.android” folder

3. Enable usb debugging mode

  • On your A87 goto settings>applications>development>enable usb debugging
  • connect usb cable, it should say usb debugging mode and show a little green android icon on the top left (if not then reinsert cable or re enable usb debugging)

4. Installing A87 drivers

  • Windows will detect the device, let it stabilize then extract A87 drivers to a location say “C:/drivers”.
  • Now goto start type “device manger” open device manager, you will find “android adb interface” right click upgrade drivers and lead it to a location of your extracted drivers.
  • do the same with other devices you get with an exclamation icon. (dont worry if you dont find other devices, its fine)

5. Open Android Command

  • Open Android Command  From All Program And Tansfer Your Data From Android Phone to PC OR PC to Android Phone
1 Comment

Posted by on January 9, 2013 in Hacking