摘要：
>MySql Query: SELECT TABLE_NAMEFROM INFORMATION_SCHEMA.TABLESWHERE TABLE_SCHEMA = 'test' Example OutPut: 阅读全文
摘要：
Stopwatchinstance can measure elapsed time for one interval, or the total of elapsed time across multiple intervals. In a typicalStopwatchscenario, you call theStartmethod, then eventually call theStopmethod, and then you check elapsed time using theElapsedproperty. (From MSDN) Let say i want to fi. 阅读全文
摘要：
Ever Thought if it was possible to not WebBrower control and use the Firefox Browser in your c# window Application...?? Yes ,, It is possible using GeckoFx wrapper class for C#.net and vb also. You will need the Followings: 1. GeckoFx Wrapper [Download] 2. Xul Runner [Download] (Download the zip ... 阅读全文
摘要：
I will just go with the Example as its SelfExclamatory. Sql Query:declare @string varchar(500)set @string = 'ABC,DEF,GHIJK,LMNOPQRS,T,UV,WXY,Z'declare @pos INTdeclare @piece varchar(500)-- Need to tack a delimiter onto the end of the input string if one doesn’t existif right(rtrim(@string),1 阅读全文
摘要：
This a simple Stored procedure to count the total numbers of rows in each table of your Database. I assume you have Northwind database installed. The Stored ProcedureIF EXISTS ( SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_GetRowsCountForAllTables]') ... 阅读全文
摘要：
I assume You have Northwind Database. I will be using The Employee Table. As Show in the figure there are 6 Selected cells which are the Duplicates( Just assume it) I want to find this number ( i mean 6.) The query for the above is: SELECT Title , COUNT(Title) AS NumOccurrencesFROM dbo.E... 阅读全文
摘要：
Here is the Script: USE Northwind GOCREATE TABLE #temp ( table_name SYSNAME , row_count INT , reserved_size VARCHAR(50) , data_size VARCHAR(50) , index_size VARCHAR(50) , unused_size VARCHAR(50) )SET NOCOUNT ONINSERT #temp EXEC sp_msforeachtable 'sp_spaceused ''?'''... 阅读全文
摘要：
This is simple sql query:USE masterGoIF EXISTS ( SELECT name FROM sys.databases WHERE name = 'MyDataBase' ) PRINT 'Exists'ELSE PRINT 'Does Not Exists' 阅读全文
摘要：
NET Framework 3.0 consists of four major new components: Windows Presentation Foundation (WPF), formerly code-named Avalon; a new user interface subsystem and API based on XML and vector graphics, which uses 3D computer graphics hardware and Direct3D technologies. See WPF SDK for developer article.. 阅读全文
摘要：
Imports System.SecurityImports System.Security.CryptographyImports System.IOImports System.Runtime.InteropServicesImports System.Text.RegularExpressionsImports System.Text Encryption: Public Function Encrypt(ByVal plainText As String) As String Dim passPhrase As String = "yourPassPhrase" . 阅读全文