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.
My case is
Input is "abdknmgbm".
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.
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.
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
Hi everyone! I need to know the maximum number of concurrent connections to SQL Server 2008. When I check from Server properties in Management Studio, it is set to zero with a text description that zero means unlimted connections.
I cannot comment on the number of connections, but in your design, you might want to consider a 3 Tier approach where each client does not have a direct connection to the database; only the middle tier would connect. This would greatly reduce the number of connections to the database.
I need to know the maximum number of concurrent connections to SQL Server 2008
Why would your database need to handle that many connections?
At any rate if you have a windows server which is going to run an application (regardless of the applications running) that needs to handle a lot of connections then the server itself must be configured for that.