Click here to Skip to main content
16,006,362 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: How To Make An Application a Service VB 6 Pin
Yulianto.17-Apr-05 21:39
Yulianto.17-Apr-05 21:39 
AnswerRe: How To Make An Application a Service VB 6 Pin
Dave Kreskowiak18-Apr-05 4:03
mveDave Kreskowiak18-Apr-05 4:03 
General.net framework exe Pin
_tasleem17-Apr-05 14:51
_tasleem17-Apr-05 14:51 
GeneralRe: .net framework exe Pin
Dave Kreskowiak17-Apr-05 15:29
mveDave Kreskowiak17-Apr-05 15:29 
Generalexe Pin
_tasleem17-Apr-05 14:34
_tasleem17-Apr-05 14:34 
GeneralRe: exe Pin
Dave Kreskowiak17-Apr-05 15:23
mveDave Kreskowiak17-Apr-05 15:23 
Questionhow to make new database through ado ? Pin
sumit2117-Apr-05 3:55
sumit2117-Apr-05 3:55 
AnswerRe: how to make new database through ado ? Pin
Colin Angus Mackay17-Apr-05 4:22
Colin Angus Mackay17-Apr-05 4:22 
sumit21 wrote:
but can anybody tell me how to make new database, new table in a database and alter table queries

To create a database, use something like this:
CREATE DATABASE Sales
ON 
( NAME = Sales_dat,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\saledat.mdf',
   SIZE = 10,
   MAXSIZE = 50,
   FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\salelog.ldf',
   SIZE = 5MB,
   MAXSIZE = 25MB,
   FILEGROWTH = 5MB )


To create a table use something like this:
CREATE TABLE publishers
(
   pub_id  char(4) NOT NULL 
         CONSTRAINT UPKCL_pubind PRIMARY KEY CLUSTERED,
   pub_name      varchar(40)     NULL,
   city         varchar(20)     NULL,
   state      char(2) NULL,
   country      varchar(30)     NULL
            DEFAULT('USA')
)


To alter a table use something like this:
ALTER TABLE doc_exa ADD column_b VARCHAR(20) NULL


If this is not enough help there are already some great documentation and articles already out there on the internet: CREATE DATABASE[^] CREATE TABLE[^] ALTER TABLE[^]


My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More


GeneralRe: how to make new database through ado ? Pin
sumit2117-Apr-05 4:39
sumit2117-Apr-05 4:39 
GeneralRe: how to make new database through ado ? Pin
Colin Angus Mackay17-Apr-05 4:44
Colin Angus Mackay17-Apr-05 4:44 
Generaldatagrid with checkbox Pin
sumit2117-Apr-05 3:42
sumit2117-Apr-05 3:42 
GeneralRe: datagrid with checkbox Pin
Anonymous17-Apr-05 18:21
Anonymous17-Apr-05 18:21 
Generalretrieve primary key of table ????/ Pin
sumit2117-Apr-05 3:40
sumit2117-Apr-05 3:40 
GeneralRe: retrieve primary key of table ????/ Pin
Colin Angus Mackay17-Apr-05 4:14
Colin Angus Mackay17-Apr-05 4:14 
GeneralDialog box clicks effect underneath it Pin
mrCrisp17-Apr-05 3:33
mrCrisp17-Apr-05 3:33 
GeneralRe: Dialog box clicks effect underneath it Pin
Dave Kreskowiak17-Apr-05 15:19
mveDave Kreskowiak17-Apr-05 15:19 
GeneralBackup and restore Pin
Mr Dabbah16-Apr-05 20:34
Mr Dabbah16-Apr-05 20:34 
GeneralRe: Backup and restore Pin
Colin Angus Mackay17-Apr-05 1:43
Colin Angus Mackay17-Apr-05 1:43 
Generalbinding data in an array to a listbox Pin
Coreo16-Apr-05 13:04
Coreo16-Apr-05 13:04 
GeneralRe: binding data in an array to a listbox Pin
sumit2116-Apr-05 17:19
sumit2116-Apr-05 17:19 
GeneralRe: binding data in an array to a listbox Pin
Coreo17-Apr-05 4:17
Coreo17-Apr-05 4:17 
GeneralRe: binding data in an array to a listbox Pin
sumit2117-Apr-05 4:41
sumit2117-Apr-05 4:41 
Questionadding images is menubar ?? Pin
sumit2116-Apr-05 3:52
sumit2116-Apr-05 3:52 
AnswerRe: adding images is menubar ?? Pin
skrtbh16-Apr-05 6:03
skrtbh16-Apr-05 6:03 
GeneralError in refer DLL Pin
nitin_ion15-Apr-05 21:30
nitin_ion15-Apr-05 21:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.