Check out the following links: http://www.dotnetperls.com/dictionary http://www.dotnetperls.com/word-search

Use layered approach (tier). In your case three tier approach is suitable: DAL–Data Access Layer, BLL–Business Logic Layer and GUI –Graphical User Interface.

your code look like this: try { begin tran exec sp_User_Master exec sp_User_Detail commit tran } catch (Execption objException) { rollback transaction }

First collect the current SQL Server instance name select @@servername Execute the below queries to change the SQL Server instance name sp_dropserver ‘old_name’ go sp_addserver ‘new_name’,‘local’ go Restart the SQL Server service, to run the below commands: net stop mssqlserver net start mssqlserver

Its leave the updated rows. If you want to rollback all previous transactions, use the following before query: Begin Tran

Read the following articles, I think this will help you: http://www.codeproject.com/KB/combobox/multicolumnlistbox.aspx[^] http://www.codeproject.com/KB/cpp/mclb.aspx[^] Also read the following conversation: http://www.eggheadcafe.com/software/aspnet/29512096/multicolumn-list-box.aspx[^]

See the following example: Select table1.*, table2.* From table1 join table2 on table1.Id = table2.Id In the above example table1 is considered left and table2 is considered right.

Yes, It is true.

N in insert query represent Unicode. Q:Why we use Unicode? A: Unicode can represent over 65,000 characters, it accommodates many languages whose characters are not represented in ANSI encoding. ANSI character encoding represents characters in one byte, it is limited to 256 characters. For default input language, follow these steps: 1. Click Start, click Run, type intl.cpl, and then click OK. 2. Click the Languages tab, and then click Details. 3. On the Settings tab, click Add. 4. Select the language that you want in the Input language list, and then click OK. 5. Select the language that you want in the Default input language list. 6. Click OK two times.

Aajignesh, read the following carefully I think this will help you: For example table name is Customer. Customer table have two coulmns (CustomerId & CustomerName). You want to store Gujarati Font in second column (CustomerName). Set the datatype of CustomerName column to nvarchar(50), Then make the query look like as below: Insert into Customer (CustomerId, CustomerName) values ('1', N'Write Name in Gujarati Font') Note: Don't Forget to install Gujarati Font on your operating system. Incase of any confusion feel free to ask muhammadshahidfarooq@yahoo.com

Haritha, use the following query this will help you: Select sum(Amount) as Amount_Sum from Customer group by CustomerId

Visit the following links, this will help you: http://www.techonthenet.com/oracle/functions/to_char.php[^] http://www.techonthenet.com/oracle/functions/to_date.php[^] http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96540/functions134a.htm[^] http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96540/functions137a.htm[^]

Delete From TableName Where CoulmnName = @Parameter

TO_CHAR and TO_DATE are built-in functions in Oracle. TO_CHAR = Convert number to string TO_DATE = Convert string to date

Visit the following link, this will help you: http://msdn.microsoft.com/en-us/library/2839d5h5(VS.71).aspx[^]

Use Hashing algorithm for this purpose, because Hashing Algorithms are one way and no need to decrypt.

Make formula field then show this field in detail section.

Use the simple way but this is not technical ;) Remove the database from setup project. Database place on other location. Make new connection string for that, then bulid and deploy.

What kind of message or error you recieved ?

Go to the properties of Setup Project and the set value true of "RemovePreviousVersion". And also change the version property. After setting these properties build the project and then install on your client machine. You have only on instance in Add/Remove programs.