>Hi,
>
>What is the syntax of adding a placeholder-column to a cursor that would allow NULLs?
>
>Here is the code:
>
>
>select MYTABLE.*, CAST(0 AS INT) AS MyField1 FROM MYTABLE
>
>
>I need to make sure that the column MyField1 would accept NULLs. How do I do it? TIA.
to get a nullable integer field,
the min code on SQL SERVER is:
-- fill with null value
SELECT NULL AS IntField
-- fill with not null value
SELECT CAST(3 AS INT) AS IntField