Click here to Skip to main content
12,620,900 members (35,350 online)
   

Database

 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 20:28
memberMycroft Holmes27-Feb-13 20:28 
GeneralRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 20:43
memberjojoba201127-Feb-13 20:43 
GeneralRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 20:51
memberMycroft Holmes27-Feb-13 20:51 
QuestionRe: sql server table records to sqlite Pin
jojoba201128-Feb-13 3:41
memberjojoba201128-Feb-13 3:41 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes28-Feb-13 12:34
memberMycroft Holmes28-Feb-13 12:34 
Questionsql server 2008 query, Pin
gavindon27-Feb-13 16:57
membergavindon27-Feb-13 16:57 
AnswerRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 17:11
member_Damian S_27-Feb-13 17:11 
GeneralRe: sql server 2008 query, Pin
gavindon27-Feb-13 18:14
membergavindon27-Feb-13 18:14 
GeneralRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 18:34
member_Damian S_27-Feb-13 18:34 
AnswerRe: sql server 2008 query, Pin
Mycroft Holmes27-Feb-13 19:45
memberMycroft Holmes27-Feb-13 19:45 
GeneralRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 19:53
member_Damian S_27-Feb-13 19:53 
GeneralRe: sql server 2008 query, Pin
Mycroft Holmes27-Feb-13 20:26
memberMycroft Holmes27-Feb-13 20:26 
AnswerRe: sql server 2008 query, Pin
gvprabu28-Feb-13 22:28
membergvprabu28-Feb-13 22:28 
QuestionSQL Server 2012 annoyance... Pin
_Damian S_27-Feb-13 16:21
member_Damian S_27-Feb-13 16:21 
One of my clients has upgraded to 64bit SQL Server 2012. We have moved the test database there and I am having a bizarre issue that's doing my head in...

Even the most simple update query causes an error, which of course, is causing stored procedures to fall over...

update tbl_User
set USR_Email = 'myemail@domain.name.au'
where UserID = 5

causes the following error: "Msg 102, Level 15, State 1, Procedure tbl_Userupdate, Line 53
Incorrect syntax near '@errorNumber'."

The strange part is that the query itself runs fine. Any suggestions? Perhaps a setting that's been missed by the sysadmin who did the installation?

