philosophaie — 2013-02-15T03:06:17-05:00 — #1
I have already create a Database in c:\path\db1.mdf.
I also created a Table, table1, and a few Fields: field1, field2, field3, etc.
In SQL I would like to know how to populate a list of each Field in that Table.
I also would like to know how to insert a Field after an existing Field previously mentioned.
r937 — 2013-02-15T05:26:35-05:00 — #2
not sure what you mean by "populate a list of each Field"
it's not mysql, so you can't
good thing is, you don't really need to, since you can always return the columns in whatever sequence you want when you SELECT
kylewolfe — 2013-02-15T14:05:55-05:00 — #3
You'll want to look at this:
and then right hurr:
kylewolfe — 2013-02-15T14:07:22-05:00 — #4
Woops, just saw this is mssql, syntax may be slightly different, but you can find your way from here, they are both available for SQL server as well
r937 — 2013-02-15T19:15:18-05:00 — #5
maybe it is, maybe it isn't
on another discussion forum, he's got a thread going in the mysql forum
system — 2013-03-01T00:38:25-05:00 — #6
you can read w3school it's good for basic of the database query.
kylewolfe — 2013-03-01T01:13:02-05:00 — #7
No. No. No. Never. w3school should be blocked by ISPs world wide. Bad source
system — 2013-03-01T03:13:44-05:00 — #8
Ok.........but i used this so i suggest you.......
kylewolfe — 2013-03-01T12:29:00-05:00 — #9