Posted on: 9/19/2014 8:08:11 PM | Views : 395

Hi
     If i  have 5 columns in my table  and i wanna keep the primary key column's position at 3rd place , is this possible.?

please compare table and sp

Table : Mapping
SP : AddMap

Table --> Col 1 col2 col 3 col 4 col5      (PhyName, UserName, PhyUserID, IsMsg, IsRX)


alter procedure [dbo].[AddMap]               @PhyName varchar(44) = null, @UserName varchar(50) = '',    @PhyUserID int = null,         @IsMsg bit = 0,               @IsRX bit = 0              As               Begin    ...

Go to the complete details ...