CREATE TABLE tblSales (MonthNumber int,MonthName varchar(10) PRIMARY KEY,ProductA INT,ProductB INT,ProductC INT) INSERT INTO tblSales Select 1,’Jan’,5800,5900,5400 union allSelect 2,’Feb’,5750,5950,5500 union allSelect 3,’Mar’,6200,5700,7100 union allSelect 4,’Apr’,6300,5900,5400 union allSelect 5,’May’,5350,5650,5500 SELECT A.*,X.AvgSales
Oracle and SQL Server databases use different date/time resolutions, which poses a problem when you compare times from the two databases: The times will rarely be equal. Solve this problem
Windows applications generally use the registry for storing configuration information. Sometimes, it can be essential to allow users to change the registry key/value and the same needs to be reflected
Here’s an easy way to get OS information using the Windows Management Instrument (WMI): Private Sub getWindowsInfo() On Error Resume Next Dim strComputername As String Dim objWMIService As Object Dim
If you sort a table from a field which has null values, Null values are typically displayed first. Here is a way to display the NULL values at last. Use
If you do presentations/trainings and have to use VS.NET, and actually want your students to see the text on the IDE’s windows and dialog, you’d be better off changing the
When you install a new version of the VS.NET IDE, you lose the settings you used in the older version, such as project’s and solution’s defaults, debugging options, fonts and
‘ Return a reference to the control that caused the last postback,’ even from the Page_Load event!’ It requires in input a reference to the posted-back page’ (this is necessary
‘/// ‘/// Provides static (Shared) methods to find the’/// ImageFormat for a filename or MIME type.’/// Public NotInheritable Class ImageFormatUtils Private Shared codecs() As ImageCodecInfo Private Shared formats As Hashtable