Forum Replies Created

Viewing 15 posts - 421 through 435 (of 2,038 total)

  • RE: CLR TVF-: how can we send the optinal parameter

    Paul White (7/9/2009)

    Florian Reischl (7/9/2009)

    Nope. I meant optional parameters with default values like often done in C++ or VB6 (don't know if VB.NET supports this feature any more). The "params"...

    July 9, 2009 at 4:15 pm

    #1022757

  • RE: Are the posted questions getting worse?

    Paul White (7/9/2009)

    Florian Reischl (7/9/2009)

    Bruce W Cassidy (7/9/2009)

    Paul White (7/9/2009)

    Ah - so you are a fan of anti-verbositization then :w00t:

    [font="Verdana"]If only mere words could express my floccinaucinihilipilification of verbiage...[/font]

    :unsure:

    floccinaucinihilipilification

    [answer]

    Thanks

    [/answer]

    [verbositization]

    ThankyouPaulfouryourlinkItisalwaysnicetolearnnewthingsaboutEnglishlanguage

    [/verbositization]

    Anyone else...

    July 9, 2009 at 4:07 pm

    #1022753

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (7/9/2009)

    Paul White (7/9/2009)

    Ah - so you are a fan of anti-verbositization then :w00t:

    [font="Verdana"]If only mere words could express my floccinaucinihilipilification of verbiage...[/font]

    :unsure:

    July 9, 2009 at 3:53 pm

    #1022743

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (7/9/2009)

    Crap. Why do we still bother sending our kids to an expensive German School here in Cape Town when they really don't need to learn German...

    July 9, 2009 at 3:49 pm

    #1022740

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (7/9/2009)

    [font="Verdana"]My personal motto is to never use a large word where a diminutive one will do. :-P[/font]

    So you will never work in a German government. They...

    July 9, 2009 at 3:41 pm

    #1022733

  • RE: Are the posted questions getting worse?

    Paul White (7/9/2009)

    Jan Van der Eecken (7/9/2009)

    10 out of 10 for this translation goes to Paul. Or was it Google?:-)

    Quite clearly Google 😎

    Mein Deutsch ist sehr grundlegende. :unsure:

    Very well! Just...

    July 9, 2009 at 3:38 pm

    #1022732

  • RE: CLR TVF-: how can we send the optinal parameter

    Hi Paul!

    Paul White (7/9/2009)

    Florian Reischl (7/9/2009)

    I'm really happy that C# does not give the possibility to implement optional parameters.

    So...you mean optional paramaters like Console.WriteLine("{0} posted {1} {2}.", "Flo", "yesterday", "afternoon");...

    July 9, 2009 at 3:33 pm

    #1022725

  • RE: Pass Database Variable Names in SQL Command

    Sorry, I recognized that this is the "SSIS Forum" after I posted my answer...

    Since I'm primary a .NET developer I would use wild-cards within the scripts and a Script Task...

    July 9, 2009 at 3:09 pm

    #1022709

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (7/9/2009)

    Florian Reischl (7/9/2009)

    Lynn Pettis (7/9/2009)

    Florian Reischl (7/9/2009)

    Augeninnendruckmessgeräteprüfungsgesetzverpflichtungsformularvordrucklayouterstellungsassistent

    Care to provide a translation?

    I feared this question... it's very hard kind of officialese.

    @chad-2: Right direction since you ordered the...

    July 9, 2009 at 3:06 pm

    #1022706

  • RE: How to find Total Number of Tables in All the databases on a Server?

    You can use sp_MSForeachdb and a temp table:

    CREATE TABLE #t (DbName NVARCHAR(128), TableCount INT)

    EXECUTE sp_MSforeachdb 'INSERT INTO #t SELECT ''?'', COUNT(*) FROM [?].sys.tables'

    SELECT * FROM #t

    DROP TABLE #t

    July 9, 2009 at 2:59 pm

    #1022702

  • RE: SET Commands

    Have a look to sys.dm_exec_sessions:

    SELECT * FROM sys.dm_exec_sessions WHERE session_id = @@SPID

    July 9, 2009 at 2:56 pm

    #1022700

  • RE: Pass Database Variable Names in SQL Command

    You can use SQLCMD mode (Menu -> Query -> SQLCMD Mode) like this:

    :setvar DatabaseName "Sandbox"

    SELECT COUNT(*) FROM [$(DatabaseName)].dbo.Tally

    Edit: Dang! Sorry didn't notice the SSIS forum. Sorry!

    July 9, 2009 at 2:32 pm

    #1022680

  • RE: IE 8 and Office Live Workspace

    Thanks for your responses.

    At work I use IE8 on XP x32, without any problems using SharePoint or OfficeLive there. In my case it just don't work on a x64 system.

    July 9, 2009 at 2:26 pm

    #1022676

  • RE: charindex() and substring() functions

    Not smaller but maybe a little bit more simple to maintain:

    ; WITH cte (name, fname) AS

    (

    SELECT

    name,

    ...

    July 9, 2009 at 2:23 pm

    #1022671

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/9/2009)

    Florian Reischl (7/9/2009)

    Augeninnendruckmessgeräteprüfungsgesetzverpflichtungsformularvordrucklayouterstellungsassistent

    Care to provide a translation?

    I feared this question... it's very hard kind of officialese.

    @chad-2: Right direction since you ordered the pizza.

    I did my best to translate...

    July 9, 2009 at 2:10 pm

    #1022660

Viewing 15 posts - 421 through 435 (of 2,038 total)