Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Length

    The question refer to nvarchar(30) and not nchar(30)

    So:

    declare @a nvarchar(30)

    set @a='aa'

    select datalength(@a)

    The answer is 4

    declare @a nchar(30)

    set @a='aa'

    select...

  • RE: Execute a large text string

    Download that text field in a local file, let say mycode.sql.

    Call isql for example to execute mycode.sql.

    Example:

    isql /i D:\APP_CODE\control\mycode.sql /Server /Usa /P >  "D:\APP_CODE\control\mycodelog.txt"

     

    George

Viewing 2 posts - 1 through 2 (of 2 total)