AnswerRe: SQL Server 2012 annoyance... Pin
_Damian S_27-Feb-13 20:27
member_Damian S_27-Feb-13 20:27 
GeneralRe: SQL Server 2012 annoyance... Pin
Mycroft Holmes27-Feb-13 20:57
memberMycroft Holmes27-Feb-13 20:57 
GeneralRe: SQL Server 2012 annoyance... Pin
_Damian S_27-Feb-13 21:06
member_Damian S_27-Feb-13 21:06 
GeneralRe: SQL Server 2012 annoyance... Pin
Mycroft Holmes27-Feb-13 21:47
memberMycroft Holmes27-Feb-13 21:47 
QuestionWhat order to be followed while generating schema upgrade script? Pin
Member 313707826-Feb-13 19:10
memberMember 313707826-Feb-13 19:10 
AnswerRe: What order to be followed while generating schema upgrade script? Pin
Mycroft Holmes27-Feb-13 21:01
memberMycroft Holmes27-Feb-13 21:01 
GeneralRe: What order to be followed while generating schema upgrade script? Pin
Member 313707827-Feb-13 22:40
memberMember 313707827-Feb-13 22:40 
GeneralRe: What order to be followed while generating schema upgrade script? Pin
Mycroft Holmes27-Feb-13 23:15
memberMycroft Holmes27-Feb-13 23:15 
QuestionSQL weirdness when aliasing columns Pin
Gregory.Gadow22-Feb-13 12:19
memberGregory.Gadow22-Feb-13 12:19 
AnswerRe: SQL weirdness when aliasing columns Pin
gvprabu22-Feb-13 19:18
membergvprabu22-Feb-13 19:18 
AnswerRe: SQL weirdness when aliasing columns Pin
Mycroft Holmes24-Feb-13 14:08
memberMycroft Holmes24-Feb-13 14:08 
GeneralRe: SQL weirdness when aliasing columns Pin
Gregory.Gadow28-Feb-13 10:09
memberGregory.Gadow28-Feb-13 10:09 
GeneralRe: SQL weirdness when aliasing columns Pin
Mycroft Holmes28-Feb-13 13:04
memberMycroft Holmes28-Feb-13 13:04 
GeneralRe: SQL weirdness when aliasing columns Pin
Gregory.Gadow1-Mar-13 6:10
memberGregory.Gadow1-Mar-13 6:10 
AnswerSolution Pin
Gregory.Gadow1-Mar-13 10:28
memberGregory.Gadow1-Mar-13 10:28 
GeneralRe: Solution Pin
Mycroft Holmes1-Mar-13 12:53
memberMycroft Holmes1-Mar-13 12:53 
QuestionDatabase Pin
Member 961179522-Feb-13 9:52
memberMember 961179522-Feb-13 9:52 
AnswerRe: Database Pin
jschell22-Feb-13 10:30
memberjschell22-Feb-13 10:30 
AnswerRe: Database Pin
mark merrens22-Feb-13 11:38
membermark merrens22-Feb-13 11:38 
GeneralRe: Database Pin
Member 961179523-Feb-13 2:05
memberMember 961179523-Feb-13 2:05 
GeneralRe: Database Pin
S Douglas28-Feb-13 8:58
memberS Douglas28-Feb-13 8:58 
AnswerRe: Database Pin
Jörgen Andersson22-Feb-13 12:11
memberJörgen Andersson22-Feb-13 12:11 
AnswerRe: Database Pin
PIEBALDconsult22-Feb-13 14:38
memberPIEBALDconsult22-Feb-13 14:38 
QuestionSQL Server + Procedure or function has too many arguments specified Pin
Hemant Thaker21-Feb-13 19:53
memberHemant Thaker21-Feb-13 19:53 
AnswerRe: SQL Server + Procedure or function has too many arguments specified Pin
Sandeep Mewara21-Feb-13 20:00
mvpSandeep Mewara21-Feb-13 20:00 
AnswerRe: SQL Server + Procedure or function has too many arguments specified Pin
Mycroft Holmes21-Feb-13 21:29
memberMycroft Holmes21-Feb-13 21:29 
AnswerRe: Resolved --> SQL Server + Procedure or function has too many arguments specified Pin
Hemant Thaker21-Feb-13 23:11
memberHemant Thaker21-Feb-13 23:11 
QuestionDual Primary Key? Pin
Richard.Berry10021-Feb-13 7:25
memberRichard.Berry10021-Feb-13 7:25 
AnswerRe: Dual Primary Key? Pin
Eddy Vluggen21-Feb-13 8:10
mvpEddy Vluggen21-Feb-13 8:10 
GeneralRe: Dual Primary Key? Pin
Richard.Berry10021-Feb-13 8:42
memberRichard.Berry10021-Feb-13 8:42 
GeneralRe: Dual Primary Key? Pin
Eddy Vluggen21-Feb-13 9:32
mvpEddy Vluggen21-Feb-13 9:32 
GeneralRe: Dual Primary Key? Pin
Mycroft Holmes21-Feb-13 13:08
memberMycroft Holmes21-Feb-13 13:08 
GeneralRe: Dual Primary Key? Pin
PIEBALDconsult21-Feb-13 19:14
memberPIEBALDconsult21-Feb-13 19:14 
GeneralRe: Dual Primary Key? Pin
Eddy Vluggen21-Feb-13 23:42
mvpEddy Vluggen21-Feb-13 23:42 
Questionjdbc Pin
Durgesh1704r15-Feb-13 21:24
memberDurgesh1704r15-Feb-13 21:24 
AnswerRe: jdbc Pin
Richard MacCutchan15-Feb-13 23:31
mvpRichard MacCutchan15-Feb-13 23:31 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.161128.1 | Last Updated 2 Dec 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid