Use it like this:

SELECT SERVERPROPERTY('ProductLevel') as SPVersion

You can use SERVERPROPERTY function to get the details of SP..

I cant think of anyway apart from back-ups.. as u said no back-ups and u dint open an explicit transaction, then i'm afraid your data is lost..

Vijay, are u sure apart from "Loading", nothing can be done through BCP ? 🙂

There is a switch called "queryout"...

BCP is faster than linked server...

1. First BCP out data into csv file from Server1

2. copy the csv file into server2

3. Then BCP in the same file into Server...

Put both the queries u have in a CROSS JOIN... match using proveedor.nombre.. this will give u what u want.. if u cant yet figure out how, drop a reply...

Exactly my point as well.....

I am bit unclear on the question. buddy.... can u please show some visual samples of your data??

A shot in the dark, u may use CROSS JOIN to displace results...

Will there be only 3 students or u have got more students ??

due to the fact that u used NVARCHAR... NVARCHAR is double length as that of VARCHAR... try changing it to VARCHAR and u will get ur result..

Hello Mahesh, is it some sort of Homework u are working on? You sorted out that it is "PIVOT"ing.. so you would have attempted some code right? can you post...

As in

declare @ch1 Nchar

declare @ch2 Nchar

select @ch1=N'?'

select @ch2=N'?'

IF(@ch1=@ch2)

print 'we are same'

else

print 'We are different'

Hope this helps

Instead of CHAR try using NCHAR..

No we can not.. FOR clause if used to...

This is due to the 35th character...