IT Professionals

Dear

Can we use this thread for any IT related discussions, ranging from Software development, Maintenance, support, Networking, and hardware (client/Server) issues.

Please post your questions here to get going

I remember there was a thread with same title :roll:

can't find it any more :(

My bro accidentally uninstaled google chrome...I've reinstalled it but is there any way to recover my lost bookmarks... renaming bookmarks.bak din't work...

Quote:

---

Originally Posted by dev

My bro accidentally uninstaled google chrome...I've reinstalled it but is there any way to recover my lost bookmarks... renaming bookmarks.bak din't work...

---

Devuda

What version of windows is that? there should be tool in windows that allows you to recover lost data!

Raghu, it's XP...

does any one know the 'DOS' to find a list of Servers on given domain?

I prefer DOS over VB script :)

cmd > net view

not very sure though :lol:

Quote:

---

Originally Posted by Raikkonen

cmd > net view

not very sure though :lol:

---

sorry, i wanted to find the number of SQL server 2008 on windows 2003.. but your command will give all the windows server, any way

if you type in OSQL -L would give you the list, but if you want to complicate things, like i alwys do :lol: the following SQL script will do

/* Gives a list SQL servers on a given domain */

CREATE PROCEDURE dbo.ListLocalServers
AS
BEGIN
SET NOCOUNT ON

CREATE TABLE #servers(sname VARCHAR(255))

INSERT #servers EXEC master..XP_CMDShell 'OSQL -L'
-- play with ISQL -L too, results differ slightly

DELETE #servers WHERE sname='Servers:'

SELECT LTRIM(sname) FROM #servers WHERE sname != 'NULL'

DROP TABLE #servers
END

exec ListLocalServers

i don't have any servers installed at my home.. :oops:

i will try to read and understand this at office :lol:

Quote:

---

Originally Posted by Raikkonen

i don't have any servers installed at my home.. :oops:

i will try to read and understand this at office :lol:

---

enNa try paneenghala :lol:

r u SQL server Developer?? I am one :D

ileeng :lol: sorry..

i'm more into network/web programming. :)

just got the mcse cert.. but not very familiar with sql server.

Quote:

---

Originally Posted by Raikkonen

ileeng :lol: sorry..

i'm more into network/web programming. :)

just got the mcse cert.. but not very familiar with sql server.

---

Oh cool. so u can do java scripting and .net programming right :) , if i have any doubts i shall ask, cos .Net & sql server are highly integrated , they work very closley :D

cool..

i haven't worked with java for some years now. i can do the applets etc.. almost in advanced stage.

ya. i'm working in net environment. :thumbsup:

Raiks

aama neenga enna 'Diamon' smuggling busniess panrEla?? Diamon hubber nu title kudithirukuranga :lol2:

Hi

I have SQL table with a customer table in SQL server , having columns (name, lastname)
the last name contains values like (o'corner, o'brian) how would i search for these records iusingT-SQL

Select * from customers
where lastname like 'O'coner%'

it does not work cause of the single quote bewteen O and C... any way round it?

Raiks??

Add another apostrophe. Something like,

Code:

---

select * from customers
where lastname like 'O''CORNER%'

---

Paramasivan,
This is for you :
http://blog.sqlauthority.com/2008/02...racter-string/

To add to Nerd's post, if you're going to call the sql from a webpage etc, this kind of concatenation could pose sql-injection threat and this link gives a solution for that :
http://it.toolbox.com/wiki/index.php...SQL_queries%3F

Quote:

---

Originally Posted by Nerd

Add another apostrophe. Something like,

Code:

---

select * from customers
where lastname like 'O''CORNER%'

---

---

Danks Nerd :)

Quote:

---

Originally Posted by app_engine

Paramasivan,
This is for you :
http://blog.sqlauthority.com/2008/02...racter-string/

---

Danks, This guy is a SQL guru :notworthy:

Does any one know how to convert 'american date format' to 'british date' format in SQL server , without changing the coalltion??

ssabbaa I figured it out

here goes

SELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY]

linux experts, how to share internet btw 2 laptops running ubuntu, thru wifi?

Sorry sakala , I am no linux expert

friend of mine - suggested

Quote:

---

never envounted patterns like O', which is normally used to concatinate the strings in SQL. fpr normal names '%name%' should work.

---

Is it working ?

aana

Unga avatar and signature :notworthy:

:ty:

Is any one familiar with the hardest thing in SQL code, known as Cursor? :banghead:

I will explain what I need to do..

I have table A , and Table B

Table A Table B
--------- ------------

First_name First_name
Last_name Last_name
Address1 Address1
Adreess2 Address2


