none
I am learning DATA mining ...

    Question

  • Hello,

    I am learning data warehousing and I want to write a script that will create a database, create a table, load data in to the table and then delete the entire database ...

    can you please help viki ...

    create database viki
    create table viki (id int, name varchar(10))
    insert into viki values(007, 'vikistupidbitch')
    use viki
    select * from viki
    /*
    packages or packets ...
    */
    use master

    go
    alter database viki set offline with rollback immediate
    drop database viki
    go

    • Moved by Olaf HelperMVP Sunday, August 18, 2013 1:48 PM Moved from "SQl Database Engine" to a more related forum for a better response
    Sunday, August 18, 2013 10:41 AM

Answers

All replies