Viewing 15 posts - 1,936 through 1,950 (of 6,036 total)
gksharmaajmer (10/2/2013)
SELECT *
FROM #Results...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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?
_____________
Code for TallyGenerator
October 13, 2013 at 11:34 pm
CONVERT(nvarchar(100), NULL ) AS hazardCode
_____________
Code for TallyGenerator
October 13, 2013 at 9:47 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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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,...
_____________
Code for TallyGenerator
May 24, 2013 at 5:52 am
L' Eomot Inversé (5/23/2013)
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
May 22, 2013 at 9:46 pm
lgegerton (5/19/2013)
replace'%@name%'
with
'%' + @name + '%'
'%' + RTRIM(@name) + '%'
since CHAR data type is used.
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
May 22, 2013 at 5:49 pm
Viewing 15 posts - 1,936 through 1,950 (of 6,036 total)