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...
The Len(string expression) will give me the length of the string but won't provide me Nth occurance of a partiular character....
i need to...
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...
you can try this..
go thruough enterprise manager and select the database.
Then Right-click on it,Select the 'All Tasks' and 'Shrink Database'...
I have tried to shrink the file in the data file in tempDB with DBCC ShrinkFile but it didn't worked.
Also, i have tried to shrink database with...
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,...
Dinesh has given the solution..
has sorted my problem..
thanks for putting the efforts..
How can i get the Current database name through SQL query in SQL query analyser ?
Thanks in advance...
Separate names with a comma.