I have a query which generates a sequence of records such as:ID other_id
try ISQL rather that OSQL.
I want to execute ISQL with a command and the output should go to a .CSV file. The problem is that when i am executing the command, the value of...
I have to validate the strings in two columns for the same contents but the strings contain the words in different order.eg.
Column1 contain the...
Thanks for the replies:
The problem is when i have extra fields in my data file, the extra fields are appearing in the last field of the table...
I want to bulk insert a file having some records.
The problem is if one of the records have less number of fields than expected by database...
How can i search for the first occurance of a character in a string from the right???
since the function charindex gives the first occurance of...
I am using SQL server IsDate function to check for the valid dates.
I have values 2005/12/31 10:10:10 and 2005/31/12 10:10:10.
My SQL server...
Separate names with a comma.