By admin, on August 18th, 2010
It is not possible to find the maximum date in a given field by means of a direct function, but the objective can be performed in different way.
let us take this example
CREATE TABLE [dbo].[date_cal](
[callno] [int] NULL,
[sdate] [datetime] NULL,
[enddate] [datetime] NULL
) ON [PRIMARY]
Insert some values into it
callno sdate enddate
———– ———————– ———————–
1 2010-08-01 00:00:00.000 2010-08-04 00:00:00.000
2 2010-08-04 00:00:00.000 . . . → Read More: Max Date in SQL Server
By admin, on August 10th, 2010
Example 1
SELECT u.name + ‘.’ + t.name AS [table],
td.value AS [table_desc],
c.name AS [column], .value AS [column_desc]
FROM sysobjects t
INNER JOIN sysusers u
ON u.uid = t.uid
LEFT OUTER JOIN sys.extended_properties td
. . . → Read More: SQL Server: Extract Table description, fields and their data types
By admin, on July 19th, 2010
When you are planning to remove management studio from existing installation.
First invoke the remove operation using control panel and choose add or remove program.
In the option choose change / remove operation then choose remove functionality and choose the shared components option here choose managment studio and remove . . . → Read More: Uninstall Management studio in SQL Server 2008
By admin, on March 17th, 2010
I started trying the installation of Visual Studio 2008, I choosed custom option where I saw a option Dotfuscator Community Edition 3.0. I started searching the net.
Your .NET applications are important to your company’s profitability. Therefore, protection of these applications is crucial. To this end, any .NET program where the source code is not bundled with . . . → Read More: Dotfuscator Community Edition 3.0
By admin, on March 16th, 2010
If you are planning to work both XAMPP and IIS in a same machine.
If IIS is not installed in the machine, first install xampp, then do the process of iis installation.
if IIS is installed, uninstall it and then install xampp.
please make sure to change the port of xampp in C:\xampp\apache\conf\httpd.conf as
Listen 85
IIS will work normally in port 80
xampp . . . → Read More: XAMPP and IIS in Windows XP
By admin, on March 2nd, 2010
Bluetooth technology provides a secure, wireless connection between computers, mobile devices and peripherals. New models of LCD projectors include built-in or USB accessories for Bluetooth connectivity that enable users to pair with the device and use the projector as an output device. While Bluetooth-enabled computers have drivers for a variety of devices installed, drivers for . . . → Read More: How to Use Bluetooth to Connect a LCD Projector
By admin, on January 23rd, 2010
Today I thought of adding multiple email addresses for one filter in Google.
We can acheive the requirement by two simple usages,
In from field type the addresses in the following manner.
1. ram@rajaramsystem.com OR kumar@rajaramsytem.com
2. {ram@rajaramsystem.com kumar@rajaramsystem.com}
If there is any options share . . . → Read More: Google - One Filter Multiple email addressess
By admin, on December 30th, 2009
By admin, on November 28th, 2009
Openfire is a instant messaging software - it is rich with lot of features. Openfire is adaptable to different to different user management scenerio. Openfire uses a embedded database engine named HSQLDB. I want to share some words about HSQLDB.
HSQLDB (Hyper Structured Query Language Database) is a relational database management system written in Java. HSQLDB is . . . → Read More: Instant Messaging Using Openfire
By admin, on October 13th, 2009
Work Flow System
The automation of a business process, in whole or part, during which documents, information or tasks are passed from one participant to another for action, according to a set of procedural rules
Computer application contains a number of different ‘tasks’, ‘transactions’, ‘programs’ or ‘modules’, each of which performs a particular function. Sometimes the processing of . . . → Read More: Windows WorkFlow Foundation.