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 |
|
mmcov
Starting Member
2 Posts |
 Posted - 2007-02-26 : 07:53:28
|
Hi all,I’m currently writing a web application on student exam timetables, I’m using SQL Server 2005 as the back-end for the database.At present, the case states that if a student is in one examination, he/she can’t attend, or be allocated another examination while the first examination is in place, which would result in a clashThe way I’m going to target this is by writing a stored procedure in SQL Server 2005 to return an error code, which I’ll translate using ASP,NET, however at present I’m having difficulty writing the SQL code. This is because…I’m using SQL Server 2005 Management Studio; I created the tables using MS Access and upsized them using the wizard. I can now access my database, but having difficulty editing my tables and with code…Any ideas??  Thank-you |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-26 : 07:59:17
|
| What's the purpose of creating tables in MS Access and then migrating them to SQL 2005? Is it migration of existing DB to SQL 2005?Also what problems you are facing in editing the table?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
mmcov
Starting Member
2 Posts |
Posted - 2007-02-26 : 08:43:15
|
| The reason for me upszing from MS Access to SQL Server, is so that I can use .NET to create deploy the web application, which wouldn't have been possible via MS Access, I would like to access the design view i.e. SQL script so that I can add the code for writing the stored proceduresThank-you |
|
|
|
|
|
|
|
|
Editing Tables & Writing Custom Stored Procedures