June 26, 2008 at 10:59 pm
...or if that doesn't work...
NO CONVERSATIONWAITFOR END OF DAY AND THEN
TRY UNION INSTEAD
:w00t:
June 27, 2008 at 6:39 am
Well, Ivanna, that makes a total of three RELATIONAL verses in T-SQL Haiku... How database is that ???? :D:D:D
And as long as we're using a RELATIONAL language, how about:
IF DATE IS DATEFIRST
THEN TRY NOT HAVING ANY
INSERT INTO DATE
:D:D:D
Not sure if I'll get away with this one though... It's a cautionary tale, if that helps...
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
June 27, 2008 at 10:32 am
master full user
values unique union
with distinct order
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 27, 2008 at 11:26 am
kill current user
and begin to shutdown key
user database
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 27, 2008 at 11:29 am
rudy komacsar (6/27/2008)
master full uservalues unique union
with distinct order
or schemabinding! 😛
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
June 27, 2008 at 11:32 am
Most Excellent :w00t:
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 27, 2008 at 11:35 am
no user exists
execute plan to delete
database server
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 27, 2008 at 6:14 pm
[font="Comic Sans MS"]
Current_date dummy?
Order no partial insert;
Coalesce union.
[/font]
August 9, 2008 at 3:53 am
GET PRIMARY DEFAULT USER
TRY TO BREAK CURRENT TRANSACTION
ALTER AUTHORIZATION TO CREATE CURSOR
Atif Sheikh
August 9, 2008 at 3:58 am
GOTO FETCH CURRENT BACKUP
RESTORE ON DATABASE FOR DUMMY
BREAK TRANSACTION ON DUMP PROCEDURE
Atif Sheikh
August 9, 2008 at 5:54 am
Atif:
These does not conform to the rulesfor Haiku. Haiku are supposed to consist of 3 lines, with 5 syllables in the first line, 7 syllables in the second and 5 syllables in the last line. Yours are way over.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 11, 2008 at 4:50 am
August 11, 2008 at 7:27 am
Atif,
Here's an idea, using the concept you started with...
WHEN USER DUMMY
THEN FETCH CURRENT BACKUP AND
RESTORE DATABASE
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 11, 2008 at 7:50 am
Or this...
CREATE PROCEDURE
TO KILL CURRENT DATABASE
WHEN USER DUMMY
or ...
SET VARYING LENGTH
VALUES FOR UNION INPUT
TO GET UNIQUE DATE
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 11, 2008 at 8:58 am
If only lay about workers were this easy to CONVERT 😎 :
IF NOT COMMITTED
SETUSER TO COMPUTE AND
KILL IDENTITY
Viewing 15 posts - 16 through 30 (of 40 total)
You must be logged in to reply to this topic. Login to reply