摘要：select *,ROW_NUMBER() OVER(PARTITION BY FItemID ORDER BY FOrderPrice) as num into #t1 from ICStockBillEntry where finterid=@interid--select * into #t2 from #t1 where num=1 阅读全文

摘要：Some Useful ExamplesString.Format("{0:＄#,##0.00;(＄#,##0.00);Zero}", value);This will output "＄1,240.00" if passed 1243.50. It will output the same format but in parentheses if the number is negative, and will output the string "Zero" if the number is zero.String.Format( 阅读全文

摘要：这是从园里一位大哥那里拷来的代码，有时候还是非常管用的，原来T-SQL也是可以查询到变量的类型的，我真汗~~~~PRINT CAST(SQL_VARIANT_PROPERTY(20, 'BaseType') AS VARCHAR(50))PRINT CAST(SQL_VARIANT_PROPERTY(0.1, 'BaseType') AS VARCHAR(50))PRINT CAST(SQL_VARIANT_PROPERTY(20 / 0.1, 'BaseType') AS VARCHAR(50))DECLARE @a nvarchar(10)S 阅读全文

摘要：用Android开发手机游戏通常会用到eclipse工具。那么如何导入现有的项目到eclipse开发环境下，并进行修改和调试呢？ 点击File菜单，分别选择Import->General->Existing Projects into Workspace，然后在Select root directory中Browse你想要加入的工程。然而我并没有成功，任我怎么点击Refresh都没有显示可用的Projects文件（你现在就可以试一试）。这是为什么呢？原来这种导入方法只适用于eclipse自己创建的工程，比如说，在别人的电脑上用eclipse创建了一个工程，然后就可以用这个办法导入到 阅读全文

摘要：首先需要在manifest .xml中间中获取相应的权限<uses-permission android:name="android.permission.INTERNET" /><uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />public class HttpExampleActivity extends Activity { private static final String DEBUG_TAG = "HttpEx 阅读全文

摘要：** * Utility class for http request. * */ public class Utility { private static RequestParameters mRequestHeader = new RequestParameters(); public static final String BOUNDARY = "7cd4a6d158c"; public static final String MP_BOUNDARY = "--" + BOUNDARY; public static final String EN 阅读全文

摘要：<activity android:name=".ui.MyActivity" > <intent-filter> <action android:name="android.intent.action.SEND" /> <category android:name="android.intent.category.DEFAULT" /> <data android:mimeType="image/*" /> </intent-filter> 阅读全文

摘要：static final int PICK_CONTACT_REQUEST = 1; // The request codeprivate void pickContact() { Uri contacts = Uri.parse("content://contacts"); Intent pickContactIntent = new Intent(Intent.ACTION_PICK, contacts); pickContactIntent.setType(Phone.CONTENT_TYPE); // Show user only contacts w/ ph... 阅读全文

摘要：//define this at the top of the first Activitypublic final static String EXTRA_MESSAGE="com.binni.AndroidUI.MESSAGE";//first ActivityIntent intent =new Intent(this,DisplayMessageActivity.class);EditText edittext=(EditText)findViewById(R.id.edit_message);String str=edittext.getText().toStri 阅读全文

摘要：// Build the intent //Uri number = Uri.parse("tel:5551234"); //Intent callIntent = new Intent(Intent.ACTION_DIAL, number); Intent intent = new Intent(Intent.ACTION_SEND); // Always use string resources for UI text. This says something like "Share this photo with"... 阅读全文