I have a question for you guys.
I take a string as a parameter into my SP.
Now I want to check, within the SP, if that string contains...
I dont have the help file...thats y i wrote over here.
I want to know the exact difference between Varchar and nVarchar.
If possible please give me the advantages and disadvantages of their...
I have a table in which there are two records that are exactly the same. I want to delete only one of those records...
How do I do it in SQL Query...
but thanks for giving me the correct ans.
its working with Madhivanan's reply.
i have clearly mentioned that.
i dont want the diff
In an SP how do we concatenate two fields.
eg: i have 2 date fields and i want the result as 'date1-date2'
How do I go about it?
How should I write a field value like - berry's.
I want to update this value in a row.
To make it clear, let me give you an example:
Which online books should I refer?
How to search for UNUSED Stored Procedures in a database in SQL Server 2000.
THANKS MAN...I'LL TRY THIS OUT RITE AWAY
How to search for UNUSED tables in a Database in SQL Server 2000. I need to do this for the optimization of my project.
I am new to SQL Server 2000....
Separate names with a comma.