[hadesownage]

Hello I have a SQL Query who has 10211 characters, how can I use it to create a big table ?

Thanks

[ThatOneGuy]

Originally Posted by hadesownage Hello I have a SQL Query who has 10211 characters, how can I use it to create a big table ? Thanks

It you find your query is too long, instead write a stored procedure and just pass your parameters instead. This is more efficient and safer anyways...

[hadesownage]

Originally Posted by ThatOneGuy It you find your query is too long, instead write a stored procedure and just pass your parameters instead. This is more efficient and safer anyways...

I don't get it. Any example? Thanks!

[ThatOneGuy]

Originally Posted by hadesownage I don't get it. Any example? Thanks!

Read this: http://lmgtfy.com/?q=sql+stored+procedure

It will answer any questions you have about stored procedures. As far as how to call them in SP, just use a regular TQuery like any other query.