Search Results | SQL Server Performance Forums

Checking a string in SP

Thread by: Sitanshu, Feb 22, 2006, 2 replies, in forum: General Developer Questions

Hi All, 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...

Exact Difference between varchar and nvarchar

Thread by: Sitanshu, Feb 12, 2006, 7 replies, in forum: General Developer Questions

Hi All, I want to know the exact difference between Varchar and nVarchar. If possible please give me the advantages and disadvantages of their...

Two exactly same rows- want to delete only one

Thread by: Sitanshu, Jan 31, 2006, 9 replies, in forum: General Developer Questions

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...

In an SP how do we concatenate two fields

Thread by: Sitanshu, Jan 24, 2006, 9 replies, in forum: General Developer Questions

Hi All, 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? Sitanshu...

How to update a table with name like 'berry's'

Thread by: Sitanshu, Jan 18, 2006, 3 replies, in forum: Performance Tuning for DBAs

Dear All, 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: Just...

To Search for Unused Stored Proc in a Database

Thread by: Sitanshu, Jan 17, 2006, 5 replies, in forum: Performance Tuning for DBAs

How to search for UNUSED Stored Procedures in a database in SQL Server 2000. Sitanshu Gupta

How to Search for Unused Tables in a Database

Thread by: Sitanshu, Jan 17, 2006, 9 replies, in forum: Performance Tuning for DBAs

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....