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

Post by: Sitanshu, Feb 12, 2006 in forum: General Developer Questions

I dont have the help file...thats y i wrote over here. Sitanshu Gupta

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

Post by: Sitanshu, Jan 24, 2006 in forum: General Developer Questions

no probs, but thanks for giving me the correct ans. its working with Madhivanan's reply. thanks guys. Sitanshu Gupta

In an SP how do we concatenate two fields

Post by: Sitanshu, Jan 24, 2006 in forum: General Developer Questions

the concatenation i have clearly mentioned that. Sitanshu Gupta

In an SP how do we concatenate two fields

Post by: Sitanshu, Jan 24, 2006 in forum: General Developer Questions

no. i dont want the diff i want 23/01/2006-24/01/2006 Sitanshu Gupta

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'

Post by: Sitanshu, Jan 18, 2006 in forum: Performance Tuning for DBAs

thanks dinesh it works. Sitanshu Gupta

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

How to Search for Unused Tables in a Database

Post by: Sitanshu, Jan 18, 2006 in forum: Performance Tuning for DBAs

Which online books should I refer? Sitanshu Gupta

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

Post by: Sitanshu, Jan 17, 2006 in forum: Performance Tuning for DBAs

THANKS MAN...I'LL TRY THIS OUT RITE AWAY 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....