Database

System.Data.DataSet myDS = new System.Data.DataSet();
System.Data.SqlClient.SqlDataAdapter myAdaptor 
    = new System.Data.SqlClient.SqlDataAdapter("Execute myProcedure;"
     ,new System.Data.SqlClient.SqlConnection(myConnectionString));
myAdaptor.Fill(myDS)

The Man from U.N.C.L.E. wrote:

You can't.

Declare @GetDBNames sysname
Declare @DynSql nvarchar(max)
declare @result table ([Database_Name] nvarchar(128), [Stored Procedure Name] sysname)

Declare DBNames cursor for 
Select '['+name+']' from master.dbo.sysdatabases 

open DBNames
FETCH NEXT FROM DBNames into @GetDBNames

WHILE @@FETCH_STATUS=0
BEGIN

SET @DynSql = '
Select Specific_Catalog as Database_Name, Routine_Name as ''Stored Procedure Name''
From '+ @GetDBNames+'.Information_Schema.Routines '


insert @result exec sp_executesql @DynSql 

FETCH NEXT FROM DBNames into @GetDBNames
END
Close DBNames
Deallocate DBNames
select * from @result

declare @str as varchar(100)
set @str = 'Where are you now?' -- original data
select REPLACE(@str,' ' ,'') as RemoveSpace

RemoveSpace
Whereareyounow?

declare @tbl table(SomeField varchar(50))
insert into @tbl(SomeField) values('Bob''s')
select * from @tbl 

Bob's

BobInNJ wrote:

insert statement does not work

Msg 8115, Level 16, State 8, Line 1<br />
Arithmetic overflow error converting numeric to data type numeric.<br />
The statement has been terminated.<br />

DECLARE @TestTable TABLE(
    Column1 DECIMAL(18,2))

INSERT 
  INTO @TestTable
       (Column1) 
VALUES (123.4)

SELECT *
  FROM @TestTable

I are Troll