can you tell me how to write the correct syntax

i need help on this i am getting the following error message

Msg 156, Level 15, State 1, Procedure Load_Audit_Excel, Line 22

Incorrect syntax near the keyword 'Then'.

set...

i know the syntax ,what iam trying to ask here is how will i use in my update/insert statement?can you show me for one of the values.

Thanks

i cannot change the datatypes.can you show me how to use CAST for one of the values for an update and insert statement in my case or a Substring so...

Hi ,

   i get the following error when i run the above query

(0 row(s) affected)

Msg 8152, Level 16, State 2, Line 18

String or binary data would be truncated.

The statement...

LET ME TELL YOU THE EXACT SITUATION

iam using SSIS.I have created a package which gets data from excel and import into sql server database.

now what is happening is i use the...

SELECT

*

FROM

[Header$]

WHERE

[Project #] IS NOT NULL

IF

...

IF

(SELECT COUNT(*) FROM [Header$] WHERE [Project#] IS...

i have found it but i cant still make it work.i would appreciate if you can help me in this case

i need to know what is the syntax for RAISE ERROR

it is similar to that but i want to know how to raise error in this situation

i get the following error message when i execute it.Any Suggestions

select

substring(@string, 1,