Viewing 15 posts - 241 through 255 (of 3,232 total)
My previous example updated the wrong part of the column...thanks to Craig for doing it correctly.
DECLARE @Table TABLE (Val varchar(100))
INSERT INTO @Table
SELECT 'ABCDEF100' UNION ALL
SELECT 'ABCDEF200' UNION ALL
SELECT 'ABCDEF300'...
November 15, 2010 at 12:57 pm
wannalearn (11/15/2010)
I created
DELETE ABCDEF FROM dbo.XYZ
WHERE Column = 'ABCDEF100'
want to delete ABCDEF AND LEAVE 100 IN THAT COLUMN
Plz help me create statement for...
November 15, 2010 at 12:27 pm
wannalearn (11/15/2010)
DELETE ABCDEF FROM dbo.XYZWHERE Column = 'ABCDEF100'
Where are you getting DELETE ABCDEF ? Look in BOL for the basic format of a DELETE statement. It should follow...
November 15, 2010 at 12:25 pm
DELETE t
FROM YourTable t
WHERE Column = 'SomeValue'
November 15, 2010 at 10:34 am
Yes. In your Control Flow, just double-click on the connector and it will bring up the Precedence Constraint Editor. For the Evaluation Operation, you'll want to use Expression...
November 15, 2010 at 10:15 am
I would recommend getting the row count from your table and populating a variable with it. Use that variable inside a precedence constraint. Use an expression to test...
November 15, 2010 at 9:59 am
They carry longbows and recurves at places like Bass Pro Shops here in the US. They usually have an indoor range to shoot so I'm sure they'd let you...
November 15, 2010 at 9:52 am
Wish I could help, I haven't touched (or thought about) Oracle in 6 years....but back when I worked in Oracle, I used the metalink site for support...learned alot there.
November 15, 2010 at 9:42 am
Gotta love it when you have to answer your own question 🙂
November 12, 2010 at 4:20 pm
You say to "loop through different objects". Can you clarify this? As Gus said, if you really do have to loop, a cursor will do that, but most...
November 12, 2010 at 2:33 pm
Try carriage returns/line feeds.....
SELECT '' + CHAR(13) + CHAR(10)
+ '************************************************' + CHAR(13) + CHAR(10)
+ '* BEFORE BB_BB60 BACKUP:' + CHAR(13) + CHAR(10)
+ '************************************************' + CHAR(13) + CHAR(10)...
November 11, 2010 at 3:33 pm
A cup of coffee and an energy drink makes this all go down easier.
November 11, 2010 at 1:50 pm
Craig Farrell (11/11/2010)
WayneS (11/11/2010)
select DATENAME(weekday, 0); -- = Monday
select DATENAME(weekday, -1); -- = Sunday
select DateAdd(day, -7, 0); -- = 18991225
So, take the number of days between 18991225 (Date=-7) and...
November 11, 2010 at 12:59 pm
Views do not allow temp tables, but you can still use a derived table in the JOIN. Can you provide an example of what you are trying to do?
November 11, 2010 at 9:47 am
Viewing 15 posts - 241 through 255 (of 3,232 total)