|
span98 wrote: My date format in MS SQL is DD/MM/YYYY hh:mm:ss
SQL Server does not have a date format. It may display dates in a specific format and T-SQL may interpret strings in a particular format if required but SQL Server itself, internally, does not have a date format.
Your request suggests that you are not using parameterised queries. You should learn to use parameters because they will not care about date formatting so long as you tell it that a parameter is a date and you use a DateTime object in .NET. Also, parameterised queries will reduce the chances of being vulnerable to a SQL Injection Attack.
|
|
|
|
|
Can you explain the parameterised query for me? I am requesting certain data from within a table and wanting the results between 2 certain dates. So my query looks something like this:
select top (1) count([destination telephone no]), [destination telephone no]
from calls
where (Name LIKE '%' + @name + '%') AND ([DateTime] >= @start) AND ([DateTime] <= @end)
group by [Destination Telephone No]
order by count([destination telephone no])
So I am requesting the info for that specific time period. @start and @end being my controls on my .aspx side
|
|
|
|
|
@name, @start and @end are all parameters, so you are already using a parameterised query - So, I can only assume that @start and @end are the wrong datatypes otherwise you should not be getting the problem you are getting.
@start and @end should be DateTime objects on the .NET side and SMALLDATETIME or DATETIME objects on the SQL side.
|
|
|
|
|
My SQL table where the data is, has the field type DateTime. My PC language is set to UK which puts it in the format DD/MM/YYYY.
Also I have set my SQL language to British English...
"@start and @end should be DateTime objects on the .NET side and SMALLDATETIME or DATETIME objects on the SQL side. "
How do I change it on my .NET side? That might help if I can change the way the .NET is reading my date format from SQL
|
|
|
|
|
span98 wrote: How do I change it on my .NET side?
What is your existing code?
span98 wrote: That might help if I can change the way the .NET is reading my date format from SQL
The code you showed me earlier does not indicate that the .NET side is reading any dates. It is passing dates to SQL Server (i.e. it is writing dates)
|
|
|
|
|
That code from above takes the dates from 2 calenders on my .aspx page and requests that data from my SQL database within the constrains of those two dates.
That is how I have been doing it. I have those two dates setting the parameters of what my request needs to comply with. It then simply displays the data that is requested for that specific time period
|
|
|
|
|
span98 wrote: That code from above takes the dates from 2 calenders on my .aspx page
No, it doesn't. The code you've given already is SQL only. It takes nothing from any calendars. It may have received information that ultimately came from calendars, but not there.
I need to see .NET code. Describing it to me is not sufficient.
|
|
|
|
|
I'm not sure which code you are looking for.
I have bound my calender control to the terms @start and @end? That is the only code I can think of. The rest of my code is SQL. I've bound all my objects to DataSources on my .aspx and display them in dataViews etc. So I don't know where else I would have code as it does it all for you implicitly...
|
|
|
|
|
Don't know if it applies in SQL 2008, but in 2005 and earlier I always use this before my queries:
SET DateFormat dmy
as this tells SQL Server what format to expect dates in.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I'm a newbie to DB2 DBMS, so I wanna a front end client like mysqladmin to speed my process. Is there any?
Any advice would appreciate!
|
|
|
|
|
|
I don't use DB2, but I have used a package called TOAD for both SQL Server and Oracle - it is very useable, and there is a DB2 version.
The DB2 version is here (Freeware): http://www.toadsoft.com/toaddb2/index.html[^]
====================================
Transvestites - Roberts in Disguise!
====================================
|
|
|
|
|
pls i have a database with following structure
distributorID name mgrID date
where date is the day the person is register. the distributor is self jion on mgr
i need a query to be able per month get how many distributor are register under a given manager for the month.
the algorithm is like
if managerA register 2 people say B, C his level 1 increase by 2
if B register 3 people B say D,F, Glevel 1 increase by 3 and A level 2 increase by 3
if G register 1 person G level 1 increase by 1 and B level 2 increase by 1 and A level 3 increase by 1
any idea pls
|
|
|
|
|
Can you figure here how is your real data in table and figure result which you want to get from T-SQL statement.
Regards.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
I just installed SQL Server from the install disk that came with VS2008 Professional Edition (Academic).
I can't seem to find SSMS in Program Files.
I seem to remember from a previous installation in the past that SSMS is hard to find sometimes.
Am I just not looking for SSMS in the right place or does SSMS not come with the VS2008 Professional Edition (Academic)? The install CD tells me that SSMS is already installed on my computer....
|
|
|
|
|
Go to the MSDN or Technet SQL site and follow the links for the Express edition.
“If we are all in agreement on the decision - then I propose we postpone further discussion of this matter until our next meeting to give ourselves time to develop disagreement and perhaps gain some understanding of what the decision is all about.”-Alfred P. Sloan
|
|
|
|
|
Usually found in
install folder\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe
|
|
|
|
|
Hello,
I'm trying to set up PostgreSQL v8.3.3 as a bootstrap package with my VS2005 Setup project. Does anyone know of a url I can directly download the postgresql-8.3-int.msi file from? Everywhere I've found an installer, it's packaged in a zip file. I'd like to set my installer to download any prerequisites from the web as needed, rather than package the files directly with my installer. The size of the installer is an issue here (needs to be under 10 MB for emailing purposes).
Thanks,
Dybs
|
|
|
|
|
Hi.
I have developed a database application (Access database) in C#2005. I tested the application on XP and Vista. It worked fined until I tested it on a machine that has windows Vista ultimate (64-bit) and have .net framework 3.5, I got the following error:
************** Exception Text **************
System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0'
provider is not registered on the local machine.
How can I fix this problem?
Mohammed Emam
.NET Developer
|
|
|
|
|
Make sure you have MS Access installed or at minimum your have the runtime installed. AccessDBs are file based instead of sever based which can lead to your problem.
“If we are all in agreement on the decision - then I propose we postpone further discussion of this matter until our next meeting to give ourselves time to develop disagreement and perhaps gain some understanding of what the decision is all about.”-Alfred P. Sloan
|
|
|
|
|
hello
i am new in sql and i have create one small application with one table which has six columns
i want to check recores from sql database but it always shows nothing this is the code bellow in load event, all i want to do is if there is no data in sql database then it should shows "Empty Database" in Combo box
but it's not working
Private Sub LoadCboItems()
dcIMS = GetDBConnection()
cboDisp.Items.Clear()
If Me.BindingContext(dsIMS, "IMS").Count = 0 Then :confused:
cboDisp.Text = "Empty Database"
Exit Sub
Else
Dim MyReader As SqlDataReader = Nothing
Try
Dim MyData As New SqlCommand("SELECT * FROM IMS", dcIMS)
MyReader = MyData.ExecuteReader
Do While MyReader.Read
If rdoID.Checked Then
cboDisp.Items.Add(MyReader.Item("InkNumber").ToString)
cboDisp.SelectedIndex = 0
ElseIf rdoName.Checked Then
cboDisp.Items.Add(MyReader.Item("InkName").ToString)
cboDisp.SelectedIndex = 0
End If
Loop
Catch ex As Exception
MsgBox(ex.Message)
Finally
MyReader.Close()
dcIMS.Close()
dcIMS.Dispose()
End Try
End If
End Sub
|
|
|
|
|
bapu2889 wrote: dcIMS = GetDBConnection()
cboDisp.Items.Clear()
I hate binding questions, what is dcIMS declared as?
You are testing the count of the binding context, presumably tied to the form (me), is this what you want to test.
I use datatables and have no problem with the counting of rows nor binding to a combo box. Did i mention I hate binding widgets!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
dcIMS is sql data connection
cboDisp is combobox
and what i want to do is when i start application so first it checks if there is any data in data base is it's there then it's shows the list of inks but if it's empty then i want to display "Empty Database" in combo box
thanks for your rep.
have a nice day
|
|
|
|
|
And your code work properly or not? If no do you have any error message or where is problem with code?
Try to bind cboDisp with values from database then check items on cboDisp,if ItemCount of combobox is 0 then add string "Empty Database" otherwise add list of links.
Hope this will help you.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Wel, given that by line 3 all you have done is establish a database connection, what can you epect your If... statement to return?
Try something more along these lines
Dim MyData As New SqlCommand("SELECT * FROM IMS", dcIMS
MyReader = MyData.ExecuteReader
If MyReader.HasRows Then
Do While MyReader.Read
' ...whatever
Loop
Else
cboDisp.Text = "Empty Database"
End If
MyReader.Close()
dcIMS.Close()
As an aside, you should not, as a rule, leave Closing your database connection to the Finally clause of a Try block - what happens if an error occurs outside that? Instead, open your Db connections at the last moment possible, and close them immediately after, and test for an open connection in Catch part - eg:
Dim dbConn As New SqlConnection
...
Try
..some code
dbConn.Open
.. data amnipulation
dbConn.Close
..more code
Catch
If dbConn.State = ConnectionState.Open Then dbConn.Close()
...
End Try
...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