What I want to do, see if the firstname and last_name in Table B exist in Table A, if so then I want to update Address1 and address2 in table A with a value. This is easy to do for couple of rows.

using

Update Table A
set address1='test',
address2='test2'
where first_name in (select first_name from table B
where first_name like 'Super')


but the problem is in Table B , i have 10,000 first_name with values in the address1.. I need update table A9Address1) with a value based on table B's contact name, hence you end up with 10,,000 different names, with 10,000 different address, if it was just one addreess it would have been very easy, I can use the above script.

any ideas any one ?

Checking whether the first name / last name exists in table B is no big deal (for set processing, use EXISTS clause)

OTOH, if you have 10000 NEW addresses to be updated to table A, you got to STORE those addresses in a table (unless the requirement is to directly update from a flat file, then you need a script). Obviously, this flat file or table with new address should have the name reference as otherwise how you're going to relate?

Quote:

---

Originally Posted by app_engine

Checking whether the first name / last name exists in table B is no big deal (for set processing, use EXISTS clause)

OTOH, if you have 10000 NEW addresses to be updated to table A, you got to STORE those addresses in a table (unless the requirement is to directly update from a flat file, then you need a script). Obviously, this flat file or table with new address should have the name reference as otherwise how you're going to relate?

---

:? what is that?

abbreviation for "on the other hand"

Quote:

---

Originally Posted by PARAMASHIVAN

Is any one familiar with the hardest thing in SQL code, known as Cursor? :banghead:

I will explain what I need to do..

I have table A , and Table B

Table A Table B
--------- ------------

First_name First_name
Last_name Last_name
Address1 Address1
Adreess2 Address2


What I want to do, see if the firstname and last_name in Table B exist in Table A, if so then I want to update Address1 and address2 in table A with a value. This is easy to do for couple of rows.

using

Update Table A
set address1='test',
address2='test2'
where first_name in (select first_name from table B
where first_name like 'Super')


but the problem is in Table B , i have 10,000 first_name with values in the address1.. I need update table A9Address1) with a value based on table B's contact name, hence you end up with 10,,000 different names, with 10,000 different address, if it was just one addreess it would have been very easy, I can use the above script.

any ideas any one ?

---

Update A set address1=B.Address1,address2=B.address2
from TableA A, Table B B where A.FirstName=B.FirstName

Hope this helps

Nice to see this thread in this forum.

கிறுக்கன்

Quote:

---

Originally Posted by kirukan

Quote:

---

Originally Posted by PARAMASHIVAN

Is any one familiar with the hardest thing in SQL code, known as Cursor? :banghead:

I will explain what I need to do..

I have table A , and Table B

Table A Table B
--------- ------------

First_name First_name
Last_name Last_name
Address1 Address1
Adreess2 Address2


What I want to do, see if the firstname and last_name in Table B exist in Table A, if so then I want to update Address1 and address2 in table A with a value. This is easy to do for couple of rows.

using

Update Table A
set address1='test',
address2='test2'
where first_name in (select first_name from table B
where first_name like 'Super')


but the problem is in Table B , i have 10,000 first_name with values in the address1.. I need update table A9Address1) with a value based on table B's contact name, hence you end up with 10,,000 different names, with 10,000 different address, if it was just one addreess it would have been very easy, I can use the above script.

any ideas any one ?

---

Update A set address1=B.Address1,address2=B.address2
from TableA A, Table B B where A.FirstName=B.FirstName

Hope this helps

Nice to see this thread in this forum.

கிறுக்கன்

---

Thanks kirukan, I will give it a go and see 8-)

Any one here good at SQL 2008 / 2005 SSRS :huh:

Rita Mulcahy passed away :

http://www.theicpm.com/certification...ect-management

(Excellent author of PMP training books)

Quote:

---

Originally Posted by sakaLAKALAKAlaa Vallavar

linux experts, how to share internet btw 2 laptops running ubuntu, thru wifi?

---

SKV, this is a late response but have you tried this link?

http://www.ubuntugeek.com/sharing-in...in-ubuntu.html

Quote:

---

Originally Posted by app_engine

Rita Mulcahy passed away :

http://www.theicpm.com/certification...ect-management

(Excellent author of PMP training books)

---

RIP, her book helped me a lot in earning the PMP certification. Really a big loss for Project Management Community :-(

my hotmail account is infect, it is sending out automnatic messages to all the ppl in my contact list,

how do i stop this crap :banghead: pls help :cry2:

Quote:

---

Originally Posted by PARAMASHIVAN

my hotmail account is infect, it is sending out automnatic messages to all the ppl in my contact list,

how do i stop this crap :banghead: pls help :cry2:

---

Temporarily remove the contact list. (You can add them later once this menace dies down)

Also, immediately change your password!