Viewing 15 posts - 331 through 345 (of 389 total)
anthony.green (7/4/2012)
REPLACE will work with underscores
DECLARE @OrigString VARCHAR(100)
DECLARE @SearchFor VARCHAR(100)
DECLARE @ReplaceWith VARCHAR(100)
SET @SearchFor ='DBName'
SET @ReplaceWith = 'Replaced_DBName'
SET @OrigString = 'Newdb.[DBName].dbo.TableName'
SET @OrigString = REPLACE(@OrigString, @SearchFor, @ReplaceWith)
SELECT @OrigString
What about this
DECLARE @OrigString...
July 4, 2012 at 5:30 am
No š
I lost the 7 points as did not see the movie š
July 4, 2012 at 5:16 am
Ray K (7/3/2012)
Brandie Tarvin (7/3/2012)
crookj (7/3/2012)
rhythmk (7/2/2012)
Revenant (7/2/2012)
Brandie Tarvin (7/2/2012)
RumbaRoomba
Brazil
brazier
bazaar
bizzare
A bizzare turn of events for Azzurri in EURO 2012 and Spain proved themselves best again.A team to beat.
Spain !!!!!
July 3, 2012 at 10:33 pm
Koen Verbeeck (7/3/2012)
rhythmk (7/3/2012)
Koen Verbeeck (7/3/2012)
Are we talking about SSIS 2012 environment variables or Windows environment variables?
Hey Koen,
Correct me if wrong we can't use SSIS 2012 environment variables in SSIS...
July 3, 2012 at 3:44 am
Koen Verbeeck (7/3/2012)
Are we talking about SSIS 2012 environment variables or Windows environment variables?
Hey Koen,
Correct me if wrong we can't use SSIS 2012 environment variables in SSIS 2005.
July 3, 2012 at 1:54 am
Also have a look on below article.
http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/">
http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/
July 3, 2012 at 12:38 am
Mark Eckeard (7/1/2012)
July 3, 2012 at 12:28 am
Revenant (7/2/2012)
Brandie Tarvin (7/2/2012)
RumbaRoomba
Brazil
July 2, 2012 at 10:41 pm
Sagar Sawant (7/2/2012)
I am using SET ROWCOUNT because the value comes from a parameter into my procedure.
SET ROWCOUNT @take
SELECT * FROM Something
SET ROWCOUNT 0
Is it possible to another...
July 2, 2012 at 3:51 am
eatemadnia.f (7/1/2012)
i want to import a big text file with a fixed record length(288) to tables.i need to read a record and check it then call a store procedure...
July 2, 2012 at 12:10 am
cadm777 (6/28/2012)
The table I need to pull data from has a column called LASTUPDATE(datetime). When a new balance is reached for the data,...
July 1, 2012 at 2:26 pm
mgee1038 (6/30/2012)
I need to be able to get the last date earlier than a parameter entered date.
I write a function...
June 30, 2012 at 8:25 pm
denisribeiro (6/29/2012)
Sometimes, some action, triggered for someone blocks the database, in other words, querys that should be executed quickly, takes too long.
Question:
Is there some tool that could help me to...
June 29, 2012 at 7:21 am
Sean Lange (6/28/2012)
rhythmk (6/28/2012)
Mahesh Gupta-325917 (6/28/2012)
Lets say in table1, I have data saying 4,2,3,1
Now I need...
June 29, 2012 at 12:05 am
achen9291 (6/28/2012)
June 28, 2012 at 11:14 am
Viewing 15 posts - 331 through 345 (of 389 total)