How Do I Select Table Values With Database Name

Question

1.00/5 (1 vote)

See more:

SQL

create database test;
create table table1(id bigint,name nvarchar(max));
insert table table1 values(1,'griff');
insert table table1 values(2,'sergey');
insert table table1 values(2,'king');
insert table table1 values(2,'fisher');

and i am expecting
select *From table1

SQL

id name       database
1  griff      test
2  sergey     test
3  king       test
4  fisher     test

how can i Select this.
Thanks ;)

Posted 6-Mar-14 19:28pm

King Fisher

Updated 6-Mar-14 19:32pm

v2

Add a Solution

Comments

SViki 7-Mar-14 1:53am

I think u are asking that you should mention the database name in the query?
If that is your question you don't need to worry about it.your connection string will take care of it.

King Fisher 7-Mar-14 1:57am

i wanna select the table records with database name.i want to show in Grid

3 solutions

Solution 1

For SQL Server you can create stored procedure with dynamic query:

SQL

--@table = 'test'
CREATE PROCEDURE GetTableData
    @table VARCHAR(30)
AS
BEGIN

DECLARE @sql VARCHAR(300)


SET @sql = 'SELECT *, ' + @table + 'AS TableName FROM ' + @table 
EXEC(@sql)
GO

END

How to: Execute a Stored Procedure that Returns Rows[^]

Posted 6-Mar-14 20:04pm

Maciej Los

Updated 6-Mar-14 20:10pm

v2

Solution 2

http://www.csharptutorial.in/2013/09/CNet-GridView-Example-How-To-Bind-Gridview-in-Asp.net-using-SQLDataSource-at-Design-time.html#.Uxlvcz-SzvA

Hope this will be helpful.

Posted 6-Mar-14 20:08pm

SViki

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)

Ramug10 · Accepted Answer · 2014-03-06T20:39:00

Solution 3

Use as below

SQL

select  *,db_name() [database] from table1

Thanks,
-RG

Posted 6-Mar-14 20:39pm

Ramug10

Comments

King Fisher 7-Mar-14 2:44am

hats off..:)

Ramug10 7-Mar-14 2:47am

Thanks King....:)