Database

n3ophyt3 wrote:

I have to store hindi,chinese ... etc language words in my db

You can create a Unicode database that enables you to store UTF-8 encoded characters as SQL CHAR datatypes (CHAR, VARCHAR2, CLOB, and LONG).

n3ophyt3 wrote:

how can i do the language conversion from HINDI to english ... any sourcecode?

function OtherLanguage2English(value,offset)
{
		var ctrlValue=value; //Variable ctrlValue stores the value of the respective languages depinding on the 						   offset value		
		var english="";

		for (var idx=0; idx<ctrlValue.length; idx++)//Loop Until The End Of Text Is Reached
		{
				individualChar = ctrlValue.substring(idx,idx+1); //Extracting Charecter 1 By 1 From The String Value

				var code =individualChar.charCodeAt(0);//Gets the Unicode Value	
				
				english=english+ String.fromCharCode(code-offset);//Converts From Other Language Values To English
				
				switch(offset)
				{
					
					case 2358:document.getElementById('txtEnglish').value=english;break;//For Hindi Value To English
				}

		}
}

deepseeindeepsy wrote:

Is it possible to fetch it?

Alter Procedure GetMultipleRecords

As

Begin

       -- First select

          Select * from test1

        -- Second   select

          Select * from test2
End

From Asp.net application, by using DataAdapter get the records set into the DataSet

     DataSet ds = getDataRecords();->You will get the records from database

     if(ds!=null && ds.tables.count > 0)
     {

   //Store the result for Select * from test1 into datatable firstDt

          DataTable firstDt = ds.tables[0]; 

//Store the result for Select * from test2 into datatable secondDt  

          DataTable secondDt = ds.tables[1]; 
     }

Select A.ID, A.RefID, (Select count(*) from Table where RefID = ID) Total
From Table

declare @tbl table(id int identity, refid int)
insert into @tbl 
	select 0 union all select 1 union all
	select 2 union all select 1 union all
	select 1

select t.id,t.refid,case when x.cnt is null then 0 else x.cnt end as total
from @tbl t
left join
(
select refid,count(refid) as cnt
from @tbl
where refid <> 0
group by refid
having (count(refid)>0)) x
on t.id = x.refid

1	0	3
2	1	1
3	2	0
4	1	0
5	1	0