Mike DiRenzo (3/10/2008)

---

One forum poster said it worked for him in SSMS.

create proc kev_test
(
@param1 varchar(50),
@param2 varchar(50)
)
as set nocount on
select 'the first parameter is ' + @param1 + ' the second is ' + @param2

'first param','second param'

the first parameter is first param the second is second param

Andrew_Webster (3/18/2008)

---

Top tip for working with the INFORMATION_SCHEMA views: use Excel to view them.

In Excel, go to Data, Import External Data..., then either Import Data or New Database Query. Use or create a DSN and fish out the INFORMATION_SCHEMA view that your interested in. COLUMNS is the one I use the most.

Then use Excel's Autofilter and you got yourself a Data Dictionary that you can filter to find, say, all fields with the same name, all fields of the same datatype (use char instead of nchar and have a feeling you've done it somewhere else too?), or whatever.