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.
| Author |
Topic |
|
jogin malathi
Posting Yak Master
117 Posts |
 Posted - 2007-06-18 : 07:38:44
|
| hi allCan we use trignometric functions in stored proceduresor in database(back end) side instead of using those functions in frontendThanks in AdvanceMalathi Rao |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-18 : 07:43:15
|
| Yes. you can and you should. Front-end is ideally meant only for the presentation of the data in desired format and trignometric functions has nothing to do with the formatting of the data, but with the processing of data itself.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
jogin malathi
Posting Yak Master
117 Posts |
Posted - 2007-06-18 : 07:57:48
|
quote:
Originally posted by harsh_athalye
Yes. you can and you should. Front-end is ideally meant only for the presentation of the data in desired format and trignometric functions has nothing to do with the formatting of the data, but with the processing of data itself.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
Thank Youhow can i write trognometric functions in select query or in stored procedures.I mean are there any built_in functions for trignometrics functionsMalathi Rao |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-18 : 08:04:30
|
| Yes. There are built-in trignometric functions:[url]http://msdn2.microsoft.com/en-us/library/ms191457(sql.90).aspx[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
RocketScientist
Official SQLTeam Chef
85 Posts |
Posted - 2007-06-27 : 13:59:03
|
| There are the typical built-in functions you'd expect (sin(), cos(), tan()). They take input in radians in float, and output you'd expect. The biggest limitation is that they are float precision, if you need more than that you'll have to look elsewhere. Trigonometric functions are deterministic. |
|
|
|
|
|
|
Trignometric functions