Click here to Skip to main content
15,867,686 members
Home / Discussions / Database
   

Database

 
AnswerRe: problem with sql server 2008 - cant change field type Pin
Md. Marufuzzaman13-Sep-09 4:38
professionalMd. Marufuzzaman13-Sep-09 4:38 
GeneralRe: problem with sql server 2008 - cant change field type Pin
E_Gold13-Sep-09 9:21
E_Gold13-Sep-09 9:21 
AnswerRe: problem with sql server 2008 - cant change field type Pin
εїзεїзεїз13-Sep-09 5:59
εїзεїзεїз13-Sep-09 5:59 
QuestionRegaring Establishing Connection with sqlserver. Pin
dayakar_dn12-Sep-09 8:35
dayakar_dn12-Sep-09 8:35 
AnswerRe: Regaring Establishing Connection with sqlserver. Pin
dan!sh 12-Sep-09 8:56
professional dan!sh 12-Sep-09 8:56 
AnswerRe: Regaring Establishing Connection with sqlserver. Pin
εїзεїзεїз12-Sep-09 10:20
εїзεїзεїз12-Sep-09 10:20 
AnswerRe: Regaring Establishing Connection with sqlserver. Pin
εїзεїзεїз12-Sep-09 12:00
εїзεїзεїз12-Sep-09 12:00 
QuestionWhats wrong with this query Pin
AndreFratelli12-Sep-09 7:47
AndreFratelli12-Sep-09 7:47 
I have the following table (ccpoc)

poc_cod varchar(10)
poc_cod_asc varchar(10)
poc_desc varchar(40)


With the following data
poc_cod poc_cod_asc poc_desc
1           12         Coiso
1           13         Coisa
1           14         Coisinhas


And I'm trying the following query

UPDATE ccpoc SET poc_cod='133', poc_cod_asc='13', poc_desc='Coiso 133' WHERE poc_cod='13' AND poc_desc='Coiso 13' AND poc_cod_asc='1'

I'm querying the server with an ExecuteNonQuery in C#, and everything seems to go fine. No errors, no exceptions, everything runs well. The problem is that data in the table does not change!

Anybody has any idea what might be happening?

Best regards

Fratelli

AnswerRe: Whats wrong with this query Pin
dan!sh 12-Sep-09 7:58
professional dan!sh 12-Sep-09 7:58 
AnswerRe: Whats wrong with this query Pin
Luc Pattyn12-Sep-09 8:14
sitebuilderLuc Pattyn12-Sep-09 8:14 
GeneralRe: Whats wrong with this query Pin
AndreFratelli12-Sep-09 14:49
AndreFratelli12-Sep-09 14:49 
AnswerRe: Whats wrong with this query Pin
εїзεїзεїз12-Sep-09 10:28
εїзεїзεїз12-Sep-09 10:28 
QuestionAuto reconnect to MySql when connection is lost after period of inactivity Pin
Bil@l12-Sep-09 5:13
Bil@l12-Sep-09 5:13 
AnswerRe: Auto reconnect to MySql when connection is lost after period of inactivity Pin
dan!sh 12-Sep-09 8:00
professional dan!sh 12-Sep-09 8:00 
GeneralRe: Auto reconnect to MySql when connection is lost after period of inactivity Pin
εїзεїзεїз12-Sep-09 10:40
εїзεїзεїз12-Sep-09 10:40 
GeneralRe: Auto reconnect to MySql when connection is lost after period of inactivity Pin
dan!sh 12-Sep-09 19:07
professional dan!sh 12-Sep-09 19:07 
GeneralRe: Auto reconnect to MySql when connection is lost after period of inactivity Pin
εїзεїзεїз12-Sep-09 19:39
εїзεїзεїз12-Sep-09 19:39 
AnswerRe: Auto reconnect to MySql when connection is lost after period of inactivity Pin
εїзεїзεїз12-Sep-09 10:37
εїзεїзεїз12-Sep-09 10:37 
QuestionWant to split variable in SQL[modified] Pin
xodeblack11-Sep-09 23:23
xodeblack11-Sep-09 23:23 
AnswerRe: Want to split variable in SQ Pin
εїзεїзεїз12-Sep-09 4:44
εїзεїзεїз12-Sep-09 4:44 
AnswerRe: Want to split variable in SQ Pin
tagyurit12-Sep-09 5:18
tagyurit12-Sep-09 5:18 
AnswerRe: Want to split variable in SQ Pin
Abhishek Sur12-Sep-09 13:21
professionalAbhishek Sur12-Sep-09 13:21 
AnswerRe: Want to split variable in SQ Pin
PIEBALDconsult14-Sep-09 7:09
mvePIEBALDconsult14-Sep-09 7:09 
QuestionSQL Import Help Pin
Hulicat11-Sep-09 5:38
Hulicat11-Sep-09 5:38 
AnswerRe: SQL Import Help Pin
J4amieC11-Sep-09 5:59
J4amieC11-Sep-09 5:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.