I want to link 2 database together, that is database 1 "OMIM" and database 2 "Human" and i want to search the key words from this 2 database... but i can't find it in the book.. can someone help mi out? is urgent.. thx a million.. ...more >>

I have a stored procedure parameter that has a varchar parameter, but the value might be a guid, in which case I need to convert it to a uniqueidentifier (target table has a varchar column and a uniqueidentifier column). How can I test the value to see if it will properly cast to a uniqueidentif...more >>

Monitoring our system during one of its busiest times (only several "hundred" users) we noticed the lock requests/sec on our SQL server was hitting as high as 60,000!!! Is this normal? Or is something in the developers code gone really wrong? Even the average sustained is up in the 5-100...more >>

The last post was 2/4/2006 but when reviewing the sql server forum page 1 starts with 31/3/2006 This tells me there are a couple of days missing So how do I find them - duh? The other 1000 forums start with the latest at the top Is this a trick forum ?? If so, what's the trick ??...more >>

Hello, whats the best way to search the results of running an extended stored procedure? Ie lets say i want to know if a folder called 'microsoft office' is under the programs dir. EXEC xp_dirtree 'C:\Program Files' would a put the results into atemp table? if so how owuld you do tha...more >>

can u help mi with this? my database is called Omim and inside Omim i have 5 tables as i snapshot. i want to search for the key word "LIVER" but it display all the data that not related to the key word "LIVER". can you help mi to solve the below code? it just can't search for the key word "LIV...more >>

I''m reposting this problem because I may not have explained it well enough before. in example 1 below, i've successfully extracted the last name from a full name field, although I've hard-coded the fullname or userName. Example 2 gives the listed error when i run it on my table with data in ...more >>

i got a prolem with the space of my C drive as the dadta bas eis too big for it i am not a llowed to get a bigger disk drive but i am given another one that means i got two small disk drives my data isn't inpputed fully into the database and the disk drive is full . I check the mdf file and fo...more >>

Tried local and also correct name of my machine - still no joy unfortunately (thanks) -- PParker ------------------------------------------------------------------------ Posted via http://www.codecomments.com -----------------------------------------------------------------------...more >>

Hi all I have two simple tables: tClients lID // links to tAddress .lClientID FName LName tAddress lID lClientID // links to tClients.lID Address01 Address02 Address03 etc, etc Anyhow, I am trying to generate a results set that shows my all client ...more >>

Hi there, Say I wanted to create a "compound" type, purely to pass as a parameter to a stored procedure, but one of the components was NTEXT or NVARCHAR(MAX). Say it was something like: - Author NVARCHAR(256) - IP address VARCHAR(16) - Comment NVARCHAR(MAX) How would I go about doing t...more >>

how can i do an insert into a table, only if the record doesnt exist, ie insert into tb1 values ('my name', 'myage', 'mynumber') ...more >>

Hi! I try to use the following "CASE WHEN THEN ELSE" statment in MSSQL (in Excel, with ODBC Excel driver), but won't work. SELECT CASE `table$`.Date WHEN {ts '2004-04-01 00:00:00'} THEN 1 ELSE NULL END FROM `C:\Summing`.`table$` `table$` GROUP BY `table$`.Code Error message: SQL S...more >>

Hi all I used the import utility to move some access tables to a SQL Svr db, and while it all seemed to go AOK, whatever I do the resultant SQL tables appear to be read-only. There are other tables in the SQL db that will read & write OK. Can any one help and tell me how to make the SQL tables ...more >>

Hello there is there a simple way to know if some text has digits on it? ...more >>