Database

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.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

Shameel wrote:

In almost all database systems that I have worked
with, DDL statements such as CREATE and DROP are not considered part of a
transaction.

Kapilkp wrote:

actually the problem is that my project manager has asked me to do a project of merging different databases in sql server 2008

Kapilkp wrote:

these databases are on oracle, my sql and sql server now the problem is that the database have   a column of unicode data

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

Kapilkp wrote:

a column of unicode data

1. Wrong; a table-valued function[^] may return more than one value as part of a result-set;
    
2. Correct; functions may not have OUTPUT parameters;
    
3. Wrong; a multi-statement UDF may contain[^]:
   
   • assignment statements;
   • control-of-flow statements (except TRY...CATCH);
   • DECLARE statements;
   • SELECT statements;
   • cursor operations referencing local cursors;
   • INSERT, UPDATE and DELETE statements modifying local table variables; and
   • EXECUTE statements calling extended stored procedures[^];
   
    
4. Sort-of; a function may call an extended stored procedure[^], but not a regular stored procedure;
    
5. Correct; a function may not contain a TRY...CATCH block;

The following statements are valid in a function: ... EXECUTE statements calling extended stored procedures.

Richard Deeming wrote:

Almost - I had to look a couple up to confirm what I thought.

Richard Deeming wrote:

Why would you disagree with #4 when it's documented in BOL[^]?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]