Database

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

BobInNJ wrote:

when I define a decimal data type as 4,2 that means exactly two digits to the right of the decimal point, not two or less. Do I have this right?

I are Troll

Select Convert(DECIMAL(4,2), 123.4)

TheJudeDude wrote:

DATEDIFF('d','2009-11-08','2009-11-08')

DATEDIFF(d,'2009-11-08','2009-11-08')

DATEDIFF(dd,'2009-11-08','2009-11-08')

DATEDIFF(day,'2009-11-08','2009-11-08')

OdbcConnection DbConnection = new OdbcConnection("DSN=rsss");
    OdbcCommand DbCommand = DbConnection.CreateCommand();
    DbCommand.CommandText = "SELECT TICKET-STORE, DATEDIFF(day,'" + strDate + "','" + strDate + "') AS EXP FROM TICKET";
    DbConnection.Open();
    try
    {
        DbReader = DbCommand.ExecuteReader();
        while(DbReader.Read())
        {
            intStore = Int32.Parse(DbReader["TICKET-STORE"].ToString());
        }
    }

    catch(OdbcException caught)
    {
        Console.WriteLine(caught.ToString());
        Console.Read();

        DbConnection.Close();
    }

System.Data.Odbc.OdbcException: ERROR [HY000] Build Error: Invalid Function Name.  Function name is 'DATEDIFF'.
   at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
   at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Odbc.OdbcCommand.ExecuteReader()
   at acctmgr.Class1.Main(String[] args) in c:\documents and settings\brian\my documents\visual studio projects\acctmgr\class1.cs:line 43