Viewing 15 posts - 136 through 150 (of 152 total)
Good question.. "CHOOSE" new built-in-function in SQL 2012.
June 18, 2013 at 10:59 pm
Good Question.... but ,before select statement, he is dropping the table so select statement returns error but there is no option in answer list.
June 13, 2013 at 10:50 pm
Oops ....
Lost my point...
"Must include an ORDER BY clause when a TOP clause is specified"
I think above option is wrong.
Ex:
select * from sys.objects where object_id in
(select top...
March 12, 2013 at 1:40 am
I am using transactional replication, some times as per my front End Application, We need to stop the agent. In that time it error is replicating.
June 18, 2012 at 8:07 am
If started the Sql Agent, error is not coming, If it is stop then error is coming.
June 18, 2012 at 5:58 am
SELECT cust_No, Score, DENSE_RANK() OVER (order by score) AS ScoreRanking
FROM MyCustScoring
June 18, 2012 at 3:59 am
SELECT cust_No, Score, DENSE_RANK() OVER (Partition by Score order by Score, Cust_No) AS Ranking
FROM MyCustScoring
ORDER BY Ranking
June 18, 2012 at 3:43 am
HI..
I need through script.. Not through design , I have to keep that script in procedure because, i am creating tables Dynamically by using sp.
April 4, 2012 at 5:04 am
Viewing 15 posts - 136 through 150 (of 152 total)