Create a table of CourseTypes with a PK field and a description.
This is then an extensible solution if you need to add another type.
Create a view with an inner join (assumes the type is required in the course table and that a course can only have 1 type) to the type table and include the course type description field (I name the view vwCourse)
Or just do it the way the Blue one suggested!
Never underestimate the power of human stupidity
I am BE final year student. I am doing project using data warehouse. It is review analysis of automobiles. Can anybody give me feedback of this, how is the project at final year level?
Also if i get some links regarding review analysis i will e grateful.
I have an x64 Server Running SQL Server 08 and within that server I am setting up a linked server to an XP box running SQL express 05. I am setting up the linked server with a server name of "ComputerName\SQLEXPRESS", using the Microsoft OLE DB Provider for SQL Server. It connects fine and passes a connection test, but when i write a simple select query to get all records from the linked server table it returns no records when there are multiple records in the table I have queried. Any one ever seen this before? It should be noted that when I try to add the linked server and keep the radio button selected for sql server it will not connect giving me an error message
VIA Provider: The specified module could not be found.
OLE DB provider: SQLNCLI10 for linked server returned message login timeout expired.
OLE DB Provider for linked server returned message a network related or instance specific error has occured while establishing.....
error 1045 - access denied for user 'root' '@localhost'(using password : no)
php my admin tried to connect to the MYSQL server and the server rejected the connection .you should the check the host, user name and password in your configuration and make sure that they correspond to the information given by the administrator of the MYSQL server.
you should the check the host, user name and password in your configuration and make sure that they correspond to the information given by the administrator of the MYSQL server
Such a good error message! It perfectly tells you what to do.
I cannot believe that some internet provider would allow you to connect to a MySQL database on the server as root, and without a password...
;With CTE AS
Rn = Row_Number() Over(Partition By ('973' + contact_moblle) Order By file_no)
,('973' + contact_moblle) AS mobile_number
where contact_moblle is not null
and contact_moblle != ''and len(contact_moblle) = 8and left(contact_moblle, 1) = '3'
Where Rn = 1
I would like to hear some opinions from experienced developers who have worked with Access and SQL Server Express.
I am thinking of building a desktop based room reservation system as a personal project. However, I am not sure what would be the best approach.
I am thinking of the following options:
1) Using MS Access for both the front-end and back-end.
2) Using C# for front-end and MS Access as back-end.
3) Using C# for front-end and MS SQL Server Express as back-end.
It would be a packaged software, so I'm wondering if MS Access would be stable enough.
I haven't worked with MS Access long enough, so I would like to find out from other experienced developers whether MS Access backend would be sufficient, and what are some of the recommended steps to take to prevent database corruption - maybe backup, compact and repair every time program closes; what else?