getting table name with defined cell of defined column is blank

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hi Friends,
I am unable in getting table name with defined cell of defined column is blank in sql.
Can anyone help me.
Thanks,
Akkywadhwa

Posted 12-May-12 7:15am

Akkywadhwa

Add a Solution

Comments

Akkywadhwa 14-May-12 12:08pm

Consider 2 tables named name1 and name2 in database xyz.These tables contain time-table schedule of a teacher tells him/her that in which class he/she has to go in the specified 8 period in 6 days.And some of them are free too.Cells are denoting free periods by null values.So, I need to retrieve the tables names that is name1 and name2 by applying query that:

Give me those table names which contain null values in period 3 on day 4.
Please help me out as soon as it could be possible.
Regards,
Akkywadhwa

2 solutions

Solution 2

To get table name by column name, use this:

SQL

SELECT t.name As TableName, c.Column_Name
FROM sys.tables t INNER JOIN information_schema.columns c ON c.Table_Name = t.Name
WHERE [Column_Name] = @ColName

Posted 12-May-12 11:38am

Maciej Los

Updated 13-May-12 0:19am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2012-05-12T07:32:00

Solution 1

Do you mean that when you query data from a table you don't get results if the value in the column is empty? If that's the case then you must use IS NULL condition in your query. For example

SQL

SELECT * FROM TableName WHERE ColumName IS NULL;

Posted 12-May-12 7:32am

Wendelius

Comments

Akkywadhwa 12-May-12 14:25pm

I can't specify table name in my query as i have to retrieve it.
Example:
There is a table named akky which has 2nd colums 3rd cell empty then it must return me akky.
Note: Value of column and row is specified by me.
Thanks,
Akkywadhwa

Wendelius 12-May-12 14:59pm

Now I don't quite understand. When you select from a table, you need to know the table name. For example:

SELECT * FROM Akky

Also you have two columns in your table, but what is third cell? Do you mean third row? If that's the case, then you should define the order based on something. Basically the rows in the table are in no specific order.

Could you clarify this with an example and post the query you have so far.

Akkywadhwa 14-May-12 12:06pm

Consider 2 tables named name1 and name2 in database xyz.These tables contain time-table schedule of a teacher tells him/her that in which class he/she has to go in the specified 8 period in 6 days.And some of them are free too.Cells are denoting free periods by null values.So, I need to retrieve the tables names that is name1 and name2 by applying query that
Give me those table names which contain null values in period 3 on day 4.
Please help me out as soon as it could be possible.
Regards,
Akkywadhwa

Wendelius 14-May-12 14:24pm

This doesn't quite make sense. Most likely this is a terminology problem, but table cannot be null (unless it's a table variable). Table is the persistent entity in database containing the rows (zero or more). Table is created using a CREATE TABLE statement. Table has at least 1 but possibly more columns. The values in columns can be null (empty).

So are you trying to find the rows containing a null value in a specific column? Please list the table structure. It would help a lot solving this issue.