Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-24 : 23:02:39
|
| lba writes "I have just been flung in at the deepend as a new unix/dba and am having to deal with SQL server. I don't know where to start with this:Could you create a script that will insert rows to the room_booking table of the pasroom schema on SQL Server. She wants dates and times put in on an anual basis reflecting public hols etc.Hope you can help" |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-08-25 : 20:12:07
|
quote:
pasroom schema
Hi Iba - happy to help but I don't know what this "pasroom" schema is (myabe I'm just dumb)...Without knowing what the table looks like, it'll be probably be something like this:INSERT INTO room_booking (roomid, startdate, enddate)select 12345,convert(datetime, '26-Aug-2002'), convert(datetime, '28-Aug-2002')GOFirst a few basics...what interface are you using to write scripts? Do you have access to Books Online? (you'll need them)--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
lba
Starting Member
3 Posts |
Posted - 2002-08-26 : 10:41:38
|
| I s'pose I'll be using query analyzer. And yes I have access to books online. I did an SQL course but TSQL seems a bit different!!!!!!!!No-one here to help me! |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-08-26 : 19:24:55
|
quote:
No-one here to help me!
OK - well start asking the questions and feel free to ask as many as you like...How did the code above go?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
Transact sql scripts