Can any one of you provide stored procedure for comparing two SQL Server Database Schema or any other way for comparison.
I would like to know, any body have currency conversion stored procedure, please post me.
for ex: dollar to euro..vice versa..etc..
I have table i need to identify one record qty column shld be -ve value and another one is shld be +ve value ?
One record name shld be starts...
one of the requirement i want to store ouput as below,any bdy can help..thanks
hi when i try to retrieve stored proc text iam getting some extra spaces, is there any settings for this
any body can u please send me sp_changeobjectowner and sp_changedbowner as i need change object owner.unfortunately got dropped in my db
We are planning to migrate from sql server 2000 to 2005. can you please let me know what are the steps to be taken care.
I have table and data has stored firstname , last name
I want to split the first name...
I have table like this
badly I want to show output like this...
I have data like this, i want to find out the required value.
The qry lists all open Fail trades from x Fails table grouped by CNo and AccNo. The Pair off report displays all open tags that can be paired off...
i have one oracle sp, i need to convert into sqlserver sp. any bdy help..thanks advance
the SP look like this.
CREATE PROCEDURE Concat_text
Transact-SQL Optimization Tips
â€¢Use views and stored procedures instead of heavy-duty queries.
This can reduce network traffic, because your...
Is there any other alternative way for selecting group by records..my qry is taking little bit time for retreiveing records...
I want to transfer the database from once place to other place..
thanks in advance...
I have two tables A and B having amount columns, While inserting i have to check the both amount columns, based on the input amount i have to...
I have a table like this...
upto 40 rows
in reporting purpose i want to show the output like...
Congratulations to Satya for (10000-100) posts upto now...
I have done update statistics for one table, unfortunately i did the same thing onceagain to that table.
Is anything effect that table or not ?...
Is there any way to re-write this query. The query is correct one, but i am not able to get the data faster.
I am combining the same qry with...
Separate names with a comma.