Please provide your select query.........

Thank you all,

I have decided to do MCTS for SQL Server 2008.

Kindly let me know if there is any fine study material or site .

You can create a same table in Database7, and a before update trigger on tableA (in every database, if the filed is not updated in all tables at the same...

Hi All,

Thanks for you valuable advice. I have visited this link: http://www.microsoft.com/learning/mcp/certifications.mspx

And according to that, if i want to have certificate in 2005, then i need to apply...

Actually the installation order effects a lot. You need to install

1) IIS 7

2) .NET framework 3.5

3) SQL Server 2008

4) Visual Studio 2008

Please check your installation order (also check your version...

Yes champion(Steve), you are right! But that's my confusion point.

Actually, I have experience in SQL Server 2005 as we are using it (earlier we were using 2000). But now we...

Sorry, it was my mistake... 🙂

I am software developer and having experience in SQL Server for more than3 years. Now, i wanted to have certification in sql.

Yes Jack,

I am also feeling something missing in code!

@arup_kc

can you flash some more lights on this topic? Pls provide some more details..

I m really very eager to know abt it...

Ok. so pointer is again come to first question of this post.

Why it is giving error in his execution?

@VIJAYA

GO is not a Transact-SQL statement; it is a command recognized by the sqlcmd and osql utilities and SQL Server Management Studio Code editor.

SQL Server utilities interpret GO...

ohh it was totaly my mistake... pardon for that.. 😀

the code is working... 🙂

Is this because INT is 32-bit signed integer and BIGINT is 64-bit signed integer..?

INTEGER: The JDBC INTEGER type represents a signed 32-bit integer. This maps to a SQL Server int...

Will this work?

declare @sample table (Status varchar(10), State varchar(20), Name Varchar(10))

insert into @sample

select 'Pending', 'Nebraska', 'ABC' union all

select 'Pending', NULL, 'XYZ' union all

select 'Active', NULL, 'PQR'

select *

from @sample

where state...

In sql server 'Go' will apart all statment in a single execution into multiple batches. The batch till first Go statement will execute first, and till second Go statement will...

Hi all,

sorry for the delay in reply...

by "multi languague" mean - I have many applications if different languagues, some are not using any .NET frame work.. but most of...