Viewing 15 posts - 181 through 195 (of 373 total)
Jeff Moden (7/18/2011)
Hardy21 (7/17/2011)
sql2k8 (7/15/2011)
the below code also workscode please..
It's a "newbie" forum mistake. His first post where the OP said "Thank You very much. Your code works "...
July 19, 2011 at 2:08 am
sql2k8 (7/15/2011)
the below code also works
code please..
July 17, 2011 at 10:52 pm
You can use SUBSTRING & CHARINDEX functions to retrieve the data.
The example is as below:
declare @aa nvarchar(100) = '@Database=Test, @FileName=K:\BackupS\Differential\Test\Test_Diff_2007-07-12-220004.bak, @FileNumber'
select SUBSTRING(@aa, Charindex('K:', @aa), charindex('.bak', @aa) - (Charindex('K:', @aa)-4))
It returns:
K:\BackupS\Differential\Test\Test_Diff_2007-07-12-220004.bak
July 14, 2011 at 9:37 pm
1. No havent attended any.
2. Good idea. It should be from 2 weeks to 4 weeks and should cover almost all the areas which DBA is required.
July 6, 2011 at 7:49 am
Jayanth_Kurup (7/6/2011)
July 6, 2011 at 4:07 am
Nice article Divya
June 29, 2011 at 12:18 am
Nice article contains good examples, description.
June 21, 2011 at 4:06 am
I have referred 'http://beyondrelational.com/blogs/jacob/archive/2008/06/26/xquery-lab-1-transforming-rows-to-columns.aspx' link, and able to solve it.
I have the data like sample XML which I added in the question.
Table may contain 1 lac rows -...
May 2, 2011 at 11:55 pm
Hugo Kornelis (2/15/2011)
February 15, 2011 at 5:31 am
Good question.
I have confusion between Datasmith & DBPro because all others I know & installed, so guessed datasmith 🙂
February 10, 2011 at 2:03 am
rocky_498 (2/9/2011)
First step to add column (COLUMNXY)second use update statement
UPDATE STATE
SET COLUMNXY = (TYPE,'-',STATE)
First step to add column (COLUMNXY)
update STATE
SET COLUMNXY = (TYPE + '-' + STATE)
February 9, 2011 at 9:05 pm
Viewing 15 posts - 181 through 195 (of 373 total)