Click here to Skip to main content
11,414,670 members (67,169 online)
   

Database

 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult23-Jan-13 17:26
memberPIEBALDconsult23-Jan-13 17:26 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro23-Jan-13 17:58
memberIgaBaro23-Jan-13 17:58 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult23-Jan-13 17:59
memberPIEBALDconsult23-Jan-13 17:59 
AnswerRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
Richard MacCutchan24-Jan-13 0:22
mvpRichard MacCutchan24-Jan-13 0:22 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult24-Jan-13 6:48
memberPIEBALDconsult24-Jan-13 6:48 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro24-Jan-13 6:54
memberIgaBaro24-Jan-13 6:54 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult24-Jan-13 7:00
memberPIEBALDconsult24-Jan-13 7:00 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro24-Jan-13 8:11
memberIgaBaro24-Jan-13 8:11 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult24-Jan-13 8:56
memberPIEBALDconsult24-Jan-13 8:56 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
Richard MacCutchan24-Jan-13 23:35
mvpRichard MacCutchan24-Jan-13 23:35 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro24-Jan-13 6:51
memberIgaBaro24-Jan-13 6:51 
Questioncreated tables not dropped in a transaction rollback Pin
Danzy8320-Jan-13 17:13
memberDanzy8320-Jan-13 17:13 
AnswerRe: created tables not dropped in a transaction rollback Pin
Mycroft Holmes20-Jan-13 17:32
memberMycroft Holmes20-Jan-13 17:32 
AnswerRe: created tables not dropped in a transaction rollback Pin
Eddy Vluggen21-Jan-13 3:06
mvpEddy Vluggen21-Jan-13 3:06 
Similar to below? That would remove the created table (and does)
BEGIN TRANSACTION
 
CREATE TABLE Test (Id BIGINT)
INSERT INTO Test (Id) VALUES (1)
 
ROLLBACK
 
SELECT * 
  FROM information_schema.tables
WHERE TABLE_NAME = 'Test'

Danzy83 wrote:
However, the tables created within the transaction are not dropped from the database. This is unusual to me.

It'd be erroneous. Have you changed the locking-options?

FWIW, it'd probably be the wisest to use a temp-table, not a real one.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

