AntonioGK

Hi, I am actually an HR consultant with minor experience in SQL, have asked our developers for help and received the query below, but it is not working - Please help!!! My Client records training for employees, these employees need to be recertified at certain dates. I need a report …

Hi I am facing an issue regarding ASP.net validators. I have a web page which contains 3 textboxes,one drop down list, one radio button and a button to submit the form.Some times the validators are not fired on submitting the form. I checked the validation group and it is correct. …

Hi: I am writing code in VB but SQL is the major role here.. I am checking if MFG="DELL" in table1 and if that is there I need a msg box saying "DELL is supported" [QUOTE] Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim con …

Can a stored procedure be written with a column name? For Table1 with ColA, ColB, ColC, I want a query like: EXEC sp_Mine 'ColA', '100%' I want the results to be like: SELECT ColA, ColB, ColC FROM Table1 WHERE ColA Like '100%' I tried setting up this stored procedure, but …

Hi! Is there any way I can save a database as an SQL file? Or at least save schema if saving data is not possible. Thanks in adv.

I'm working on a project that just needs to know that its 08:00 or 14:01. I dont need or want to store anything about date. When I store the time and then try to check it against the current time I'm runnig into problems. where (timeofevent = Convert(char(19),current_timestamp)) this doesnt …