How To Do

Microsoft Tutorials





http://www.functionx.com/

http://www.functionx.com/sqlserver/

Articales For Me

Mix Know






How many bits are used to represent Unicode, ASCII, UTF-16, and UTF-8 characters?

Unicode requires 16 bits and ASCII require 7 bits Although the ASCII character set uses only 7 bits, it is usually represented as 8 bits.
UTF-8 represents characters using 8, 16, and 18 bit patterns.
UTF-16 uses 16-bit and larger bit patterns.























S8

Perm Space vs Heap Space









Copied From : http://stackoverflow.com/questions/4848669/perm-space-vs-heap-space

The heap stores all of the objects created by your Java program. The heap's contents is monitored by the garbage collector, which frees memory from the heap when you stop using an object (i.e. when there are no more references to the object.

This is in contrast with the stack, which stores primitive types like ints and chars, and are typically local variables and function return values. These are not garbage collected.



http://stackoverflow.com/questions/1279449/what-is-perm-space



For Better Coding ........







Java Coding Rules

http://www.appperfect.com/support/java-coding-rules/java-coding-rules.html


Java Optimization Rules

http://www.appperfect.com/support/java-coding-rules/optimization.html


Twelve rules for developing more secure Java code
http://www.javaworld.com/article/2076837/mobile-java/twelve-rules-for-developing-more-secure-java-code.html



Google Java Style


https://google-styleguide.googlecode.com/svn/trunk/javaguide.html











Android Saved Location Error


Error

Installing com.inicio.tariff
DEVICE SHELL COMMAND: pm install -r "/data/local/tmp/com.inicio.tariff"
pkg: /data/local/tmp/com.inicio.tariff
Failure [INSTALL_FAILED_MEDIA_UNAVAILABLE]




In  your Manifest.xml file you can use ,

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
          package="com.inicio.tariff"
          android:installLocation="auto"
........................................
>



Differences between Stored procedures and User defined functions

1
Stored procedures may or may not return values
But function should return value

2
Stored procedure cannot be used in the select/where/having clause
But function can be called from select/where/having clause

3
Stored procedure can run independently. It can be executed using EXECUTE or EXEC command
But function cannot run independently

4
TRY CATCH statements can be used in the stored procedures.
But it cannot be used in the function. But we can use raise error function.

5
Stored procedure can call the user defined functions
But the function cannot call the stored procedures.

6
Stored procedures can have input and output parameters.
But the function can have only input parameters.

7
Stored procedures can have select and all DML operations.
But the function can do only select operation.

8
Stored procedures can use all the data types available in sql server.
But the function cannot use the ntext, image and timestamp data types as return type.

9
Stored procedure can have the dynamic sql statement and which can be executed using sp_executesql statement.
But the function cannot execute the sp_executesql statement.

10
Stored procedure allows getdate () or other non-deterministic functions can be allowed.
But the function won't allow the non-deterministic functions.


What is User-defined Functions? What are the types of User-defined Functions that can be created?

There are three types of User-Defined functions in SQL Server:

  • Scalar Function
  • Inline Function
  • Multi-statement Table-valued Function
Scalar UDFs
Scalar UDFs return a single value. They are similar to built-in functions such as GETDATE(), or OBJECT_NAME(), which return a single string, date, or integer. The value returned by a scalar UDF can be based on the parameters passed.
Scalar UDFs can return any scalar system-supplied data type, except TIMESTAMP. You cannot return values with a user-defined data type from scalar UDFs. If you want to do so, you must specify the underlying system-supplied data type instead.

In-line UDF
In-line UDFs return a single row or multiple rows and can contain a single SELECT statement. Because in-line UDFs are limited to a single SELECT, they can't contain much logic. They can be effective, however, for lookups that return multiple values, such as the top five best-selling books with title, author, and publication date.

Multi-statement UDFs
The multi-statement UDFs can contain any number of statements that populate the table variable to be returned. Notice that although you can use INSERT, UPDATE, and DELETE statements against the table variable being returned, a function cannot modify data in permanent tables. Multi-statement UDFs come in handy when you need to return a set of rows, but you can't enclose the logic for getting this rowset in a single SELECT statement.

Difference between GET and POST methods

The GET Method
GET requests can be cached
GET requests remain in the browser history
GET requests can be bookmarked
GET requests should never be used when dealing with sensitive data
GET requests have length restrictions
GET requests should be used only to retrieve data

The POST Method
POST requests are never cached
POST requests do not remain in the browser history
POST requests cannot be bookmarked
POST requests have no restrictions on data length

The HEAD Method
Same as GET but returns only HTTP headers and no document body
A HEAD request is just like a GET request, except it asks the server to return the response headers only


http://www.jquery2dotnet.com/2014/03/difference-between-get-and-post-methods.html

Online Tutorial Sites