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...
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, 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...
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...
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, 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...
Hi, I am developing an application in Vb6.0 & backend as MS-Sqlserver 2k. this application is client-server & also i am developing for web.in this my...
Separate names with a comma.
