can anyone help me regarding tool

hi
is there any tool to write stored procedure
i have long queries to write instead of that i want a tool or editor where i can click or drag and drop to write procedure
i make my work to complete faster
if any please tell me the site to download
thanx
bye
ramesh

Hi Ramesh,
Maybe is this something your looking for:
http://www.softcities.com/Lattice.SPGen-Stored-Procedure-Generator/download/16114.htm
or
http://www.freevbcode.com/ShowCode.asp?ID=3412
I never used these programs but i just did a search on google for you.
mgg

Can .BCP file open in text editor?

Hello!
I think I have asked this question eariler and I am asking it again. Can
a .BCP file (which is a binary file) be opened in any Text Editor (or
any program)?
Thanks for your help!
*** Sent via Developersdex http://www.examnotes.net ***> I think I have asked this question eariler and I am asking it again. Can
> a .BCP file (which is a binary file) be opened in any Text Editor (or
> any program)?
Yes. It is useful? No.|||Test Test (farooqhs_2000@.yahoo.com) writes:
> I think I have asked this question eariler and I am asking it again. Can
> a .BCP file (which is a binary file) be opened in any Text Editor (or
> any program)?
Yes, but if the file is binary it's better to open it in a hex editor,
at least in an editor which can show files in hex format. One example
is Textpad, http://www.textpad.com. Textpad looks at the file ending,
and defaults to text format, but this is configurable. You can also
opt to open a certain file as binary rather than text.
Whatever you do, be careful with editing binary files. The file could
be mashed completely if you are not careful.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx