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 |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2005-10-21 : 11:49:00
|
| In one of our project the client is asking us to stick to ANSI SQL Scalar functions instead of T-SQL's own functions (Current_Timestamp instead of getdate()).Any place where I can get this kind of equivalent function details.Searched google, but couldnt find much.ThanksKarunakaran |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-10-21 : 13:03:51
|
| You should be able to get hold of the SQL-92 ? spec, not sure if that is very helpful though.If you are ONLY allowd to use ANSI sql functions you will be limited in functionality.Edit:?? what's this ?? usability seems limited...SET FIPS_FLAGGER OFFSET FIPS_FLAGGER 'FULL' |
 |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-10-22 : 07:17:35
|
quote:
Originally posted by rockmoose
You should be able to get hold of the SQL-92 ? spec, not sure if that is very helpful though.If you are ONLY allowd to use ANSI sql functions you will be limited in functionality.
The clients insists use where ever possible instead of built-in function.Karunakaran |
|
|
|
|
|
|
SQL Scalar Functions