Database

FirstPrevNext

Re: SQL type statements without a connection Evan St. John24-Sep-07 4:59 Evan St. John 24-Sep-07 4:59  Yeah, this is strictly for presentational purposes... they have Load and Post proxies I can use to update. What I want to do is create a “Display Table” from 2 or 3 existing tables without writing an excessive amount of code. There are a minimal amount of common columns in the existing tables, so I need to take like 4 or 5 columns from one, and 4 or 5 from another, based on 1 primary in a 3rd. I'm really new to C# and the whole .NET thing, but this seams like it should be a no-brainer of a task. Re: SQL type statements without a connection Paddy Boyd24-Sep-07 5:02 Paddy Boyd 24-Sep-07 5:02  I'm guessing you have a number of datasets each containing a single table? You might be best to copy all these tables to within a single dataset, and you can then set up relationships between these tables (within the dataset). You can then set about coding what you want to see relatively easily. Re: SQL type statements without a connection Mike Dimmick24-Sep-07 5:08 Mike Dimmick 24-Sep-07 5:08  DataTable has a Select method. You can use DataRelations between DataTables to navigate between parent and child tables (using the ParentRelations and ChildRelations properties). Unfortunately there's no built-in Join implementation, and no indexing other than by primary key. .NET Framework 2.0 offers a DataTableReader class which provides the IDBDataReader interface over a DataTable. This might be handy if you have code that can work with either live data coming direct from the database or cached data in a DataSet or DataTable. DoEvents: Generating unexpected recursion since 1991 problem with create trigger Mohammed Elkholy24-Sep-07 2:28 Mohammed Elkholy 24-Sep-07 2:28  i try to create trigger on table to insert values in another table but the is syntax error (Msg 1046, Level 15, State 1, Procedure MoveStudentInfo, Line 20 Subqueries are not allowed in this context. Only scalar expressions are allowed.) here is the trigger script create trigger MoveStudentInfo on Temp_Code after insert as declare @Stu_ID bigint ,@Stu_Code nvarchar(50) select @Stu_ID=Stu_ID from inserted select @Stu_Code=Stu_Code from inserted insert into Student_Info (Stu_Code,Stu_Name,Sex,Nationality,Relagion,Address ,ZipCode,Phone,Mobile,Email,District,BirthPlace,BirthDate,Certificate_Type ,Certification,Department,Grad_Date,Total,Grade_Total,School_name,Stu_Image ,School_SeatNO,National_ID,Region,First_Choice,Second_Choice,Third_Choice ,First_Lang,Second_Lang) values(@Stu_Code,(select Stu_Name,Sex,Nationality,Relagion ,Address,ZipCode,PhoneNO,Mobile,email,District,BirthPlace,BirthDate,Certificate_Type ,Certification,Department,Grad_Date,Total,Grade_Total,school_name,Stu_Image ,School_SeatNO,National_ID,Region,First_Choice,Second_Choice,Third_Choice ,First_Lang,Second_Lang from Student_Registry where Student_ID=@Stu_ID)) thnx for help MD_NADA Re: problem with create trigger kubben24-Sep-07 8:07 kubben 24-Sep-07 8:07  You must use the inserted table for your insert so your code should be something like: Forum SQL / ADO / ADO.NET Subject: Re: problem with create trigger Sender: md_nada Date: 8:28 24 Sep '07 i try to create trigger on table to insert values in another table but the is syntax error (Msg 1046, Level 15, State 1, Procedure MoveStudentInfo, Line 20 Subqueries are not allowed in this context. Only scalar expressions are allowed.) here is the trigger script create trigger MoveStudentInfo on Temp_Code after insert as insert into Student_Info (Stu_Code,Stu_Name,Sex,Nationality,Relagion,Address ,ZipCode,Phone,Mobile,Email,District,BirthPlace,BirthDate,Certificate_Type ,Certification,Department,Grad_Date,Total,Grade_Total,School_name,Stu_Image ,School_SeatNO,National_ID,Region,First_Choice,Second_Choice,Third_Choice ,First_Lang,Second_Lang) select i.Stu_Code, Stu_Name,Sex,Nationality,Relagion ,Address,ZipCode,PhoneNO,Mobile,email,District,BirthPlace,BirthDate,Certificate_Type ,Certification,Department,Grad_Date,Total,Grade_Total,school_name,Stu_Image ,School_SeatNO,National_ID,Region,First_Choice,Second_Choice,Third_Choice ,First_Lang,Second_Lang from inserted i join Student_Registry sr on sr.Student_ID= i.Stu_ID Ben Re: problem with create trigger Mohammed Elkholy24-Sep-07 9:29 Mohammed Elkholy 24-Sep-07 9:29  i dont get the data from the table i add the trigger for him i get the data from another table so i cant use inserted MD_NADA Re: problem with create trigger kubben24-Sep-07 10:49 kubben 24-Sep-07 10:49  Did you even look at the code I posted? I use inserted to join to the table that has the data you need. Your code used inserted to get the value and then use that variable to select the data. Take a look at the code I posted again. Ben Re: problem with create trigger joemonvarghese24-Sep-07 20:31 joemonvarghese 24-Sep-07 20:31  hi please change the insert statement as follows.... insert into Student_Info (Stu_Code,Stu_Name,Sex,Nationality,Relagion,Address ,ZipCode,Phone,Mobile,Email,District,BirthPlace,BirthDate,Certificate_Type ,Certification,Department,Grad_Date,Total,Grade_Total,School_name,Stu_Image ,School_SeatNO,National_ID,Region,First_Choice,Second_Choice,Third_Choice ,First_Lang,Second_Lang) select @Stu_Code,Stu_Name,Sex,Nationality,Relagion ,Address,ZipCode,PhoneNO,Mobile,email,District,BirthPlace,BirthDate,Certificate_Type ,Certification,Department,Grad_Date,Total,Grade_Total,school_name,Stu_Image ,School_SeatNO,National_ID,Region,First_Choice,Second_Choice,Third_Choice ,First_Lang,Second_Lang from Student_Registry where Student_ID=@Stu_ID Difference between Delete and Truncate? ganeshMohan23-Sep-07 20:43 ganeshMohan 23-Sep-07 20:43  hai if anyone known the difference between the delete and truncate and please give me an example thanks in advance Ganesh Mohan Re: Difference between Delete and Truncate? John-ph23-Sep-07 21:18 John-ph 23-Sep-07 21:18  Delete and Truncate performs Identical tasks. but there are differences... Delete is a DML command used to delete a particular record or some set of Records based on the WHERE-Clause. And It can also Delete all the Records when there is no WHERE-Clause specified. The Delete operation performed using Delete Command can be Rolled Back. Truncate is a DDL Command used to delete all the Reocrds from the Table and also it Reinitializes the Table. Primary Key Identity values will be regenerated from the initial value for the subsequent entries after deleting all reocrds. WHERE-Clause can't be used in Truncate Command. The Delete operation performed using Truncate Command can't be Rolled Back. Truncate is much faster than Delete Note : Truncate = Delete + Commit Regards J O H N "Even eagles need a push." David McNally Re: Difference between Delete and Truncate? Pete O'Hanlon23-Sep-07 22:30 Pete O'Hanlon 23-Sep-07 22:30  Good answer. Get's a 5 for its clarity and completeness. Deja View - the feeling that you've seen this post before. Re: Difference between Delete and Truncate? John-ph23-Sep-07 23:11 John-ph 23-Sep-07 23:11  Thanks Pete. Regards J O H N "Even eagles need a push." David McNally Re: Difference between Delete and Truncate? Pete O'Hanlon23-Sep-07 23:29 Pete O'Hanlon 23-Sep-07 23:29  You're welcome. It's always a pleasure to read a detailed and accurate answer. Deja View - the feeling that you've seen this post before. Re: Difference between Delete and Truncate? kubben24-Sep-07 8:32 kubben 24-Sep-07 8:32  I think one other difference is that Delete is logged and truncate is not. Thus the ability to roll back etc. That is also part of the reason that truncate is faster. Ben Re: Difference between Delete and Truncate? kubben24-Sep-07 8:35 kubben 24-Sep-07 8:35  Ok so I guess part of it is logged. I had to look it up. The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table's data, and only the page deallocations are recorded in the transaction log. Ben Re: Difference between Delete and Truncate? ganeshMohan24-Sep-07 19:19 ganeshMohan 24-Sep-07 19:19  Thanks John Re: Difference between Delete and Truncate? Mike Dimmick24-Sep-07 4:09 Mike Dimmick 24-Sep-07 4:09  One other difference is that the user doing the TRUNCATE must have greater permissions than doing a DELETE. DELETE permissions can be granted to a user or role on a per-table basis; on SQL Server 2000, TRUNCATE permissions are only granted to the owner of the table, members of the sysadmin server role, and members of the db_owner or db_ddladmin fixed server roles. SQL Server 2005's documentation is a little unclear, it says that the user must have ALTER permissions on the table but then repeats the sentence from SQL Server 2000 Books Online. Obviously if you're connecting to SQL Server using sa or a trusted connection (Windows authentication) using an administrator account, you have those permissions. However, this is not a good practice as those accounts have full control over the entire database server, and as such, a mistake in your application logic could lead to accidental, or even deliberate, damage. In my view, you should firewall what an application can do by setting up less-privileged server logins and database users. DoEvents: Generating unexpected recursion since 1991 Re: Difference between Delete and Truncate? Sathesh Sakthivel24-Sep-07 21:38 Sathesh Sakthivel 24-Sep-07 21:38  Delete - delete deletes the records from table it can be rollbacked also you can give the where condiition to it. Truncate - delete all records from table There is no rollback it always commit without givening the commit. SSK. Anyone who says sunshine brings happiness has never danced in the rain. SQL Tuning Bad Programmer23-Sep-07 18:50 Bad Programmer 23-Sep-07 18:50  Hi, In Our Organisation we have a CRm which is used by 100 pcs at a time, we are regularly facing the problem of connection timeout bcoz of SQL. Now we plan to increase the seats to 200... Is there any configuration setting that we need to look in to SQL Server 2000. Plz suggest.... Regards, Bala Re: SQL Tuning John-ph23-Sep-07 22:14 John-ph 23-Sep-07 22:14  This problem is due to database connections that are left open and are not closed properly. check your application to make sure that the connections are closed when it is not needed. Even though the concept the garbage collection work fine in ASP.NET to claim the unused resources, sometimes in a busy website the conneection pool will run out of connections before the Garbage collection kicks in. One solution to this problem - you can increase the Pool size to 200 in the connection string. Max Pool Size=200 Regards J O H N "Even eagles need a push." David McNally Read Excel Sheet by oledb Rami Said Abd Alhalim23-Sep-07 2:16 Rami Said Abd Alhalim 23-Sep-07 2:16  oledbcommand cmd=new oledbcommand(@"select F1,F2,F3 from [sheet1$]",con); F2 datatype string when execute command get F2 values Null please i need why get F2 null but if values integer can get data Re: Read Excel Sheet by oledb Paul Conrad23-Sep-07 6:48 Paul Conrad 23-Sep-07 6:48  You posted the same question in the C# forum. Pick only one forum, please. It might have something to do with you having a string in F2... "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus Re: Read Excel Sheet by oledb Rami Said Abd Alhalim23-Sep-07 20:43 Rami Said Abd Alhalim 23-Sep-07 20:43  i read excel sheet all columns can getting but column contain string can not getting can change any setting in connection string or command to solving problems Passing data from stored procedure to windows applicaton Shajeel23-Sep-07 1:01 Shajeel 23-Sep-07 1:01  Hi, I have an application A which runs a stored procedure. I want that stored procedure to get and send data to another application B. What can be the efficient ways, currently we are using temporary table and using pooling on that table by application B. Regards Shajeel Re: Passing data from stored procedure to windows applicaton Mike Dimmick24-Sep-07 4:40 Mike Dimmick 24-Sep-07 4:40  SQL Server doesn't offer any support for that. If you want to pass messages between applications, and have them persist in the case of software or hardware failure, Microsoft's solution is Microsoft Message Queueing[^]. The temporary table is one solution, but do remember that true temporary tables (named with a # or ## prefix) are stored in tempdb, which is not persisted across SQL Server runs. It is recreated from scratch every time SQL Server starts up. I believe it is also recreated whenever a SQL Server cluster fails over to a different node, though I'm not sure about that. SQL Server 2005 and .NET Framework 2.0 offer the SqlDependency class, which can be used to send a query to the database and the database to then call the application back when the results of that query would change. For more information, look up "query notifications" in the index in Books Online. DoEvents: Generating unexpected recursion since 1991

Last Visit: 31-Dec-99 18:00     Last Update: 18-Jun-24 11:16 Refresh ᐊ Prev1...1406140714081409141014111412141314141415 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.