the feature exists in sql server 2008 ,now

thanks all

kindly help some more

querry given above for inner join works a bit if i add distinct(t1.A) ..

but not fully

hay all

Well i want relation to be generated on the attribute 'A' of both the tables. but in both table A does not include any keys. and its stated that...

thaks so much,, it worked

thanks for ur valueable time n support

but is there any other way to find the name of tables got affected by last procedure

coz, m using SQL Server 2005 bt unable...

thanks

well m doing same thing i thought there cud be some other better n short method. my emphasis was to change transaction tables too. coz thre are no of transaction...

hi

to take bakup of oracle databae, use file starting with 'imp' . It must be residing in 'bin' folder inside the folder containing oracle.

thanks all , i made it. i used 'and' as

field_no like '%[^0-9/]%' and field_no not like N'%???%'

and it worked . thanks for all help

hay hari ,

Thanks

i have sql server 2005 bible

bt u didnt get my problem

i want query to search 123.56a or 125.7?

thanks so much mike, it worked. now plz elaborate the query from accepting \ to some other char too

say 0-9, \ , a , d...

thaks manu

ur querry worked very well

thanks all,

actually i found the answer,

use simple querry

select c.name, c.id, o.name from syscolumns c join sysobjects o on o.id =c.id where c.name='student_name'

use

strt->> programs ->>sql server->> configuration tools ->> sql server configuration manager

now

choose

sql native client configuration->> client protocols

sahred memory - enabled

tcp/ip -- enabled

named pipes -- enabled

via --disabled

yes ur idea worked upto some extent

Thanks so much