Database

FirstPrevNext

Re: error while creating the table Vimalsoft(Pty) Ltd11-Apr-07 0:58 Vimalsoft(Pty) Ltd 11-Apr-07 0:58  Post your Syntax here and infact write all the systax here then we will be able to help you Vuyiswa Deletion with relationship sujithkumarsl2-Apr-07 2:45 sujithkumarsl 2-Apr-07 2:45  I have three tables in msaccess which are related with each other using forign keys. I want to delete the row of the innertable and second table with a single query can u help me? My small attempt... Re: Deletion with relationship joon vh.2-Apr-07 3:15 joon vh. 2-Apr-07 3:15  You should look for information about Referential integrity. You can force relations to be updated cascading or not in the properties of a relation. Wiki on referential integrity: http://en.wikipedia.org/wiki/Referential_integrity[^] The syntax for a delete command is found here: http://www.w3schools.com/sql/sql_delete.asp[^] Visual Studio can't evaluate this, can you? public object moo<br /> {<br /> __get { return moo; }<br /> __set { moo = value; }<br /> } Hi sree reddy1-Apr-07 23:24 sree reddy 1-Apr-07 23:24  I need ur help for designing PAYROLL DataBase. Any Knows Plz Send Me(US PAYROLL)> sree reddy Re: Hi sree reddy1-Apr-07 23:26 sree reddy 1-Apr-07 23:26  I need ur help for designing PAYROLL DataBase. Any body Knows Plz Send Me(US PAYROLL) sree reddy Re: Hi Colin Angus Mackay2-Apr-07 0:08 Colin Angus Mackay 2-Apr-07 0:08  sree reddy wrote: I need ur help for designing PAYROLL DataBase Start with the customer's requirements. What do they require the payroll database to hold? What do they require it to do? Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website Re: Hi jijoaresseriljose2-Apr-07 1:31 jijoaresseriljose 2-Apr-07 1:31  hi, Hey...how others can db design upon your requirements ..... regards jijo jose New to SQL Zalro1-Apr-07 20:52 Zalro 1-Apr-07 20:52  Hi I am new to SQL .. Curently I am trying to do database mirroring in SQL Server Management Studio Express.. After i have made a back up and restore it on another computer, there would be a Mirror choice for me to click under the tasks option after right clicking on my database . But the Mirror choice does not appear there.. What could the problem be ? Anyone can help me ? Thanks in advance... SQl Query Problem Devkranth Kishore Vanja1-Apr-07 20:16 Devkranth Kishore Vanja 1-Apr-07 20:16  hi to all My name is Devkranth .. i need help in sql.... i have 3 tables to retrieve data and display it.. there is no Primary key in any table.. but there is a common column , so if i join the tables i am getting rows duplicated... plz help me.. thanks in advance Re: SQl Query Problem jijoaresseriljose1-Apr-07 20:24 jijoaresseriljose 1-Apr-07 20:24  hi, you can add identity column for these tables and join with this column. regards jijo jose Re: SQl Query Problem Devkranth Kishore Vanja1-Apr-07 20:41 Devkranth Kishore Vanja 1-Apr-07 20:41  hi jojo Thanks 4 ur reply.. i will just try it and come back to u.. Re: SQl Query Problem pradeep.shukla1-Apr-07 20:34 pradeep.shukla 1-Apr-07 20:34  after joining all tables use one of them and put a criteria like this --where fielname in ( select distinct fieldname from table1)-- this may solve the of duplicacy. Pradeep Shukla Re: SQl Query Problem Devkranth Kishore Vanja1-Apr-07 20:43 Devkranth Kishore Vanja 1-Apr-07 20:43  thanks Pradeeop well will try it and get back soon.. How to use report generated by sql server 2005 reporting service in web application mohd imran abdul aziz1-Apr-07 18:19 mohd imran abdul aziz 1-Apr-07 18:19  Dear All, I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2005 as a back End I now want to generate report using through sql server reporting services. Please give me some useful link so that I can able to use report generated by sql server 2005 through my web application Thanks regards imran khan Plz answer these yaminilatha1-Apr-07 17:54 yaminilatha 1-Apr-07 17:54  1. If there are duplicate rows in a table how do you retrieve them. We can use select distinct(fieldname) but not in this way. Is there any other way. 2. After reading the reading like, while(dr.read()) {} can we close the reader automatically without calling dr.close(). yamini Re: Plz answer these Krish - KP1-Apr-07 18:22 Krish - KP 1-Apr-07 18:22  1. listing only duplicate row data is possible. need table structure and sample data. 2. to my knowledge gargabe collector should do. Regards KP Re: Plz answer these yaminilatha1-Apr-07 23:45 yaminilatha 1-Apr-07 23:45  suppose there are five similar records like same name, id, dept then without writing a query in sqlserver how are the duplicates removed means only a single record should be retrieved. thanx, yamini Re: Plz answer these Krish - KP2-Apr-07 0:11 Krish - KP 2-Apr-07 0:11  i regret, i'm, not getting your query. can you explain in detail Regards KP Re: Plz answer these Colin Angus Mackay1-Apr-07 22:02 Colin Angus Mackay 1-Apr-07 22:02  Regarding #2 Although you don't have to call Close() it is advisable. While the DataReader is open you are tying up the connection so it cannot be used until the reader has been collected by the garbage collector. You don't have any control over when the garbage collector will collect the reader. Another option is to wrap it in a using statment and have C# close it when it drops out of scope using(SqlDataReader dr = cmd.ExecuteReader()) { while(dr.Read()) { // Do stuff. } } Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website Re: Plz answer these Pete O'Hanlon2-Apr-07 1:41 Pete O'Hanlon 2-Apr-07 1:41  1. Take a look at using HAVING COUNT to identify duplicated rows. Deja View - the feeling that you've seen this post before. Inserting documents into SQL server 2000 missrej1-Apr-07 6:21 missrej 1-Apr-07 6:21  I am doing a project in Visual Studio .net (language C#). How can I store documents (like Word, Excel, PPT etc.) in an SQL server 2000. Please can anybody provide some useful links or the exact method/code. Re: Inserting documents into SQL server 2000 Hesham Amin1-Apr-07 6:30 Hesham Amin 1-Apr-07 6:30  Hi Check this sample[^] Hesham A. Amin My blog INSERT Query nadinekamal1-Apr-07 4:47 nadinekamal 1-Apr-07 4:47  Hi, I'm new to SQL and I want to give the INSERT statement a variable as its value instead of a constant. Can this be done? If yes then how?? Thanks Re: INSERT Query Bernard Aoun1-Apr-07 5:57 Bernard Aoun 1-Apr-07 5:57  Yes Sure you can do that. All what you need to do is add parameters to your insert statment. Example: insert into temptable (col1,col2) values (@username,@date) the @username and @date are the parameters you have to assign values to in you command object. Example : mycommand.parameters.add("@username","Value of the username") mycommand.parameters.add("@date","Value of the date") then you execute the command Regards, Select Query Girish48131-Mar-07 18:57 Girish481 31-Mar-07 18:57  There are 2 Tables, 1.Marks 2.Ctrl Marks Table have following Data : CtrlKey M1 M2 M3 M4 M5 M6 1 10 18 00 13 12 19 2 20 21 23 24 18 AB ... Ctrl Table Have following Data : CtrlKey Rollno 1 11 1 12 1 13 1 14 1 15 1 16 2 17 2 18 2 19 2 20 2 21 2 22 ... there is a new ctrlkey on every 6 rollnos I want Output Should like this : Rollno Marks (like Foreign Key) 11 10 12 18 13 00 14 13 15 12 16 19 17 20 18 21 ... Please help me to write a single select query to get output. Girish Kumar Sharma

Last Visit: 31-Dec-99 18:00     Last Update: 2-May-24 12:26 Refresh ᐊ Prev1...1612161316141615161616171618161916201621 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.