|
will u plz suggest me some websites for this ....actually i know how to use joins triggers sp's and other things but i am not confident what i need is a perfect definations for all these
thank u for reply
Happy new Year
Regards
Sindhu tiwari (software developer MIS)
its me sid
|
|
|
|
|
|
vimal
a simple thing which i forgot ...help me out plz
i am having a table a datagrid view so i am displaying the data in that datagrid view now i want to update the table thru the datagrid view
so how to do this ...
if u know this then plz do let me know
regards
sindhu tiwari
its me sid
|
|
|
|
|
For this u need to code in front end languages like Dot net....
If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt
|
|
|
|
|
hello,
how can i create a password protected sql 2005 database
|
|
|
|
|
|
my mean is set password for windows database not for mobile
|
|
|
|
|
Name varchar(100) Unique,
How many Unique key we can have in a table in SQL Server
|
|
|
|
|
The Knowledge wrote: Name varchar(100) Unique,
How many Unique key we can have in a table in SQL Server
More than you'll ever need. Seriously.
|
|
|
|
|
Using only capital letters and no numbers, 26^100, or a 142 digit number, starting with a 3. Far more than any server you could build today can hold. The hard disk space requirements alone staggers the mind.
Were you looking to create a record for every grain of sand on Earth??
|
|
|
|
|
Dave Kreskowiak wrote: Were you looking to create a record for every grain of sand on Earth?
What an undertaking that would be
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Dave Kreskowiak wrote: 26^100
Uhm... Case insensitive?
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
[my articles]
|
|
|
|
|
Hi! there is a stored procedure containing 3 input parameter & 2 output parameters. now i want to write a sql query that lists parameters as well as their parameter types & data type for a particular sotred procedure. can any help me in this regards?
|
|
|
|
|
SELECT * FROM INFORMATION_SCHEMA.PARAMETERS
|
|
|
|
|
|
Can anyone define Difference between Candidate Key and Unique Key
|
|
|
|
|
|
Hi all,
I wan`t to implement the did you mean functionality just like what google search provides
for eg when i search madona its should show "did you mean 'madonna'" how do we implement phonemes
in sql 2000???
When you fail to plan, you are planning to fail.
|
|
|
|
|
www.Developerof.NET wrote: for eg when i search madona its should show "did you mean 'madonna'" how do we implement phonemes
in sql 2000???
Create a table of synonyms? If you put in a known bad spelling then it can suggest the correct spelling. I would imagine that Google built up its "Didn you mean?" functionality over time by monitoring what people were searching for then seeing that the subsequent search had a search term changed by only a few characters indicating that there was a typo in the previous version.
|
|
|
|
|
SQL has a SOUNDSLIKE function to perform this type of matching. Theres also another function, who's name I can't rememeber which lets your control the 'fuzzyness'. Both these functions turn a word into a code - where Mikael and Michael would return the same code.
You could use this against a wordlist to make suggestions if the number of results is low. If the number of results for a search is high then you can add that to the wordlist. When suggesting you pick the highest & closest match. This will then evolve over time to your unique dataset.
|
|
|
|
|
Have a play around with the SOUNDEX keyword:
SELECT SOUNDEX ('guy'), SOUNDEX ('gi')
I think whoever coded the phonetics was a Spanish speaker as both the following return equal results:
SELECT SOUNDEX ('guy'), SOUNDEX ('gay')<br />
SELECT SOUNDEX ('sh*t'), SOUNDEX ('sheet')
(Can't use swear words on this forum so replace the * with ???)
You can also use the DIFFERENCE keyword as in:
SELECT DIFFERENCE('guy', 'gi')
The result is a number from 0 to 4; 4 being the best match.
Regards
Guy
You always pass failure on the way to success.
modified on Monday, December 31, 2007 8:08:52 AM
|
|
|
|
|
Hi actually i wanted to write a query which will show all the details from a particular time duration to another duration , Like all details between the year 2006 and 2007 and even if the year is same how to select data based on the months. Please help
skd
|
|
|
|
|
Try this
select DateCol from TableName where DateCol between '01/01/2007' and '01/01/2008'
|
|
|
|
|
How many primary key(s) can be set in SQL Server.
Actually i set primary key in 16 columns. Am i right if not please explain
Are Unquie keys and Candidate keys same. And how many Candidated keys we can have in a table
modified on Saturday, December 29, 2007 2:17:10 AM
|
|
|
|
|
Only one primary key per table. You can have as many foreign keys as you want.
Last modified: 22hrs 5mins after originally posted --
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|