I noticed some odd behavior with the snippet. I put a template for an insert stored procedure that had a header like:
/************************************************************************************************
** Creation Date:
** Author:
**
** Parameters:
** Object Permissions: EXEC
**
** Cross Database Dependency: None**
** Description: Inserts record
**
** Used By:
**
** Ref#'s:
**
**
*************************************************************************************************/
and other basic code following. When i hit test snippet the box where you type the shortcut you want to use, starts to change, and it seems like the whole snippet ends up in the shortcut input box.
Also another thing i noticed maybe a "Nice To Have" when your listing the parameters for the stored procedure after you already selected the stored procedure, it would be nice if you showed the data type along with the parameter name.
Thanks for your time.
CRST
Update**
Just so you know if you put that code in the snippet and save with out running test snippet, the snippet works fine in query analyzer (with the exception of parenthesis() which is a known issue)
/************************************************************************************************
** Creation Date:
** Author:
**
** Parameters:
** Object Permissions: EXEC
**
** Cross Database Dependency: None**
** Description: Inserts record
**
** Used By:
**
** Ref#'s:
**
**
*************************************************************************************************/
and other basic code following. When i hit test snippet the box where you type the shortcut you want to use, starts to change, and it seems like the whole snippet ends up in the shortcut input box.
Also another thing i noticed maybe a "Nice To Have" when your listing the parameters for the stored procedure after you already selected the stored procedure, it would be nice if you showed the data type along with the parameter name.
Thanks for your time.
CRST
Update**
Just so you know if you put that code in the snippet and save with out running test snippet, the snippet works fine in query analyzer (with the exception of parenthesis() which is a known issue)