Viewing 15 posts - 91 through 105 (of 325 total)
Kingston Dhasian (2/26/2013)
handkot (2/26/2013)
the answer is ambiguous and depends from collationsI agree somewhat
The answers will change if the database collation is case sensitive
But, overall a very good question.
Well, I did...
February 27, 2013 at 1:10 am
🙂
Lokesh Vij (2/20/2013)
Easy and Nice question for the day. Thanks Serge 🙂
SQL Server assumes that this is a table alias 😀
+1
February 20, 2013 at 11:27 pm
how should I say it ?? :w00t:
I got that right ..was caught up for a while in severity level , as in msdn , when Throw used without parameters, the...
February 19, 2013 at 9:59 pm
Minnu (2/19/2013)
select create_date, modify_date from sys.objects
where
create_date >='2010-04-02 16:59:23.267' and
(modify_date >='2012-01-28 15:43:46.077' or modify_date <='2012-12-28 15:43:46.077')
am using above query to display
Create_date should be >= 2010 and
modify date...
February 19, 2013 at 4:53 am
zerko (2/18/2013)
February 18, 2013 at 10:04 pm
Koen Verbeeck (2/18/2013)
Interesting question, thanks.
+1
February 18, 2013 at 1:39 am
bitbucket-25253 (2/11/2013)
Now my question to you: Is the company sponsored employee & spouse/partner formal dinner and dance, a benefit...
February 11, 2013 at 9:15 pm
Raymond van Laake (2/7/2013)
Thanks for your reply, was afraid this would be the outcome.
The reason I need it is: my users can create a "campaign", and based on what's needed...
February 11, 2013 at 1:24 am
vk-kirov (2/10/2013)
GO (Transact-SQL)
Remarks
GO is not a Transact-SQL statement
So I read the question as following:
1) Do something to make the following statements to belong to one batch (ie, remove all GOs);
2)...
February 11, 2013 at 1:02 am
binod.soft (2/10/2013)
February 10, 2013 at 10:42 pm
How can i calculate sort space.
Follow this link ; For space calulations ..
http://msdn.microsoft.com/en-us/library/ms191183(v=sql.105).aspx
February 8, 2013 at 2:35 am
dwain.c (2/7/2013)
asco5 (2/7/2013)
so i need to know the top 100 of poeple who have the most entry
How do you want to handle tied counts?
I'm thinking a RANK() or DENSE_RANK() might...
February 7, 2013 at 9:30 pm
I had to read the whole about thesarus files , to get that right ..
good learning for me .. I never used it , I guess I need to know...
February 7, 2013 at 8:57 pm
Abu Dina (2/7/2013)
February 7, 2013 at 8:46 pm
Abu Dina (2/6/2013)
I seem to have many IF statmements to check for columns before I build my dynamic insert statement.Any ideas?
'If' is a conditional statement ;so, when you need it...
February 7, 2013 at 5:09 am
Viewing 15 posts - 91 through 105 (of 325 total)