Hi, I want to generate unique trx id for that i am using different combination like date time, random number etc. i want to add incremental number to...
I will upload the file for you. Is there any alternative solution to cursor in MSSQL 2000? so that process can be faster
Hi, Thanks melvinlusk for helping me. as i can not post the entire code in this as three/four different procedure also gets called. i will just...
Hi, i have written one cursor in that i am fetching records(around 1000/5000 it varies) , for every record i am doing some operations like checking...
Hi, I have created one stored procedure in which i have written a cursor in which i am fetching some records. on the basis of value(suppose...
hi, i am using sql server 2k, i have written one stored procedure, i want to debug that SP.but it's giving me error Server: Msg 508, Level 16,...
hi, thanx mayur for helping me. can i write all queries one below another, in frontend using one recordset object i can call .is is correct,pls...
Hi, i want to write a stored procedure in which i want to include 4/5 select queries & i want return values which i get from that queries. can it be...
i am inserting all other records through asp(frontend).i want other fields i will insert from frontend & subdate field will automatically take system...
Hi, i am one table "sub1" having fields name,property & subdate.In this subdate i want to insert system date, which should be done automatically. for...
thanx chaloner for ur help, i was trying same thing,but i haven't use single quote in date like '01/01/2006',it was not giving me result.
hi, i am designing website , where i m using ASP as frontend & MSSQL server 2k as backend.in one my table i taken one column as date_sub1,in which i...
Hi, Can anyone tell me the procedure of taking backup of MS Sql server2k db.i ve created one db in sql server 2k, of which i ve to take back up every...
hi, i am using mssql server2k as backend for website. i want to transfer my tables(db) which r on local server to web server. currently i am using...
hi, with respect to same topic i am having one more query. i am using asp as front end & ma sql as back end.In one table i ve taken text as data...
thanx to both of u for helping me.
hi Thank you Madhivanan for helping me.But tell me what size i should specify for text datatype,by default it takes 16. Also i want ask u is this...
hi, I am developing one site, using asp as frontend & MS Sql server 2k as back end. there r some fields in my forms which takes informations in text...
hello, thnaks to all of you, i ve tried snapshot replication method, but it is not solving my problem. i ve tried it on local server. Mr. Satya SKJ ,...
hi, thank you ranjit for helping me. but i don't know about replication in BOL.can you give me brief idea of it please. where i will get info. about...
Separate names with a comma.
