Login
Register
Tutorials
Forum
Career Development
Resources
Reviews
Jobs
Interview
Communities
Projects
Training
Silverlight Games
|
Bookmarks
|
New Members FAQ
|
Mentor
|
Code Converter
|
IT Companies
|
Peer Appraisal
|
Members
|
Revenue Sharing
|
Computer Jokes
|
New Posts
|
Social
|
Online Members
Bibillis
Md mirza ansar baig
venkateswarao
Pawan Awasthi
More...
Resources
»
SQL Server
Tool for Formatting Sql Statements or TSQL
Posted Date:
15-Jun-2012
Category:
SQL Server
Author:
Ravindra Gaurana
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!
Tweet
Responses to "Tool for Formatting Sql Statements or TSQL"
No responses found. Be the first to respond...
Feedbacks
Post Comment:
Notify me by email when others post comments to this article.
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
Evaluate And Execute IF Statement in Formula Editor
What is cursor in Sql Server and its type?
Collation in SQL Server
Generate Scripts for database using wizard
VIEW in SQL Server : A short trip
Indexes in sql server
Popular Tags
Tag posting guidelines
Search Tags
Sql Server 2005 Intellisense
.
Formate Sql Statement
.
Find Unused Variables in Stored Procedure
.
Active Members
Today
Pawan Awasthi
(42)
naveensanagase...
(21)
Prasad kulkarn...
(11)
Last 7 Days
naveensanagase...
(224)
Naved Hasan ...
(189)
Pawan Awasthi
(186)
more...
Awards & Gifts
Email subscription
.NET Jobs
.NET Articles
.NET Forums
Articles Rss Feeds
Forum Rss Feeds
Talk to Webmaster Tony John