Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 sql query in if exists

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-10-17 : 07:50:49
manisha writes "2 tables inbox(mobile no,mssg),mssg(srno,mssg,comment)
as mobileno comes it get serched in table inbox if not exixts then send 1st mssg from table mssg,and insert the mobile no and mssg in inbox(mobile no,mssg),
if mobileno exists in table inbox then count entry for particular mobileno n select (count+1) mssg from table mssg n again insert this entry in inbox. "

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-24 : 03:19:49
Learn SQL

http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -