Search:

I have existing table it has two columns one column datatyps is int
i want to alter that int column to identity colum
now i have datain that table
how this is possible to alter to identity column

oracle has for update concept is there
in same way is there same concept in SQL server 2005
Please give example

How to link between servers

I have two servers both servers have some databases
if i want to access from one server database table to other server database table
how it possible in SQL Server

i am having one table
here username is there i want to create it as unique
how can

Actually i send as table formate
but its came as like that

any way
i am getting some aggrigate values cites and years
i want like this, city name column

By useing one query i am getting data like this (here members are aggregate value) members city year 1000 bhel 2008 3000 guntur 2008 5000 hyderabad 2008 50 janana 2008 786876 karimnagar 2008 2000...

I got the answer for question


select datename(month, dateadd("month",-1,getdate())), datename(month, dateadd("month",-2,getdate())),
datename(month, dateadd("month",-3,getdate()))

How can i get last there previous month names by useing system date