|
Thanks God you didn't expect anyone here to remote connect to your computer and change the colors for you.
|
|
|
|
|
i want the SQL query for getting single column from two different tables column....
i have two tables...vendor and labour, In that Vendor_Name and Labour_name columns..
i want all names in one single column...
Thnks....
Vishal V Patil
(M. C. A.)
|
|
|
|
|
Do some reading around the UNION keyword.
Select Vendor_Name from Vendor
UNION
Select Labour_Name from Labour
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thnks for rply....but, It will show last two records from both two tables....
Vishal V Patil
(M. C. A.)
|
|
|
|
|
select * from vendor where id in (select top 2 id from vendor order by id desc)
union all
select * from labour where id in (select top 2 id from labour order by id desc)
I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi friends,
I have a requirements to build a data base with bilingual dictionary. Upto certin limit i found many threads on how to structure the DB table. But from where i can get the dictionary itself? I need The raw material (in excell or xml) to fill the DB. Any one can help with this?
Thanks.
|
|
|
|
|
A simple goggle [^]search seems to indicate there are plenty of sources out there!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks RAH for your reply, I guess i was not clear maybe in my previous question, I have few sources for the English dictionary, and other languages. But what I want to build is a kind of Offline Translator:
- Language 1 --> Stored in DB.
- Language 2 --> Stored in DB.
- Language 3 --> .....
And as am typing a word in my application it will search for the translation in the DB.
The challenge no is From where i can get the source of the Bilingual Dictionary for example (English - Spain) in xml or excell.
any advice?!
|
|
|
|
|
Ah I see, not going to be able to help, the few times I have done multi lingual apps I have forced the client to supply the translations, publicly available info was inadequate to the requirements especially when dealing with a technical subject.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You may be able to purchase such a thing. Be careful of downloading information for copy-write laws.
|
|
|
|
|
I Totally Agree, but really am not yet able to find any company I can purchase from them the files. It is really hard 
|
|
|
|
|
Y@ssco wrote: But from where i can get the dictionary itself?
http://www.freedict.org/nl/[^], or search for the Ergane-database. IIRC, it's a (free) MS-Access database which uses the Esperanto-language as intermediate to go from one language to another.
|
|
|
|
|
Hi all! Is it possible to embed sql server express in an application without installing it like it is in mysql and sqlite3? I would like to link my application to a static or dynamic library if Microsoft makes that provision so that I will not install the server on the user machine.
I tried to do this using mysql but for three days now I have not been able to initialize the server as library initialization fails. SQLite3 makes that provision but does not encrypt the data. I don't know if it is possible with Microsoft SQL server. I will be writing the application in C++. Thanks in advance.
|
|
|
|
|
|
Danzy83 wrote: SQLite3 makes that provision but does not encrypt the data.
It does[^];Encryption Support
The entire database file can be encrypted. Binary and cleartext passwords are supported.
|
|
|
|
|
My case is
Input is "abdknmgbm".
BUT
The record in database that i want to query out is "abkdnmgmb"
The input and database record is quite similar.
String length is same, only some arrangement of character are not same.
In the above case, dk and kd ; bm and mb.
How i write query for this string searching?
Help and Thanks.
|
|
|
|
|
If you are using SQL server try SOUNDEX. Do not know if it will work though.
|
|
|
|
|
Cannot work. Because they are not in english word.
|
|
|
|
|
You could try the LIKE operator[^].
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
|
Actually the swap char will not always are char 3 and 4 and last 2 chars.
For example it may also be like this :
Input: " abcdkazbmopdkubmgt "
The wanted result is : "abckdazmbopkdumbgt"
Input and wanted result length are same.
BUT the input string length is not always the same.
Very hard to solve this. Tq.
|
|
|
|
|
So? Those have a Levenshtein Distance of 10 (8 if you Trim) -- maybe that's within your threshdold, I dunno.
|
|
|
|
|
I have read about Levenshtein Distance. New knowledge for me. Thx.
But how can i apply into my coding? I am using Asp.net with C#. I have no idea about this.
|
|
|
|
|
If you think it will do what you need you can write a function in C# or VB and add it to SQL Server (I assume you're using SQL Server). As to how to add it to SQL Server, I'd rather write a tip than post it here.
Given that the function has the signature int Levenshtein ( string , string ) you would then be able to say:
SELECT * FROM sometable WHERE dbo.Levenshtein ( somefield , @somevalue ) < @somethreshold
The threshold should probably be based on the lengths of the strings, for instance half the length of the shorter string.
To make things more efficient, you could write a function with the signature bool IsSimilar ( string , string , int ) that will return false as soon as the Levenshtein Distance between the strings exceeds the threshold (the third parameter).
SELECT * FROM sometable WHERE dbo.IsSimilar ( somefield , @somevalue , @somethreshold ) = 1
|
|
|
|
|
lhsunshine wrote: How i write query for this string searching
Very inefficiently.
If you have a lot of data then you should probably look for another way to implement the search.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
