hi try this select right(space(20) + rtrim(FIELDNAME), 20) from TABLENAME Regards Joe

hi you have to give the values for from date and todate while @fromdate<=@todate begin insert into #Temp(fdate) values(@fromdate) set @fromdate=dateadd(day,1,@fromdate) end Regards Joe

hi you can use DECODE function with which you can replace 0 with some other value. Regards Joe

hi Its a mathematical error..in a division divisor cannnot be Zero. Regards Joe

hi if you are binding a dataset to the grid then it is very easy.... filter the dataset with the value entered in the text box dataset.select(

hi for converting varchar to date use convert(datetime,FIELD) try to include the error message..so that we can identify the problem Regards Joe

hi if you needs only 3 columns specify that columns in your select qry eg: INSERT INTO CHILDTABLE SELECT CONVERT(FIELD1),CONVERT(FIELD2),FIELD3 FROM INSERTED Regards Joe

hi can u give some sample code for this.... Regards Joe

hi you can use convert() function for converting data type and insert it in to the child Table. eg: INSERT INTO CHILD SELECT CONVERT(VARCHAR,FIELD1) FROM INSERTED Regards Joe

hi Use enter prise Manager To remove Users ..Follow these steps 1)To remove a user account from a database role 2)Expand a server group, and then expand a server. 3)Expand Databases, and then expand the database in which the role exists. 4)Click Roles. 5)In the details pane, right-click the role to which the user account belongs, and then click Properties. 6)Select the user to remove, and then click Remove.

hi You can use EnterPriseManager to create the script of objects. Then why r u searching for Stored Procedures. Reagrds Joe

hi plz clarify your question... Regards Joe

hi You can create a back up table and write a trigger on the original Table from which u r client is deleting data.In trigger u wite the code to insert the deleting data in to a backup table.You will get the deleted data from the table "Deleted".U can use this to insert into back up table.Dont forget to insert the datetime at which the data is deleted.. Regards Joe

thnx for the reply i will check it out... Regards Joe

hi plz make use of Sql Help hint: you can achieve this using ALTER TABLE Command ALTER TABLE TABLENAME ADD COLUMNNAME DATATYPE(SIZE) -- modified at 6:11 Tuesday 13th November, 2007

hi while @fromdate<=@todate begin print dateadd(day,1,@fromdate) set @fromdate=dateadd(day,1,@fromdate) end try this Regards Joe

hi line by line debugging of a Stored Procedure is possible in Sql Server 2000.? Regards, Joe

hi presess Ctrl+Alt+S try it..

yes....

hi try this qry select name from syscolumns where id= (select id from sysobjects where name=)