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 |
|
ranjit.chaturvedi
Starting Member
2 Posts |
 Posted - 2011-05-25 : 16:08:52
|
| I have a database which contain a table sde_layers which has the table name for all the tables inside the database.Each table contains objectid filed and shape field.I want a query to get the objectid field and shape field of all the tables where shape=null with the help of sde_layers table so that I dont need to run seperate query to find the null values for each table. |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-05-25 : 16:16:07
|
| Where ColumnName IS NULL CheersMIK |
 |
|
|
ranjit.chaturvedi
Starting Member
2 Posts |
Posted - 2011-05-26 : 15:43:11
|
| But first I need to get the names of the tables from the sde_layers table then only I can check for this.I need some subquery which will get the names of the table from the sde_layers and then will check for Null values in the corresponding table.. |
|
|
|
jfarrugia
Yak Posting Veteran
55 Posts |
Posted - 2011-05-27 : 02:44:35
|
| The below will give you column names for your table:SELECT * FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'sde_layers'Where software development knowledge meets the reader |
|
|
|
|
|
|
How to find Null values in SQL Server