I am REALLY new to SQL. Teaching myself C#; downloaded SQL Express 2008. (Not sure of the terminology either...) Successfully created several tables for my desktop customer database. I am not able to populate the database yet... Do I have to create my own application to add data to the fields??? I am sure there's a feature I'm missing... I honestly feel like I am re-inventing the wheel... All help/suggestions appreciated! Thanks!!
seblake
0
Light Poster
Recommended Answers
Jump to PostYou can use INSERT() statements:
IF OBJECT_ID('Customer', 'U') IS NOT NULL DROP TABLE Customer Create Table Customer ( CustomerId int identity(1000, 1) PRIMARY KEY, CustomerName varchar(50), Address1 varchar(50), City varchar(50), State varchar(2), Zip varchar(5) ) Insert Into Customer (CustomerName, Address1, City, State, Zip) Values ('Scott', 'Street 1', …
All 4 Replies
sknake
1,622
Senior Poster
Featured Poster
seblake
0
Light Poster
sknake
1,622
Senior Poster
Featured Poster
seblake
0
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.