I want to insert 4 rows into a SQL table.
Can I do this without using 4 Insert statements?
This is my SQL statement:
  Insert Into MyTable Values (1,2)

Let me preface this by saying that i'm not a programmer.
I'm trying to setup a job that runs a query every night at 7pm that will
pull all transactions with the date reported that equals the system date.  
What identifier would I use so that it pulled transactions based on the the

I run the sql like the following
Alter table ItemStone add ISPurPrice money default 0
then when I select the itemStone table, I find the field ISPurPrice is still
Null, not 0, why?

I'd like to run the following command:
   ALTER TABLE cal_respurpose ALTER COLUMN [purpose] varchar(255)
but it falls over because the current [purpose] column is 'text': -
Server: Msg 4928, Level 16, State 1, Line 1

I am working with SQL Server 2000 table called dbo.proofofconcept".
I need to separate values that are all in one column that are space limited.
For example I have a column called tryit and the
value = '1234 456.75  01/01/2001 ABBR TRY@GSU.ORG 75%   $12.75  '.

I am working with SQL Server 2000 table called dbo.proofofconcept".
I need to separate values that are all in one column that are space limited.
For example I have a column called tryit and the
value = '1234 456.75  01/01/2001 ABBR TRY@GSU.ORG 75%   $12.75  '.

Dear Friends,
Usually we call tabal and SP like given below.
         select * from [linkedserver].[database].[dbo].[TableName]
         EXEC [linkedserver].[database].[dbo].usp_storedprocedure

Does anyone know what is the following query mean:
select * from abc,def where abc.xx(+) = def.xx
i have no idea about the (+) symbol..what it represent?
Thank you in advance

Hi there, I'd like to ask you for help with following:
I am trying to select YTD for last year in my sales table. Our accounting
year is from 1st of July to 30 June.
select *

I'm not sure if this is a join problem or even if it can be done.
The english part of the query will be requesting cagegoires="Cat2"
and return the matching records in table1, plus return all the other
categories that belong to the set in table 2.

Hi there, I'd like to ask you for help with following:
I am trying to select YTD for last year in my sales table.
select *
from Salestable

Does anyone know what is the following query mean:
select * from abc,def from abc.xx(+) = def.xx
i have no idea about the (+) symbol..what it represent?
Thank you in advance