|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Create table and fileds
Maked this little code but dont know the way to insert new table and fileds in database DATABASE01...
Private Sub Command1_Click() Dim objConn As ADODB.Connection Set objConn = New ADODB.Connection objConn.ConnectionString = "driver={SQL Server};server=DVD377-14D9E48C\SQLEXPRESS;uid=;pwd=;database=master" objConn.Open objConn.Execute "CREATE DATABASE DATABASE01" '''''''''''''''''' '"CREATE table Mytable" '''''''''''''''''' '''''''''''''''''' '"CREATE filed1" in text format '"CREATE filed2" in text format '"CREATE filed3" in text format '"CREATE filed4" in date format(DD/MM/YYYY) '''''''''''''''''' objConn.Close End Sub |
|
#2
|
|||
|
|||
|
You should be looking for answers in a SQL Server / SQL forum I think.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Create table and fileds |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|