Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 04-06-2009
Member
 
Join Date: Feb 2009
Posts: 14
How To Check SQL Syntax in Server

Hello , I Am Using the SQL Server Management Studio , But I Dont How to Check the Syntax For Sql Queries , Can you Tell me How Can i Check the Sql Syntax In Query Analyzer or Is there a way to Check to within or in SQL Server Management Studio It Self , I Want To find Out Syntax Errors , Thanks in advance For Your Replies
Reply With Quote
  #2  
Old 04-06-2009
Member
 
Join Date: May 2008
Posts: 115
Re: How To Check SQL Syntax in Server

You Can use Mimer SQL Validator All too often people find themselves locked into a specific DBMS because their SQL code doesn't conform to the SQL standard Mimer SQL Validator gives you the low down on your code and helps you by providing a list of lexical units (tokens) and a suggested correction. Also, use the validator to find out exactly which words are vendor-reserved.
Reply With Quote
  #3  
Old 04-06-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
Re: How To Check SQL Syntax in Server

Alternatively i Think there is a Software Called as CAST Which has a free product called Code-Checker that will check your PL/SQL code for you and suggest where there are errors or you could stand some improvement. The checks range from structural to procedural and can pinpoint potential performance issues.I think You Can Use it
Reply With Quote
  #4  
Old 04-06-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: How To Check SQL Syntax in Server

You Can prefix the SQL statement with the word EXPLAIN. This will catch any syntax errors and verify that all the names referenced in the statement are valid. and also in Management Studio, there is a button with a Checkmark on the toolbar. That will syntax check the sql without running it.
Reply With Quote
  #5  
Old 04-06-2009
Member
 
Join Date: May 2008
Posts: 2,383
Re: How To Check SQL Syntax in Server

Use the Check push button to parse an SQL statement. Parsing the statement checks it for correct SQL syntax.

To check SQL syntax:
  • Edit the SQL statement in the SQL code view.
  • Click Check. If the SQL code is invalid, an error message window opens.
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
  #6  
Old 24-01-2012
Member
 
Join Date: Jan 2012
Posts: 1
Re: How To Check SQL Syntax in Server

We use DIAB (DbaInABox), it has an excellent tool for checking SQL code on Windows SQL Server called SQL code check. It's part of a larger package but hey! lots of extras so not a bad deal.
Reply With Quote
  #7  
Old 27-03-2012
openxcellaus
 
Posts: n/a
Re: How To Check SQL Syntax in Server

I think DIAB core resources have good powerful properties making them ideal for applications where shock and effect loads could be experienced. It is used for structural members paneling.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How To Check SQL Syntax in Server"
Thread Thread Starter Forum Replies Last Post
How can I force a machine to check in with the WSUS server? Billie Server Update Service 4 14-05-2012 05:45 PM
SQL Server - Update Query Syntax Error rmadler Software Development 2 02-02-2010 05:10 AM
Which syntax to type to check computers network connectivity on Windows Xp Sori Networking & Security 3 12-10-2009 10:34 AM
Exchange HTTP Virtual Server Instance 100 :The IsAlive check for t Taj Windows Server Help 21 26-07-2007 04:04 AM


All times are GMT +5.5. The time now is 08:56 PM.