|
Previous <
13
14
15
16
17
18
19
20
21
22
>Next
|
|
If you are like me I have tried using Verity, but I feel it is lacking on the database searching, you need another way. After fiddling around for a while I found the amazing Full-Text search capabilities built right into MS SQL Server 2000. If you are running SQL Server for your sites DB then this is a great function (or set of functions) to allow an even better full text search to your website.
You will need a table called Recipe in your database. It should be formatted like this for this exercise |
|
|
|
Security in the context of SQL Server deals with three areas: the platform, users and groups (or roles, as Microsoft calls them), and objects. In this tutorial, I'll introduce the three areas, and in other tutorials I'll cover the specifics of each. It helps to look security this way, since each of the parts of SQL Server security deal with different aspects, tools, concerns and approaches. Not only that, the three areas in security are a hierarchy. An area depends on the one previous to it.
It's also helpful to think of the security hierarchy this way because this is the way you'll implement the product. You'll install and configure your server, create users and groups for it, and then ensure that they can access only the objects they are supposed to. I'll use this same logical approach in our discussions here.
|
|
|
|
Sometimes I'm just plain lazy. Other times I don't want to have to spend hours debugging ASP code because of typos so I've found a way to help short cut some repetitive ASP coding tasks. The idea is an old one that I used back in Access 2.0 days to write Web pages in Access. The idea is to mix strings of text with database field values to create the lines of code you need. So here we go.
I was working on a site that contains resumes. The headache for the database design for this is that there are about 70 different skills to track for people. Since the resumes aren't stored permanently but removed after 6 months creating a multi-table relational database to store this would have been a nightmare. So I went with one basic table storing the person's resume in one place. This means a lot of fields in the database
|
|
|
|
Professor William Iverson presents the basics of using the SQL language in the Microsoft PC environment. Examples are chosen specifically for their availability to all users, and provide continuity of work throughout the video series; from the first basic selections, into more complicated joins, and right into expanding this example with real world help resources. SQL statements are built gradually, to help present the logic of deriving a useful thought process, including error diagnostics and corrections.
|
|
|
|
ProgrammingMSAccess.com's webmaster, Rick Dobson, has been active with SQL Server for almost as long as he has worked with Microsoft Access, but his attention to SQL Server grew substantially starting with SQL Server 7. The SQL Server resources at this site draw heavily on Rick's SQL Server experience. The links below point to resources that address SQL Server from the perspective of an Access developer, a T-SQL developer, and a VB.NET developer.
Rick is the author of three books and one DVD with SQL Server in the title. His third book on SQL Server addresses SQL Server Express, Visual Basic Express, and Visual Web Developer Express as well as the interaction between the three. His articles appeared in such publications as SQL Server Magazine, SQL Server Professional, and SQL Server Solutions. Some of the content below includes excerpts from or links to his published content, but other material below extends previously published content.
|
|
|
|
Previous <
13
14
15
16
17
18
19
20
21
22
>Next
|
|
|
