Forum: MS SQL  Apr 30th, 2008 |
| Replies: 1 Views: 2,429 1) INNER JOIN---I know
2)OUTER JOIN--I know
3)CROSS JOIN--I know
4)THETA JOIN--????
5)SELF JOIN--?????? |
| Forum: MS SQL Apr 10th, 2008 |
| Replies: 2 Views: 1,234 Thx,It worked.
Plz see the following query-
SELECT * FROM mail3
WHERE email NOT LIKE '%@%'
or email not like '%&%'
Instead of showing the particular records ,the above query is displaying... |
| Forum: MS SQL Apr 9th, 2008 |
| Replies: 2 Views: 1,234 --Que-4)Create a Query to pull all emails that contains
--characters +,^,*,&,!
create table mail3(email varchar(50))
insert into mail3 values('mansi.sharma@yahoo.co.in')
insert into mail3... |
