SQL Server database programming

I have a table that contains arrival times for different vehicles. I would like to be able to combine records by incident and calculate the difference in time of thier arrival. Example incd    vehi    time ...

I need to insert data into a table in DB2 from a similar table in DB1.  I want to say Insert Into tblx Select * from server1.DB1.dbo.tblx tblx contains 40 columns which I would like to not have to list.  One of the ...

I've always wondered if there is an elegant solution in T-SQL to the following requirement. Consider a database consisting of three tables: Pubs: Table of pubs, e.g. "Red Lion" PubID: Unique ID Name: Name of the pub ...

I am trying to pull together information from two different Linked Server databases. Let's call the LinkedServerA and LinkedServerB, both of which are Oracle databases. So, what I want to do is pull the following Columns from LinkedServerA: ANUMBER, FNAME, LNAME, C_ID, S_ID, STATE ...