|
hi
you have to give the values for from date and todate
while @fromdate<=@todate
begin
insert into #Temp(fdate) values(@fromdate)
set @fromdate=dateadd(day,1,@fromdate)
end
Regards
Joe
|
|
|
|
|
Hi all ,
What's the most secure way for executing dynamic sql from a .Net App in your opinion?
Thanks in advance ,
|
|
|
|
|
A few quick tips:
* Use parameters as much as possible.
* Validate EVERYTHING.
* If you are needing to dynamically set the name of tables or columns then have your SQL check the existance of the table first (A lookup on INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS will help here - remember to use parameters to pass the table name)
* Validate EVERYTHING.
* Run the code in the most restrictive account possible.
* Validate EVERYTHING.* Call stored procedures and have the SP validate the parameters and generate the dynamic SQL.
* Validate EVERYTHING.
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
Hi,
I am in the process of transferring the data from MSSQl database to MYSQL  database.
I went through a code snippet which as in vb, in transferring the data (I mean content of tables).
I got this info from SQL DTS.com (Bulk Export Task) can any one here who did this sort of job earlier using C#?
I downloaded the required dll but wanna to have a code snippet in C#.
If any one knows please help me.
Thank you in advance
Raghavendran.![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
Raghavendran
|
|
|
|
|
recently i appeared for an exam... below question was asked:
You work as a database administrator.
You need to install a new SQL Server 2005 instance on a newly installed Windows
Server 20003 server named Server2. This new instance must have the same settings as the existing SQL Server 2005 instance on a server named Server1.
The only two services that need to be installed are the SQL Server service and the
SQL Server agent service.
The default installation folder should be used for the new SLQ Server instance on Server2. You will be able to refer to Server1 to view the settings to use.
You need to complete the installation wizard on Server2.
What operations do i need to perform....
(i dnt hv much experience on sql i am a beginner.)
Sailaja
|
|
|
|
|
potlakayala wrote: What operations do i need to perform....
(i dnt hv much experience on sql i am a beginner.)
Then why were you sitting an exam in that area?
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
can any body helps me to know the error meaning of address524F4241
thanks
mahen
|
|
|
|
|
Can you be more specific on what you are trying to do and when is that error popping up?
Once you have mastered the ability to turn yourself invisible at will, and to deflect bullets with your hair, you will be ready to come back here to the lounge and post programming questions.Only at this point will you be able to dodge the fireballs that are going to come your way. - Pete O'Hanlon
|
|
|
|
|
am using DELPHI WITH oracle back end..
when i open one form.. and trying to open another form with out closing the previous one.. this error pops up..
...
will tell u in brief..
i asigned F3.. to pop up.. company selection screen..
say i had opened one company.(HR)SCREEN. and AND WITHOUT closing the main form am pressing F3 and the company selection pop screen comes up. and selecting one more company.. and that time this error pops up..
but i had writen the code.. as close previous company screen and open new..
but not closing the main menu..screen..
hope u got some idea
thanks
mahen
|
|
|
|
|
How to display starting character only capital.
21 Nov, 2007
Author: Thirumurugan.D
hi friends,
am using one table,there is 3 field(name,address,father name) is having.but inserted totally 5 records.In all column data first character small letter.
example :(Database)
Name Address Father Name
raja salem rajasekar
laxman chennai anbuselvan
bala bangalore muthu
senthil covai durai
arun hosur ganesh
Note :
Am using front end repeater control.I want display all column data starting letter in capital letter.help me very urgent
I want display the front end form is example :
(FRONT END):
=============
Name Address Father Name
Raja Salem Rajasekar
Laxman Chennai Anbuselvan
Bala Bangalore Muthu
Senthil Covai Durai
Arun Hosur Ganesh
with Regards,
D.Thirumurugan.
|
|
|
|
|
First of all, don't cross post.
Secondly, you asked the same question a few days ago and were given some advice. Why are you asking the same question again?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
pmarfleet wrote: Why are you asking the same question again?
He probably figures he might get a better answer.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Hi,
I need to add indexes to some tables id like to understand when the indexes will actually be used...
lets say my table has four fields - field1, field2, field3, field4
if i add the following index (field1, field2, field3)
would the following where clauses use this index?
where field1 = a
where field3 = a
where field1 = a and field2 = b
where field2 = a and field3 = b
where field1 = a and field3 = b
where field1 = a and field4 = b
where field4 = a and field1 = b
then if i add a seperate index (field4)
would the following where clauses use one, both or non of these indexes?
where field1 = a and field4 = b
where field4 = a and field1 = b
where field3 = a and field4 = b
Thanks in advance...
Chas
|
|
|
|
|
The best way to know is to try it, make the tables, fill them with data, execute queries showing the execution plan. In the execution plan, SQL Server will tell you what indexes were used.
In general, If you have composite keys,indexes the 1st column in the index must be referenced in the query (specifically in the where or join) for sql server to consider using this index.
about you samples:
based on the above mentioned information and some experience I have with this, these can be the expected behavior of SQL Server:
where field1 = a (Index Will be used)
where field3 = a (Index Will not be used)
where field1 = a and field2 = b (Index Will be used)
where field2 = a and field3 = b (Index Will not be used)
where field1 = a and field3 = b (Index Will be used)
where field1 = a and field4 = b (Index Will be used)
where field4 = a and field1 = b (Index Will be used, sql server is smart enough  )
After adding index on Field4:
where field1 = a and field4 = b (one of the two indexes will be used, not both)
where field4 = a and field1 = b (one of the two indexes will be used, not both)
where field3 = a and field4 = b (index on field4 will be used)
note that whether SQL Server will use the index or not depends on many factors, for example statistics and granularity on index data.
|
|
|
|
|
Hi,
I have one method in the Data Access Layer like the below:
LoadPersonsData()
{
IDataReader reader= db.ExecuteReader("Procedure name");
Now here I need to call another private metho which will load part of data.
PersonData d = new PersonData();
While(reader.read())
{
D.name =reader["fname"];
…
D.Subdata = LoadSubdata(d, reader);
D.DOB = reader["dob"];
}
D.Subdata = LoadSubdata(d, reader); -- This line is also not getting the result
D.DOB = reader["dob"]; -> The problem here is after loadSubData is called next I am trying to get the next field from reader, Here I am getting
No data exist for the row or column.
How to pass the datareader to LoadSubdata method. I just created the sub method to reduce the complexity complained by the DevPartner tool.
Thanks
|
|
|
|
|
The DataReader uses the connection exclusively and this may be your problem.
|
|
|
|
|
In Reader.read() u r selecting a specific row and then u r sending whole reader it wont work, I think u should do it same function instead of calling another one...
|
|
|
|
|
Prateek G wrote: then u r sending whole reader it wont work
Why shouldn't it work?
Prateek G wrote: I think u should do it same function instead of calling another one...
Uugh! That way misery lies.
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
In case I am reading Nth row reader must be having all the rows, How he will be able to select that particular row at that time.....
|
|
|
|
|
Prateek G wrote: In case I am reading Nth row reader must be having all the rows
The reader disgorges one row at a time. If you pass a reader to a method it will be on what ever row that it was at when it was passed. The reader doesn't reset when it is passed around.
Prateek G wrote: How he will be able to select that particular row at that time.....
He most likely doesn't need to. He will be on the row he wants to read.
You are making an awful lot of assumptions about what the OP is doing. The code he supplied is not valid and his description has many holes.
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
Well, there may be something that is obviously wrong if you posted the ACTUAL code. The code you have posted contains several inconsistencies. You create a variable d and then appear to refer to it as D later on - these are separate variables and the code will not compile.
Also, the problem is in LoadSubData, but you have not shown us what LoadSubData does.
Please post the ACTUAL code if you want a chance to get a reasonable answer rather than blind guesses.
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
Can u paste the code of LoadSubdata(d, reader) function..
Are u using While(Reader.read()) method inside that function..
|
|
|
|
|
If you have a column of numeric data, then have a cell with the value result of #VALUE! and then more cells in the column with the result of numbers, how do you add the numbers together without the total result having the #VALUE! result? I tried it with the AUTOSUM feature, but that function only reads the cells from the bottom up to the #VALUE! result. I tried extending the cell range for the AUTOSUM feature, but #VALUE! is still the total result. I changed the #VALUE! field to a text amount with the AUTOSUM extended to the top of the numbers in the column, and it ignores the alphanumeric field. It only does not work when one of the fields has the #VALUE! result. What is the solution?
|
|
|
|
|
Hi, I need a little help with "" signs in my code i know the + need to be treated specially but i am newbie.
sSQL += "UPDATE Queue SET Active='False' WHERE Unit = ' + dlUnit.Value' AND Status = 'Queued'";
thanks
|
|
|
|
|
s3rro wrote: Hi, I need a little help with "" signs in my code i know the + need to be treated specially but i am newbie
Use parameters rather than attempt to inject values into a SQL string. If you inject stuff then you are setting yourself up for a SQL Injection Attack.
To pre-empt the question: Some people at this point like to tell me that they are just learning and are not concerned about that at the moment. My response to that is that if you never learn how to do it wrong you will always do it right.
Please read SQL Injection Attacks and Tips on How to Prevent Them[^]
By following the advice in the above article you will also solve your current problem.
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
