Member Avatar for spxChrome

Hi, I am writing a little app that will have a rich text box that users will be able to write SQL statements and save them to SQL Server table. I would like to validate the SQL statement before saving the string. Because another process picks up the string and executes it. Is there is object that will valiate a SQL string without actually executing it?

Thanks

  • 2 Contributors
  • 1 Reply
  • 98 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by poojavb
Member Avatar for poojavb

u can give the command SET NOEXEC ON and then the sql query...it will just compile

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.