34 Kicks

Top 5 SQL System stored procedures every developer should know (www.dotnetcube.com)

published 10 months, 8 days ago, submitted by dncdudedncdude(1345) 10 months, 20 days ago

There are a number of documented and undocumented system stored procedures in MS SQL Server that are helpful for every web developer working with databases. From the developer’s perspective, here’s a list of 5 System stored procedures that are my favorite.

1 comment | category: | Views: 987

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
gavinjoycegavinjoyce(25.7k) - s.farmars.farmar(325) - tiernanotiernano(1575) - ski081ski081(0) - johnrummelljohnrummell(1260) - moeen49moeen49(0) - adventureradventurer(2131) - mountaineermountaineer(190) - vistadbvistadb(855) - RalphdeRuijterRalphdeRuijter(0) - gsbellgsbell(0) - mdoppmdopp(850) - schwankieschwankie(0) - atifazizatifaziz(990) - kayoskayos(885) - zigamorphzigamorph(2970) - raasielraasiel(860) - dist0rti0ndist0rti0n(125) - mosessaurmosessaur(5164) - RobertBernsteinRobertBernstein(0) - rafirafi(0) - terry.aneyterry.aney(105) - ZteffZteff(145) - mingming(0) - just3wsjust3ws(485) - bornykdbornykd(5) - sangam100sangam100(300) - tehmillertehmiller(0) - calebtcalebt(300) - jadedgeekjadedgeek(15) - renoldrrenoldr(0) - dncdudedncdude(1345) - ankygoyalankygoyal(430) - ig77ig77(0)

Comments:

posted by mihai.gutamihai.guta(0) 10 months, 7 days ago

Please don't use "sp_helptext" for scripting or use its results in the editor: this stored procedure will break the text of the stored procedure in lines of up to 255 characters each. It's not a smart breaking alghorithm and if you are using any line of text longer than 255 you may end up with fragments of words or fragments of uncommented single line comments.

If you want to get the text of a SQL object for scripting purposes, use either the "SQL Server Management Studio" or syscomments.

information Login or create an account to comment on this story
View upcoming stories
Submit a story
How else can I help?
Add our feeds to your site

Most Active Users