SQL and T-SQL for Beginners in 229 minutes

The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.

SubQuery behavior

I have no id

Sub Query

Stairway to T-SQL: Beyond The Basics Level 2: Writing Subqueries

In this level of the Beyond the T-SQL Basics stairway, we will be discussing the different aspects of a subquery.

RE: SourceSafe Alternatives

http://support.microsoft.com/default.aspx?scid=kb;en-us;818368 for vs.net, and http://support.microsoft.com/default.aspx?scid=kb;en-us;201240 for vs6 (looks like it's best to use interdev)I tried and used this for a while, and it does work.  The only downside I would say is that you don't version table designs etc, but they can be backed up.  Remember if you use UDF's a lot, these don't seem to integrate […]

RE: Cant find the SQL Server

The mdac version that ships with Windows 2000 is 2.5, which is unable to dynamically determine the sql port (it does not connect to udp1434 to get this information), so you have to tell it the port that sql is running on. If your server is running on anything other than 1433 then you'll run […]

How to view all Jobs without being an Admin

Hi All,I am a production DBA and have a produciton & test environment configured. There are several programmers who have Sys Admin access to the Test environment, this is where they do their work. Production is pretty much locked down.One of the programmers wishes to be able to view the production jobs as well as […]

RE: Triggers to create String ID

Hi, not really the solution to your question.. but this is how we do it...We have a table with the following: TableName, CurrentNumber, EndNumber etc etcWe created 1 Procedure, taking the table name (or any) as parameter: 1. Based on parameter, read into the set up table and take "CurrentNumber" 2. Update CurrentNumber by +1 3. […]