AnswerRe: created tables not dropped in a transaction rollback Pin
Shameel21-Jan-13 23:08
memberShameel21-Jan-13 23:08 
GeneralRe: created tables not dropped in a transaction rollback Pin
jschell22-Jan-13 9:16
memberjschell22-Jan-13 9:16 
GeneralRe: created tables not dropped in a transaction rollback Pin
Shameel23-Jan-13 0:46
memberShameel23-Jan-13 0:46 
QuestionChange the language for Sql Server 2008 Pin
Thaer Hamael19-Jan-13 2:27
memberThaer Hamael19-Jan-13 2:27 
AnswerRe: Change the language for Sql Server 2008 Pin
PIEBALDconsult19-Jan-13 6:29
memberPIEBALDconsult19-Jan-13 6:29 
AnswerRe: Change the language for Sql Server 2008 Pin
Mycroft Holmes19-Jan-13 15:19
memberMycroft Holmes19-Jan-13 15:19 
Questionsql server 2008 Pin
Kapilkp18-Jan-13 0:25
memberKapilkp18-Jan-13 0:25 
QuestionRe: sql server 2008 Pin
Eddy Vluggen18-Jan-13 2:30
mvpEddy Vluggen18-Jan-13 2:30 
GeneralRe: sql server 2008 Pin
Kapilkp21-Jan-13 0:06
memberKapilkp21-Jan-13 0:06 
GeneralRe: sql server 2008 Pin
Eddy Vluggen21-Jan-13 2:15
mvpEddy Vluggen21-Jan-13 2:15 
GeneralRe: sql server 2008 Pin
PIEBALDconsult21-Jan-13 5:57
memberPIEBALDconsult21-Jan-13 5:57 
AnswerRe: sql server 2008 Pin
PIEBALDconsult18-Jan-13 5:01
memberPIEBALDconsult18-Jan-13 5:01 
Questionsql server Pin
yogika17-Jan-13 20:15
memberyogika17-Jan-13 20:15 
AnswerRe: sql server Pin
Eddy Vluggen18-Jan-13 2:37
mvpEddy Vluggen18-Jan-13 2:37 
AnswerRe: sql server Pin
Richard Deeming18-Jan-13 2:37
memberRichard Deeming18-Jan-13 2:37 
GeneralRe: sql server Pin
Eddy Vluggen18-Jan-13 3:13
mvpEddy Vluggen18-Jan-13 3:13 
GeneralRe: sql server Pin
Richard Deeming18-Jan-13 3:18
memberRichard Deeming18-Jan-13 3:18 
GeneralRe: sql server Pin
Eddy Vluggen18-Jan-13 3:22
mvpEddy Vluggen18-Jan-13 3:22 
GeneralRe: sql server Pin
PIEBALDconsult18-Jan-13 15:36
memberPIEBALDconsult18-Jan-13 15:36 
AnswerRe: sql server Pin
PIEBALDconsult18-Jan-13 5:04
memberPIEBALDconsult18-Jan-13 5:04 
GeneralRe: sql server Pin
Shameel22-Jan-13 5:31
memberShameel22-Jan-13 5:31 
QuestionDo I need a pivot Query? Pin
GREG_DORIANcod16-Jan-13 11:09
memberGREG_DORIANcod16-Jan-13 11:09 
AnswerRe: Do I need a pivot Query? Pin
Mycroft Holmes16-Jan-13 20:36
memberMycroft Holmes16-Jan-13 20:36 
GeneralRe: Do I need a pivot Query? Pin
GREG_DORIANcod17-Jan-13 2:59
memberGREG_DORIANcod17-Jan-13 2:59 
AnswerRe: Do I need a pivot Query? Pin
Jörgen Andersson21-Jan-13 9:58
memberJörgen Andersson21-Jan-13 9:58 
QuestionTotals of each transaction type Pin
Richard.Berry10015-Jan-13 22:38
memberRichard.Berry10015-Jan-13 22:38 
AnswerRe: Totals of each transaction type Pin
Mycroft Holmes15-Jan-13 23:57
memberMycroft Holmes15-Jan-13 23:57 
GeneralRe: Totals of each transaction type Pin
Richard.Berry10016-Jan-13 1:36
memberRichard.Berry10016-Jan-13 1:36 
GeneralRe: Totals of each transaction type Pin
PIEBALDconsult16-Jan-13 4:42
memberPIEBALDconsult16-Jan-13 4:42 
GeneralRe: Totals of each transaction type Pin
Richard.Berry10016-Jan-13 6:36
memberRichard.Berry10016-Jan-13 6:36 
QuestionCustomize color coding in SQL editor window [modified] Pin
biop.codeproject15-Jan-13 21:04
memberbiop.codeproject15-Jan-13 21:04 
AnswerRe: Customize color coding in SQL editor window Pin
Mycroft Holmes15-Jan-13 23:51
memberMycroft Holmes15-Jan-13 23:51 
GeneralMessage Removed Pin
biop.codeproject16-Jan-13 20:26
memberbiop.codeproject16-Jan-13 20:26 
GeneralRe: Customize color coding in SQL editor window Pin
Mycroft Holmes16-Jan-13 20:34
memberMycroft Holmes16-Jan-13 20:34 
GeneralRe: Customize color coding in SQL editor window Pin
Shameel22-Jan-13 5:41
memberShameel22-Jan-13 5:41 
Questionquery.. Pin
vishal.v.patil14-Jan-13 18:49
membervishal.v.patil14-Jan-13 18:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web03 | 2.8.150427.4 | Last Updated 27 Apr 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid