add sno coloum and row sno in sql table

Question

add sno 1 to end of the coloum 

i have table like ...
400000 laks rows  in my table 

name   address      id    location
raju     hyd         6789    hyd
vamshi   vizag      9876   hashinapur

o/p like
i want insert sno coloum and sno 1 to 400000

sno      name          address       id      location   
1          raju             hyd          6789      hyd
2        vamshi          vizag        9876     hasthinapur  
3
4
5
6
..
.
.
.
.
40000

Answer 1

Try this. " Salamander .NET Linker and mini-deployment tool allows you to link .NET assemblies together into a single file, and to deploy your application without installation of the whole Microsoft .NET Framework. The linker selectively links MSIL code putting together only the required classes and methods, and it is capable of linking into the Microsoft .NET framework class libraries. The mini-deployment tool then builds a minimum set of the Microsoft .NET runtime to ship with your application. This usually results in installation size of a few mega bytes, rather than tens of mega bytes, and the installation takes much less time without rebooting machines. The mini-deployed application can be launched directly from a CD, absolutely without copying files or adding registry entries." Regards KevinT

Answer 2

thanks for your replies.. i just thought, that it would be possible, to bind the methods and modules which i need into the .exe so that the exe grows, but obviously it is not possible - what a pity thx maschka

Answer 3

Dynamic and static binding are terms of how the libraries of the runtime are loaded at runtime. Neither of these have to do with linking runtime libraries inside the executable.

Answer 4

In the same way that you couldn't run a program coded to the Win API on a non-Windows machine, a program coded to the .NET framework needs the .NET framework.