0
HuaMin Chen Posted 18 years ago
Grammar

Any syntax problem with these?

Sincere thanks to you. For Oracle, we have NVL to return another value for NULL values. What's the function for the same purpose, by which we can use for SQL server?

I've checked within SQL server, there're records that should be returned for the selected "trade".

Inside the database, there are some records matching with the conditions.
  

Top answer

Are Oracle and SQL Server two different programming languages? Are you asking what in SQL Server corresponds to NVL in Oracle? If so, you can write this: Oracle has the NVL function to return a non-null value for NULL values.

  • Are Oracle and SQL Server two different programming languages?
  • Are you asking what in SQL Server corresponds to NVL in Oracle?
  • If so, you can write this: Oracle has the NVL function to return a non-null value for NULL values.
  • What is the corresponding function in SQL Server?
  • ___ records that should be returned for the selected "trade"???
Free · every Monday

Get the Weekly English Kit 📬

New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.

1 Answers
0
Are Oracle and SQL Server two different programming languages? Are you asking what in SQL Server corresponds to NVL in Oracle? If so, you can write this:

Oracle has the NVL function to return a non-null value for NULL values. What is the corresponding function in SQL Server?
___
records that should be returned for the selected "trade"??? I don't understand this one.

Related Questions