• How do I use primary keys in SQL server?

    I have a table called course,and course_id is primary key in this table. I created another table subject.I mapped these 2 tables by course_id as foreign key,I  created another table teacher,i want to map this with subject, only subject_id to teacher_id mapping is required,how i mapp this,can i...

    Shamu75 pointsBadges:
  • Website redirect to corporate policy page

    We want to block the websites facebook and twitter. We want those pages to redirect to a page displaying company policy on browsing to social sites from our corporate network. How do we go about doing this?

    TeachMeIT975 pointsBadges:
  • Shared formula error message when opening

    Shared formula from /xl/worksheets/sheet3.xml part error message upon opening.

    DebB15 pointsBadges:
  • xp_fileexist workd in Query window but doesnt in stored procedure

    Hello, I am running on SQL server on my local PC . I am singed onto the PC using a network user. This probelm happens if the SQL server service runs as either Local system or network service. In the server management studio if I go to a query window and enter Declare @result int exec xp_fileexist...

    Kendo5 pointsBadges:
  • Can I access job info directly from the CA-View

    What I would like to do is to display a list of jobs that are defined to CA-View then retrieve those jobs using SARBCH. I have a list, but it has to be manually maintined and I am trying to remove that aspect of the process.

    Emwii10 pointsBadges:
  • get an i-Series *LIBL in a .NET program

    I have a .NET programmer asking how he can get the i-Series *LIBL. Based on how the connection is established we can run under 6 different environments. A production and a test for 3 different locations. These are all running on the same i-Series machine. Any ideas or pointers? I have just started...

    ToddN200015,605 pointsBadges:
  • Value Prompt to display ‘no data’

    I am working on Cognos 8.3.Consider a prompt on the prompt page.For eg:Country.For some reason the back-end table data got deleted. When I run the report, the value prompt should display that 'No data to retrieve from back-end'.Is this achieved using Javascript? If yes, how?

    Clarifydoubts5 pointsBadges:
  • Difference Behaviour of Dispose Method Between Winforms and Textboxes

    This question is just for knowledge. Whenever Dispose Method Called for clean Winforms, it's Finalize and disposed. So my question is why not in TextBox case. It Should same behaviour of dispose method against textbox. Instead of clean/dispose it will remain Invisible. If we have no use than it...

    Maheshwag260 pointsBadges:
  • Can RPG call a VB script

    I know very little about anything on a PC. Is there some kind of interface that could be used to execute a VB script which performs a function which returns a parm and get that parm returned back to the RPG pgm.

    CoderHal360 pointsBadges:
  • Indication of new arrival of message using AT+CNMI command in c#.net

    Hello Sir.. I've a problem using AT+CNMI Command.I don't which how to give it in a code.I gave at+cnmi=1,1,0,0,0 then the result is OK and it will not give the possition of the new sms.How can I solve this problem.Thank You in advance

    999559534735 pointsBadges:
  • ASP Overflow

    Is there any way to move back the overflowed data to its original ASP without IPL? Due to space limitations some of the data from ASP 2 has oveflowed into ASP 1. thanks

    Rockleadme385 pointsBadges:
  • Substring A Packed Field

    Hello I have a flat record format that I move into an external data structure. Within the external data structure, I have many packed fields. Rather than refer to each of pacekd field by external field name, I would like to be able to substring each packed field out, and then, move the value of...

    Piano520 pointsBadges:
  • Media Player in Visual Basic 6.0

    How to create a Media player in Visual Basic 6.0 ? using Windows Xp.

    Tipsdawn10 pointsBadges:
  • XML Schema Problem

    hi I have an xml file <UserRoleConsumers> <UserRoleConsumer> <ConsumerID>67</ConsumerID> <RoleConsumerID>89</RoleConsumerID> </UserRoleConsumer> <UserRoleConsumer> <ConsumerID>45</ConsumerID> <RoleConsumerID>78</RoleConsumerID>...

    Dilipd0065 pointsBadges:
  • SQL Insert Error Against Runtime Control Error in FLP

    am trying to insert into sql-2000 database my code is: StringBuilder sb=null; sb=new StringBuilders; sb.Append("Insert into dummy(name,amount) values"); foreach(Control ctl in this.FlowLayoutPanel1.Controls) { if( ctls.Name.Contains("tb") && ctl is TextBox) { sb.Append(ctl.Text); } }...

    Maheshwag260 pointsBadges:
  • Parameter Date Conversion in SQL 2000

    my code is : string sql="insert into dummy(date)values(@date)"; sqlcommand cmd=new sqlcommand(sql,con); cmd.parameters.add("@date",sqldbtype.datetime).values=maskedtextbox1.text text; cmd.executenonquery(); the problem is it's throw and error like  conversion of varchar to date; Note :- my demand...

    Maheshwag260 pointsBadges:
  • Firewall and Google Maps

    Hi All I have an issue at work, I have a user that needs access to google maps and only google maps. Can anyone tell me what IP addresses maps.google.ie use because I have added 21 different IP addresses to the firewall rule and the user still cannot gain access Also I know how to configure a...

    shanekearney810 pointsBadges:
  • DB Table/Query Layout for Ranking System

    Hello, I'm building a Membership DB where Members can achieve certain ranks (Rank1 - Rank14). I would like to present two things: - a list of all Members with their current rank and the Date the rank was achieved - for each Member a list of their ranks and the corresponding dates of achieving them....

    Artificial15 pointsBadges:
  • SharePoint

    What is the main usage of Share Point

    Vamsiknowledge5 pointsBadges:
  • SQL Server 2005 error after development

    I developed an application and when we moved it to the clients site we started getting this error from their SQL 2005 box: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings...

    TeachMeIT975 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following