|
hey people i hope you can help me out
im using c sharp and sqlite and when i do inserts sometimes one or two arguments in the sqlite query have the character ' and it throws an exception,so far i have only noticed this happens with just that character, anyone knows how can i insert or update records with the character ' ??
someone told me that it could be solved using parameters but i dont know how to use them
thanks in advance
|
|
|
|
|
Parameters is the correct way to do this. The parameter type depends on how you connect to the database. For example if you connect using OleDbConnection, you would use: OleDbParameter[^]
|
|
|
|
|
thanks man i got it now , appreciate it
|
|
|
|
|
|
Hi,
What's the execution order of a multiple join like this:
SELECT EMPNO, LASTNAME, DEPTNAME, PROJNO
FROM CORPDATA.EMPLOYEE XXX LEFT OUTER JOIN CORPDATA.DEPARTMENT YYY
ON XXX.WORKDEPT = YYY.DEPTNO
LEFT OUTER JOIN CORPDATA.PROJECT ZZZ
ON XXX.EMPNO = ZZZ.RESPEMP
WHERE XXX.EMPNO = YYY.MGRNO AND
YYY.DEPTNO IN ('A00', 'D01', 'D11', 'D21', 'E11')
which query runs first, which one next , ..... ?
Best wishes
|
|
|
|
|
first it filter record according to
CORPDATA.EMPLOYEE XXX LEFT OUTER JOIN CORPDATA.DEPARTMENT YYY<br />
ON XXX.WORKDEPT = YYY.DEPTNO then resulted record is filtered to LEFT OUTER JOIN CORPDATA.PROJECT ZZZ ON XXX.EMPNO = ZZZ.RESPEMP and then finally record is filtered according to where clause
|
|
|
|
|
Display the estimated query plan for the query in Enterprise Manager.
Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
If you don't ask questions the answers won't stand in your way.
Most of this sig is for Google, not ego.
|
|
|
|
|
With the information given nobody knows. The only way to find out is to run it and show the execution plan. It all depends on data volumes, indices etc etc.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
hello everybody in this forum , i would like to ask about something .
i would like to use .net Remoting from sql server , that means i need sql server to notify a windows service about some transactions that occur in the db like insertion , update or deletion . i tried to develop a managed trigger via C# but when i refer to system.runtime.remoting.channels.http in the solution , it doesn't show me all available namespaces in the solution like any other .net solutions , so is there a way to let the sql server notify the windows service about some changes , thank you
Human knowledge belongs to the world.
|
|
|
|
|
Take at look at notification services[^]. I think it will do what you require.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
hi all,
I want to fill multicolumn listbox from an recordset. How is this possible? Without using Getstring() of Recordset.
please suggest me another way.
Regards.
modified on Monday, February 9, 2009 7:06 AM
|
|
|
|
|
|
In a join which table is said Left, which one right?
It depends on List in select or order in On or ...
Best wishes
|
|
|
|
|
table1 left join table2 on table1.id=table2.id
here table1 is left table whereas table2 is right. Query return all record from table1 plus matches record from table2
table1 right join table2 on table1.id=table2.id
here table1 is left table whereas table2 is right. Query return all record from table2 plus matches record from table1
hope this clear your confusion
|
|
|
|
|
The left one is the one on the left of the join and the right one is the one on the right of the join.
That is in Left-to-Right text. I cant imagine how messed up queries would look in Hebrew (RtL)
|
|
|
|
|
See the following example:
Select table1.*, table2.*
From table1
join table2 on table1.Id = table2.Id
In the above example table1 is considered left and table2 is considered right.
|
|
|
|
|
Dear All,
I need to reduce the log file size...
I've created a maintenance plan for shrinking the DB in my local machine, I've created every thing ok and scheduled it to work daily. and when I right click and then execute, the dialog displays successful process, but when I check the DB Log, it still huge size (about 20 Gb). I do not know why the log file size still huge after shrinking the DB.
Any help, plz???
Kind Regards
OBarahmeh
|
|
|
|
|
Did you try gogole search?[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Ok, I've found the solution:
USE yourDB;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE yourDB
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (yourDB_Log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE yourDB
SET RECOVERY FULL;
GO
Kind Regards
OBarahmeh
|
|
|
|
|
Hi Guys
I have a query that I am using to build a report in SRS 2005. The query sorts records by Customer ASC. When I view the query in SRS 2005 it is still sorted correctly. I have a group by Customer in the report. If I view the Report, my records comes back totally out of order. I also tried to force a sort by using the group properties and setting the sorting to customer, but still no luck.
Can someone please tell me how I will be able to get this records sorted properly? I will really be greatfull for your help.
Kind Regards,
Elizma
|
|
|
|
|
Can you put query or any example
|
|
|
|
|
Hi,
Thanks for the willingness to help. I dont know what the problem was, but I deleted the report table, recreated it and then it worked fine.
Elizma
|
|
|
|
|
|
Hi mates , i am a new joinee...need guidance .....it's a SOS...
These days i am busy implementing Data Mining/Data Warehousing issues for clients.I am facing a critical issue regarding Ab Initio.
I need guidance regarding it's licensing issues and comparitive analysis with other ETL products...
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
