Viewing 15 posts - 1,936 through 1,950 (of 6,036 total)
gksharmaajmer (10/2/2013)
SELECT *
FROM #Results...
October 14, 2013 at 10:41 pm
What is your favorite "I didn't know that"...
Where to start?
Drag and drop columns from Object Explorer in Query Analyzer?
Declaring column names in derived tables in a way later used in...
October 13, 2013 at 11:42 pm
L' Eomot Inversé (8/10/2013)
but in SQL Server 2000 if people without SA access had access to xp_cmdshell
How?
October 13, 2013 at 11:34 pm
Phil Parkin (5/24/2013)
Where is that post?
The first post of this topic.
But saying that you "cannot call insert like that" is clearly wrong.
Not if "like that" means...
May 24, 2013 at 6:37 am
GilaMonster (5/24/2013)
I never claimed or stated anywhere that it has any effect on the insert
Look, just 1 row above you say:
the select portion of an insert statement
If anything...
May 24, 2013 at 6:24 am
Phil Parkin (5/23/2013)
Bhaskar.Shetty (5/23/2013)
You cannot call insert like that, = operator works while you are updating any row or table.
Before making blanket statements like this, I find that it...
May 24, 2013 at 6:00 am
GilaMonster (5/23/2013)
Sergiy (5/23/2013)
GilaMonster (5/23/2013)
Since that's a valid form for the select, it's also valid for the insert...select.Very arguable.
What, that it's valid? Since it passes a syntax check it's valid T-SQL,...
May 24, 2013 at 5:52 am
L' Eomot Inversé (5/23/2013)
May 23, 2013 at 9:58 pm
L' Eomot Inversé (5/15/2013)
Anyway, I reckon Windows 8 is super. ... it all runs well and a lot faster than it would on similar hardware under XP
That must be...
May 23, 2013 at 9:12 pm
GilaMonster (5/23/2013)
Bhaskar.Shetty (5/23/2013)
Since that's a valid form for the select, it's also valid for the insert...select.
Very arguable.
All those aliasings remain within SELECT and have no relevance to INSERT.
INSERT takes values...
May 23, 2013 at 3:21 pm
rot-717018 (5/22/2013)
Here's the correction if it helps someone ...
select @dt = convert(char(10), getdate(), 111)
By all means try to avoid datetime-char-datetime conversions.
Pretty efficient performance killer.
Develop a habit to use this method:
select...
May 22, 2013 at 10:13 pm
I don't think you can create and run an SSIS package on SQL 6.5 or earlier.
It must be something more contemporary you use for that.
If so you just need to...
May 22, 2013 at 9:46 pm
lgegerton (5/19/2013)
replace'%@name%'
with
'%' + @name + '%'
'%' + RTRIM(@name) + '%'
since CHAR data type is used.
May 22, 2013 at 6:01 pm
marc.snoeys (5/17/2013)
There is nothing wrong with the INSERT-statement at all.
But, my personal opinion is that it would be more intuitive to be able to write an...
May 22, 2013 at 5:49 pm
Viewing 15 posts - 1,936 through 1,950 (of 6,036 total)