REPLICATE

Question

Post reply

REPLICATE

Mike Is Here

Hall of Fame

Points: 3348
More actions
May 22, 2013 at 9:48 pm

#394834

Comments posted to this topic are about the item REPLICATE
May 23, 2013 at 9:08 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 1

Basic and easy one.:-)

Thanks for question !!!

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

Dineshbabu Hall of Fame Points: 3220 More actions · Answer 2

Danny Ocean (5/22/2013)
Basic and easy one.:-)
Thanks for question !!!

+1

--
Dineshbabu
Desire to learn new things..

Mike Is Here Hall of Fame Points: 3348 More actions · Answer 3

Yeah, it was just something I came across recently. A negative made it into a replication of spaces making the entire field null. Took a little bit of time to figure it out as all the other fields were wrapped with IsNull

Lokesh Vij SSChampion Points: 10836 More actions · Answer 4

Easy one for the day. But I rarely use this function. Thanks for reminding the basics Mike 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Dana Medley SSCertifiable Points: 6764 More actions · Answer 6

Ez Pz. Thanks for the question.

Everything is awesome!

Revenant SSC-Forever Points: 42467 More actions · Answer 7

Revenant

SSC-Forever

Points: 42467

May 23, 2013 at 11:03 am

#1617950

Nice and easy - thanks, Mike!

Ken SSCoach Points: 17191 More actions · Answer 8

Nice question about a another function that I rarely use. Thanks for the refresher on this!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Thanks for the question

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

kapil_kk SSC-Insane Points: 21316 More actions · Answer 10

Good question.

Easy one!! 🙂

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

manik_anu SSCrazy Points: 2377 More actions · Answer 11

Danny Ocean (5/22/2013)
Basic and easy one.:-)
Thanks for question !!!

+1

Manik
You cannot get to the top by sitting on your bottom.

ITGuy268 Mr or Mrs. 500 Points: 550 More actions · Answer 12

Nice refresher on REPLICATE and what's returned given the different 2nd (bigint) parameter values 😀

MCTS | MCITP | Microsoft SQL Server 2008 Administration & Development
MCSA | MCSE | Business Intelligence SQL Server 2012

sqlnaive SSCoach Points: 17437 More actions · Answer 13

sqlnaive

SSCoach

Points: 17437

June 4, 2013 at 12:31 am

#1620786

Nice and easy one. 🙂