how to queue a stored procedure?2255 (12/10/2009 5:32:24 PM) Hello everyone,
Does anyone know how to submit a stored procedure to execute later in time?
EXEC admin.dbo.pHHA '123', 'junk', 'help'
I want it to execute on 12/20/2009 @ 9:00 AM EST.
Insert Trigger to Update Value of Column in Inserted Row7177 (12/8/2009 9:26:01 PM) I am trying to write a SQL Insert trigger which would populate the value of a
column in the inserted row with the value of a column from another database
table. The table into which the row is inserted doe... Utf
Keep track of SSIS package results in cursor4179 (12/9/2009 11:55:01 AM) Hi all,
I have a stored procedure (SS2005) that uses a cursor to cycle on the
records of a table to run - for each valid record - 3 SSIS packages.
Something like this:
WHILE @@FETCH_STATUS = 0
Server location2225 (12/9/2009 11:01:40 PM) Hi, using sql2005 is there any way to return the machine name that is loaded
with the sql server running a database?
Delete Primary transaction Log8182 (12/9/2009 12:41:02 PM) Does anyone know if this is possible? I want to create a new transaction log,
and remove the existing primary one, essential making the new transaction log
optimization of variables like constants3197 (12/9/2009 9:36:55 PM) If you compare the plans of the following two statements you can see that the optimizer will not perform the second part
of the union when unequal constants are in the predicate. Is there a way to get the op... Dan
Inserting new data when there is a primary key9155 (12/9/2009 2:45:18 PM) I need to insert new data and update existing data that is in a table.
I can't get the syntax correct.
CREATE TABLE [dbo].[collect](
[Docid] [int] NOT NULL,
[Chargekey] [int] NULL,
[Datesvc] [datetime... amj1020
TSQL Challenge 18 - Generate text formatted month calendars16133 (12/1/2009 2:05:27 AM) This is a multi-part message in MIME format.
where not equal1284 (12/9/2009 7:07:02 PM) SQL 2005
Seems like this should be easy . . . I need to exclude all records where ID
= AB AND State = CA.
RecordID ID State
1 ... Utf