Forum Replies Created

Viewing 15 posts - 316 through 330 (of 423 total)

  • RE: NULL VALUES

    Just FYI...

    You can change the default value (constraint) of any column while in design mode. (See attached screen shot.)

    If you add a constraint and set the column to not allow...

    January 7, 2013 at 9:33 am

    #1574393

  • RE: Single Quotation Marks in SQL

    Eirikur Eiriksson (1/6/2013)

    One workaround is to use tokens when writing dynamic SQL statements, especially if nested more than one level;

    That sounds like a great idea. I've never seen the problem...

    January 6, 2013 at 2:22 pm

    #1574139

  • RE: Null vs ''

    To NULL or not to NULL, that is the question... 😛

    Whatever you choose, I'd do something like this:

    --Get rid of any leading, trailing, or single spaces then if blank make...

    January 4, 2013 at 6:09 pm

    #1574004

  • RE: Dynamic SQL - which would you use?

    tony@kenny.net (1/3/2013)

    My question: Which way do you swing? Do you have any other ways? Any other comments welcome.

    FWIW, this is how I'd probably do it. I like to get rid...

    January 4, 2013 at 5:39 pm

    #1573998

  • RE: Trying to convert the result set into HTML format but have problem with XML column

    I tried and failed to run a query that would produce the "Missing Index" option, so I can't confirm that the code below does exactly what you are looking for....

    January 4, 2013 at 5:16 pm

    #1573994

  • RE: Single Quotation Marks in SQL

    sknox (1/4/2013)

    Steven Willis (1/4/2013)

    For anyone who really cares about proper typography The Chicago Manual of Style is the editor's Bible.

     

    Oh. I thought the Chicago Manual of Style was about pinstripes...

    January 4, 2013 at 10:36 am

    #1573861

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    telcogod (1/4/2013)

    hi sorry i haven't tested for performance or sure if this has been done but removed the ctelen

    IF OBJECT_ID('dbo.DelimitedSplit8K') IS NOT NULL

    DROP FUNCTION [dbo].[DelimitedSplit8K]

    go

    CREATE FUNCTION [dbo].[DelimitedSplit8K]

    ...

    January 4, 2013 at 10:30 am

    #1573859

  • RE: Single Quotation Marks in SQL

    The standard ASCII character set is a holdover from the early days of teletype, band printers, computers and manual typewriters. (How many of you have ever seen a band printer?...

    January 4, 2013 at 9:58 am

    #1573832

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    klini (1/3/2013)

    I didn't see the source code for the CLR function. I also didn't read all 473 posts before mine, so maybe there's a link to it somewhere..

    It's in...

    January 3, 2013 at 9:42 am

    #1573395

  • RE: Time - Adding minutes and seconds

    Jeff Moden (12/24/2012)...I also have a hard time understanding why people would want to separate date and time even for display purposes unless they are, in fact, just trying to...

    January 2, 2013 at 10:32 am

    #1572977

  • RE: Need To Generate XML File

    sarwaanmca (12/28/2012)

    I am already tried following Method..

    select * from xmldata FOR XML AUTO

    select * from xmldata FOR XML AUTO, ELEMENTS

    SELECT * FROM xmldata FOR XML PATH('Root')

    select...

    January 1, 2013 at 1:14 pm

    #1572708

  • RE: Automatically Generate Stored Procedures

    eliassal (1/1/2013)

    ...however, the produced code is not formated, the output comes as a single line...

    I couldn't function without my RedGate tools (SQL Developer Bundle[/url]).

    With RedGate SQL Prompt you just highlight...

    January 1, 2013 at 12:50 pm

    #1572706

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    mister.magoo (12/29/2012)

    Steven Willis (12/28/2012)

    Here's Mr. Magoo's method for splitting element pairs:

    Gosh, I hope that was a mistake?

    That code was not the best version of the XML split for that problem...

    December 30, 2012 at 12:48 pm

    #1572410

  • RE: Split input string into multicolumn - multirows

    Jeff Moden (12/28/2012)

    Steven Willis (12/28/2012)

    Here's the new splitter function as I tested it...I'm sure someone may be able to improve it even more.

    Very cool. Thanks for posting that code....

    December 29, 2012 at 12:11 pm

    #1572354

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Jeff Moden (12/28/2012)Heh... now that I've said that, I wonder if dumping the first split into a Temp Table and them resplitting that would be faster than the XML method?...

    December 29, 2012 at 11:48 am

    #1572353

Viewing 15 posts - 316 through 330 (of 423 total)