How - create and use database directly after creation in SQL Server? -

-

i created sql script check if database exist, if exists deletes , re-creates. after connect directly after creation creating tables ..

here code not work. announces error message

msg 911, level 16, state 1, line 10 database 'arms2' not exist. make sure name entered correctly.

my script

if exists (select * sys.databases name = 'arms2') begin      drop database arms2     print 'drop database arms2' end     create database arms2;     print 'create database arms2'  use arms2  create table .....

put go statement after create...

... create database arms2; print 'create database arms2' go use arms2

Comments

Post a Comment

Popular posts from this blog

mysql - How to unscape text from database in android studio -

-
i'm creating text view in android studio, text view empty default, fetches data mysql database. text long , contains "\n" character force line breaks. reason, text view displaying \n , there isn't line breaks. here code: <textview android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="" android:singleline="false" android:id="@+id/textview" android:layout_centerhorizontal="true" android:gravity="center" android:textalignment="center" android:layout_below="@+id/imageview3" android:layout_margintop="70dp" android:textcolor="#ffffff" android:textsize="35sp" /> here picture of app showing text no line break :( https://goo.gl/cr34cq the text in picture edited in mysql database. displayed is. i can provide java code , mysql database table also. here j...
Read more

php - Admin SDK -- get information about the group -

-
please, help. https://www.googleapis.com/admin/directory/v1/groups/106274944935548788283 sending request obtain information group id 1062 ... here link method in google https://developers.google.com/admin-sdk/directory/v1/guides/manage-groups#get_group in response error - 401 unauthorized. oauth authenticate via user has received rights necessary request, included in console admin sdk. authorization successful, there token. not can not understand. if not hard - response. requested information: file_get_contents("https://www.googleapis.com/admin/directory/v1/groups/1062749‌​44935548788283?key=aizasybruhiomdf9nlx9lx3imxwesqmcrnhh4l4"); id group - "106274944935548788283" key applications in case - "aizasybruhiomdf9nlx9lx3imxwesqmcrnhh4l4" error: failed open stream: http request failed! http/1.0 401 unauthorized
Read more

Making CSS Drop Down Menu 2 Columns -

-
long time lurker posting first time. i've been searching around , found solution i'm looking reason i'm getting weird result. basically menu has many items see them in 2 columns. searching found needed make "ul" twice wide "li" , float "li" left. working i'm getting blank space in 2nd row. #cssmenu { padding: 0; margin: 0; border: 0; width: auto; } #cssmenu ul, #cssmenu li { list-style: none; margin: 0; padding: 0; } #cssmenu ul { z-index: 597; } #cssmenu ul li { float: left; min-height: 1px; vertical-align: middle; } #cssmenu ul li.hover, #cssmenu ul li:hover { position: relative; z-index: 599; cursor: default; } #cssmenu ul ul { visibility: hidden; position: absolute; top: 100%; left: 0; z-index: 598; width: 100%; } #cssmenu ul ul li { float: left; width: 250px; } #cssmenu ul ul ul { top: 0; left: 250px; width: 500px; height: 20px; } #cssmenu ul li:hover > ul { visibility: v...
Read more