| Author |
Topic |
|
patrickjao
Starting Member
24 Posts |
 Posted - 2011-10-24 : 08:58:28
|
| I am using SQL Server Enterprise Manager "View" facility to create query ; I have difficulty to do the the subtraction/or addition of 2 field in 2 tables, just because there are NULL value in the field. in ACCESS there are Nz() function to solve this problem, Please advice there are similar function in sql server?Best RegardsPatrick |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-10-24 : 09:00:02
|
use ISNULL( <column name> , 0 )
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
patrickjao
Starting Member
24 Posts |
Posted - 2011-10-24 : 12:21:56
|
| Well done, thanks, how about "Iif" function in Sql? |
|
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-24 : 13:15:06
|
| IIF is present in VB I guess, not in SQL. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
patrickjao
Starting Member
24 Posts |
Posted - 2011-10-24 : 23:05:56
|
| Are there any link table facility for SQL server? I want to link 1 table in database to other's database. I can link SQL table to ACCESS using ODBC, but I couldn't find the link table facility in SQL |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
patrickjao
Starting Member
24 Posts |
Posted - 2011-11-03 : 05:10:43
|
| How to combine the auto number id with the text to become a text ; for example ABC + 0001 = ABC0001 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
SQL Enterprise Manager Function