pascal_jimi
Posting Yak Master
167 Posts |
Posted - 2013-07-24 : 01:55:09
|
hi this text works finedeclare @ph int,@sn intset @ph=11set @sn=8999update yeni_yeniset phone=@phwhere SertiNom=@sninsert phone(phone,telUnvan,ASA,kateqoriya,alamat,cdmaalamet,Teltarix,milliyet,Name,DoYer,DoTarix,SexVes,Elaqe,Odeme,MINIATS,XusKart)selectphone,telUnvan,ASA,alamat,kateqoriya,cdmaalamet,Teltarix,milliyet,Name,DoYer,DoTarix,SexVes,Elaqe,Odeme,MINIATS,XusKart from yeni_yeni where phone=@ph and SertiNom=@snselect*from yeni_yeni where phone=@phselect*from phone where phone=@phbut I write stored proc this querycreate proc nome_ver@ph int,@sn intasupdate yeni_yeniset phone=@phwhere SertiNom=@sninsert phone(phone,telUnvan,ASA,kateqoriya,alamat,cdmaalamet,Teltarix,milliyet,Name,DoYer,DoTarix,SexVes,Elaqe,Odeme,MINIATS,XusKart)selectphone,telUnvan,ASA,alamat,kateqoriya,cdmaalamet,Teltarix,milliyet,Name,DoYer,DoTarix,SexVes,Elaqe,Odeme,MINIATS,XusKart from yeni_yeni where phone=@ph and SertiNom=@snexec nome_ver @ph=5505502 ,@sn=5555555555555excute stored proc get me errorMessage 8114, Level 16, State 4, the procedure nome_ver, row 0Error converting data type numeric to int.kmkmmm |
|