In this article, I am going to describe how to upload and fetch images to/from an Oracle database using an XML web service. There is a certain condition where my web application needs to communicate with a far remote database server. Remote communication is one of the major aspects of web applicatio... [More]

Download    System.Data.SQLite is an enhanced version of the original SQLite database engine.  It is a complete drop-in replacement for the original sqlite3.dll (you can even rename it to sqlite3.dll).  It has no linker dependency on the .NET runtime so it can be... [More]

  Sample script that breaks down buffers by object (table, index) in the buffer cache. This script, contributed by Microsoft's Tom Davidson, requires SQL Server 2005.   Script Code use Northwind go select b.database_id, db=db_name(b.database_id) ,p.object_id ,object_name(p.object... [More]

Download code Introduction: In this sample describes how to build a distribution application which accesses MS SqlServer2000 on remoting service. Using the code Server using System; using System.Data; using System.Data.SqlClient;   namespace www.treaple.com {  &... [More]

A gain finally insertion record：scope_indentity() declare @dt table ( _id int identity(1,1),   _name char(10) ) insert into @dt (_name) values('scottxu') insert into @dt (_name) values('psg') insert into&... [More]

Today helped the friend to adjust a website, turned sp accidentally, saw a section of very long select sentence, the reason that this select sentence was long, was because had several general complex case sentences to follow in select behind.We select a field the logical rule and the data make our t... [More]

Download code   Introduction Given that you are a DBA and need to know how other programmers are modifying the DB tables and stored procedures for the purpose of audit or just curiosity. Though there could be a lot of solutions for IT audit in enterprise level, you may need simpler one. He... [More]

Ever needed to convert an oracle report to pdf/excel/word? Here is a solution Using the code Just simple Code which runs the oracle report and convert that in to a blob and then opens it using desired format Blocks of code should be set as style "Formatted" like this: Collapse using Syst... [More]

Sometimes, a developer can't trust his eyes, when things changes without warning. They just react in another way and no one knows why. What are we talking about? Using an Order By in a Select Query (in a view, inline function or something similiar) is a beginner level phrase. And it's nothing that... [More]

Throughout my travels in the IT industry I have seen many database designs and it never fails to amaze me how many systems simply ignore the fundamentals of good design. I am not talking about poor designs from an academic point of view; these sub-standard designs don’t work because they are a... [More]

Sql Server does not provide any function to get Time in hh:mm tt format from DateTime field. So you can get time using this function. Using the code First of all you have to create this function in your databse. and then you can get the time from the full datetime value.use the following sql scrip... [More]

Download code   Introduction While executing the IT project of any significant size, auditing any structural change during the course of project is important. Project manager handling the team size varying from 5 developer to 50 developer cannot do all the activities. Another challenge is ... [More]

SQL Server 2005 provides encryption as a new feature to protect data against the attacks of hackers. Hackers may be able to get hold of the database or tables, but they wouldn't understand the data or be able to use it. It is very important to encrypt crucial security related data when stored in the... [More]

Download code   The main focus of this article is to load the contents of a DBF file into a DataTable. Sure, you can search the Internet and find a thousand examples of how to load a DBF in .NET. However, try to find one that does NOT use the MS Jet driver or perhaps the MS FoxPro driver. I... [More]

Download source Introduction I wrote this tiny tool to compensate the limitations of the otherwise perfect iTunes player in reports generation. The program exports your iTunes library data to a Microsoft SQL Server (hence the name – sqlTunes) database which can then be queried using T-SQL.... [More]