Subscribe to Subscribers

Resources » SQL Server

Tool for Formatting Sql Statements or TSQL


Posted Date:     Category: SQL Server    
Author: Member Level: Gold    Points: 10


This tool will help us to format our TSQL statement many times we are spending more time to format the sql statements. Intellisense features which help us to increase code readability, finding the unused object etc. Problem and solution on Tool for Formatting Sql Statements or TSQL



Find Tool for Formatting Sql Statements or TSQL


Problem : Lot of time developer are spending their time on making readable sql statement and also need time to think about object some time we will remember few words only from the table. So sql server 2005 will not having this features of Intellisense.

Solution : SQL Prompt Tool
This tool help us to make our code more readable and vary useful for sql developers or database reviewers and this tool will enforce some common conventions or standards to developer to make or work on some standards which will really not required any additional time.

Benefit of Using this tool are as under :
1. Intellisense
2. Make our Sql Statements Readable
3. Find Un Used Variable in the Stored Procedure
4. Code Re factoring
5. Save Time of Formatting Sql Statements

This is one path we can download this tool :
http://download.cnet.com/SQL-Prompt/3000-2247_4-200997.html

I used this tool and find vary user friendly because no need to open some third window like other and it's sql addins so it's vary easy to use it.





Did you like this resource? Share it with your friends and show your love!


Responses to "Tool for Formatting Sql Statements or TSQL"

No responses found. Be the first to respond...

Feedbacks      

Post Comment:




  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:   Sign In to fill automatically.
    Email: (Will not be published, but required to validate comment)



    Type the numbers and letters shown on the left.


    Next Resource: Evaluate And Execute IF Statement in Formula Editor
    Previous Resource: What is SET NOCOUNT ON in SQL Server?
    Return to Resources
    Post New Resource
    Category: SQL Server


    Post resources and earn money!
     
    More Resources
    Popular Tags   Tag posting guidelines   Search Tags  
    Sql Server 2005 Intellisense  .  Formate Sql Statement  .  Find Unused Variables in Stored Procedure  .  

    Awards & Gifts
    Talk to Webmaster Tony John
    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India
    2005 - 2013 All Rights Reserved.
    .NET and other trademarks mentioned in this site belong to Microsoft and other respective trademark owners.
    Articles, tutorials and all other content offered here is for educational purpose only.
    We are not associated with Microsoft or its partners.