RSS

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.
 
2 Comments

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