Click here to Skip to main content
       

Database

 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberPIEBALDconsult23-Jan-13 16:26 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberIgaBaro23-Jan-13 16:58 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberPIEBALDconsult23-Jan-13 16:59 
AnswerRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmvpRichard MacCutchan23-Jan-13 23:22 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberPIEBALDconsult24-Jan-13 5:48 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberIgaBaro24-Jan-13 5:54 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberPIEBALDconsult24-Jan-13 6:00 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberIgaBaro24-Jan-13 7:11 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberPIEBALDconsult24-Jan-13 7:56 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmvpRichard MacCutchan24-Jan-13 22:35 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberIgaBaro24-Jan-13 5:51 
Questioncreated tables not dropped in a transaction rollback PinmemberDanzy8320-Jan-13 16:13 
AnswerRe: created tables not dropped in a transaction rollback PinmemberMycroft Holmes20-Jan-13 16:32 
AnswerRe: created tables not dropped in a transaction rollback PinmvpEddy Vluggen21-Jan-13 2: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 PinmemberShameel21-Jan-13 22:08 
GeneralRe: created tables not dropped in a transaction rollback Pinmemberjschell22-Jan-13 8:16 
GeneralRe: created tables not dropped in a transaction rollback PinmemberShameel22-Jan-13 23:46 
QuestionChange the language for Sql Server 2008 PinmemberThaer Hamael19-Jan-13 1:27 
AnswerRe: Change the language for Sql Server 2008 PinmemberPIEBALDconsult19-Jan-13 5:29 
AnswerRe: Change the language for Sql Server 2008 PinmemberMycroft Holmes19-Jan-13 14:19 
Questionsql server 2008 PinmemberKapilkp17-Jan-13 23:25 
QuestionRe: sql server 2008 PinmvpEddy Vluggen18-Jan-13 1:30 
GeneralRe: sql server 2008 PinmemberKapilkp20-Jan-13 23:06 
GeneralRe: sql server 2008 PinmvpEddy Vluggen21-Jan-13 1:15 
GeneralRe: sql server 2008 PinmemberPIEBALDconsult21-Jan-13 4:57 
AnswerRe: sql server 2008 PinmemberPIEBALDconsult18-Jan-13 4:01 
Questionsql server Pinmemberyogika17-Jan-13 19:15 
AnswerRe: sql server PinmvpEddy Vluggen18-Jan-13 1:37 
AnswerRe: sql server PinmemberRichard Deeming18-Jan-13 1:37 
GeneralRe: sql server PinmvpEddy Vluggen18-Jan-13 2:13 
GeneralRe: sql server PinmemberRichard Deeming18-Jan-13 2:18 
GeneralRe: sql server PinmvpEddy Vluggen18-Jan-13 2:22 
GeneralRe: sql server PinmemberPIEBALDconsult18-Jan-13 14:36 
AnswerRe: sql server PinmemberPIEBALDconsult18-Jan-13 4:04 
GeneralRe: sql server PinmemberShameel22-Jan-13 4:31 
QuestionDo I need a pivot Query? PinmemberGREG_DORIANcod16-Jan-13 10:09 
AnswerRe: Do I need a pivot Query? PinmemberMycroft Holmes16-Jan-13 19:36 
GeneralRe: Do I need a pivot Query? PinmemberGREG_DORIANcod17-Jan-13 1:59 
AnswerRe: Do I need a pivot Query? PinmemberJörgen Andersson21-Jan-13 8:58 
QuestionTotals of each transaction type PinmemberRichard.Berry10015-Jan-13 21:38 
AnswerRe: Totals of each transaction type PinmemberMycroft Holmes15-Jan-13 22:57 
GeneralRe: Totals of each transaction type PinmemberRichard.Berry10016-Jan-13 0:36 
GeneralRe: Totals of each transaction type PinmemberPIEBALDconsult16-Jan-13 3:42 
GeneralRe: Totals of each transaction type PinmemberRichard.Berry10016-Jan-13 5:36 
QuestionCustomize color coding in SQL editor window [modified] Pinmemberbiop.codeproject15-Jan-13 20:04 
AnswerRe: Customize color coding in SQL editor window PinmemberMycroft Holmes15-Jan-13 22:51 
GeneralMessage Removed Pinmemberbiop.codeproject16-Jan-13 19:26 
GeneralRe: Customize color coding in SQL editor window PinmemberMycroft Holmes16-Jan-13 19:34 
GeneralRe: Customize color coding in SQL editor window PinmemberShameel22-Jan-13 4:41 
Questionquery.. Pinmembervishal.v.patil14-Jan-13 17: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
Web01 | 2.8.140926.1 | Last Updated 30 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid