This is totally depend on the future choice, if a person want to become a technical manager/consultant should go for MCA else may go for MBA IT.

This link may help you:

http://bytes.com/topic/sql-server/answers/531936-how-convert-rows-into-columns

Yeah...

I agree.

You are right, i was having the doubt on the same but i cross verified the same.

nvarchar(max) can store upto 2GB

This is also a good way to find User defined data/table types.

Reply is:

How the SP insert all those row to the database, and return rowcount? -> SP will insert a single row at a point of time and it returns rowcount...

Hi Dave, You are right that "it is giving you the error is because you are trying to assign multiple values to a single row." But if this is the...

Hi,

You can see the user defined table types (UDTT) under database in which the UDTT is executed, for full path please follow the below instructions:

Goto your database -> Programmability...

Hi,

Please use below query, surely it will work for you... 🙂

update test set country_sub = (substring(country,1,4)) from test t where t.country like '%ENGLAND%' AND t.country = country