I have a query which generates a sequence of records such as:ID other_id
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...
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...
Is there any SQL function that can tell me about Nth occurance of a particular character, i.e.
if my value is ('aabbccaabbcabcabc')
Now, if i...
I have two tables with 250+ columns and when i try to do a join and insert the result of join in the third table with the same number of columns,...
How can i get the Current database name through SQL query in SQL query analyser ?
Thanks in advance...
Separate names with a comma.