The structured query language is a powerful tool for connecting to many database systems that store data in tables organized into rows and columns. It's often used on the backend of business websites ...

Queries work well if the databases are designed correctly. Here's what you need to know to build the foundations for your SQL Server databases. Most IT professionals and developers understand the ...

eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More. There are various ways of using global variables in ...

With exam 70-228, Microsoft wants to test your ability to administer SQL Server 2000 in large environments. In fact, the recommended “audience” for the exam is someone who has at least one year of ...

In the past, the question of how to perform auditing under SQL Server has had a simple answer: Do it yourself. But now, SQL Server 2000 has eased the burden of auditing by introducing an extensive and ...

Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and then ...

So I've got a table that has an id, foriegn_key, date_1, date_2 (*).<BR><BR>In visual basic I'm storing date_1 so I can check if Now() = date_1 (it's a little more complicated then that, but that's ...