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
 General SQL Server Forums
 New to SQL Server Programming
 Trigger

Author  Topic 

vedjha
Posting Yak Master

228 Posts

Posted - 2010-03-03 : 03:40:34
Hello Sir,
I have to send SMS in mobile using trigger. mobile SMS in a link then As Value insert in table SMS goes in mobile internal process.

Then my problem is How to open any link in SQL.

Thank You

http://kiransoftech.com

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-03-03 : 05:43:16
You can store the link in database and can open the link in your front end application

Vabhav T
Go to Top of Page

vedjha
Posting Yak Master

228 Posts

Posted - 2010-03-03 : 08:16:20
how

http://kiransoftech.com
Go to Top of Page

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-03-03 : 08:19:26
As this is the sql server forum so if you are asking how you can open any link in front end
nobody is going to tell you i suppose.

Vabhav T
Go to Top of Page

vedjha
Posting Yak Master

228 Posts

Posted - 2010-03-03 : 08:40:56
I am fetching value from database and ond open a link in frame . it is possible. but i am asking u , without using front end I have to send SMS at mobile. so i am asking how to open link using SQL SERVER



http://kiransoftech.com
Go to Top of Page

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-03-03 : 08:53:34
But why you want like this any specific reason or just want to know whether it is possible or not..

Vabhav T
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-03 : 09:13:57
http://www.siccolo.com/Articles/SQLScripts/how-to-create-trigger-to-sms-email.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

vedjha
Posting Yak Master

228 Posts

Posted - 2010-03-03 : 09:16:13
Actually when I am using Front end some time SMS goes and maximum time it does not go. so I am thinking that as value indsert in database trigger fire e-mail process , it having maxm speed and 99.9 %age to go e-mail. but from front end- side it may be 50-50 . so i want to send SMS using Database

http://kiransoftech.com
Go to Top of Page

vedjha
Posting Yak Master

228 Posts

Posted - 2010-03-03 : 09:18:17
my question is very Simple that How to call google.com using SQL Server

http://kiransoftech.com
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-03 : 09:23:18
quote:
Originally posted by vedjha

my question is very Simple that How to call google.com using SQL Server

http://kiransoftech.com


why do you want this logic to be done from your RDBMS?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

vedjha
Posting Yak Master

228 Posts

Posted - 2010-03-08 : 12:32:34
to Fast The Process

http://kiransoftech.com
Go to Top of Page

vedjha
Posting Yak Master

228 Posts

Posted - 2010-03-08 : 12:53:09
I have Find a query as
javascript:void(window.open('http://www.google.com','_blank'))

as i execute it , it gives me an exception as

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'void'.


but as i click it as (ctrl+click ) then it open site in new tab.

------------------


But I want no tab will open , but it will be process my requirement or Send SMS

http://kiransoftech.com
Go to Top of Page
   

- Advertisement -