|
You don't need to install sql server 2000 instance on each and every system.
just install it on one system in the lan or workgroup
and in your query string give the name of that system
for example i had installed the sql on "test" system so the query string will be
"Server=test;Database=your_db_name;uid=sa;"
if u have a password for sa account then also include it.
|
|
|
|
|
Hi i am using one procedure to get a month all dates...,
But each and every dates creating separate,separate column name...,
But i want display those all dates under come in same column name...,
Means:
when i execute my procedure i am getting o/p like:
Startdate
2007-06-01
Startdate
2007-06-02
startdate
2007-06-03
.
.
.
startdate
2007-06-30
But i want following format:
Startdate
2007-06-01
2007-06-02
.
.
.
2007-06-30
This is the procedure:
DECLARE @startDate datetime
declare @nextdate datetime
DECLARE @endDate datetime
SET @startDate = CAST( CAST( 2007 AS varchar(4) ) + '0101' AS datetime )
SET @startDate = DATEADD( m, 6 - 1, @startDate )
set @enddate=dateadd(m,1,@startdate)
set @enddate=dateadd(d,-1,@enddate)
select @startdate as startdate
while @startdate < @enddate
begin
SET @nextdate = DATEADD( d, 0, @startdate )
set @startdate=dateadd(d,1,@nextdate)
select @startdate as startdate
end
Advance Thanks,
Regards,
Magi
|
|
|
|
|
Please - don't repost variants of the same question. You've been given all the information you need to have a go at answering this yourself. See my answer from earlier today as a basis.
|
|
|
|
|
Ya i didnt see that...,
Anyway thanks for ur post...,
Keep in touch
Regards,
Magi
|
|
|
|
|
|
How can i export or import tables and objects from one database to another in Microsoft SQL Server Management Studio Express 2005.
Best Regards,
M. J. Jaya Chitra
|
|
|
|
|
Hi
Right click on the database ... click Tasks -> Emport / Import Data.
For more information, check this link
Exporting and Importing[^]
Harini
|
|
|
|
|
I am a beginner here for ASP.NET. I can't manage to insert data using ASP.NET. I have successful using the same connection string to do SELECT statement,but I'm wondering how to do INSERT statement to MySQL database. Please give me some solution here.
This is my code:
Imports System.Data.Odbc
Dim strConnString As String = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;option=3;Database=MyDatabase;Uid=root;Pwd=Pass;"
Dim ObjConn As New OdbcConnection(strConnString)
Dim ObjRead As OdbcDataReader
Dim ObjComm As OdbcCommand
Try
ObjComm = New OdbcCommand("INSERT INTO member_1(Member_ID,Username,Gender,Email,Contact_No,Address,Password)VALUES('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "'", ObjConn)
If (TextBox1.Text = "" Or TextBox2.Text = "" Or TextBox3.Text = "" Or TextBox4.Text = "" Or TextBox5.Text = "" Or TextBox6.Text = "" Or TextBox7.Text = "") Then
Else
ObjConn.Open()
ObjComm.ExecuteNonQuery()
ObjConn.Close()
End If
Catch ex As Exception
Console.WriteLine(e.ToString())
End Try
Anyone can give me some solution here?
Thank you for readings.
Regards
Drex
|
|
|
|
|
Print your query on page. Copy that and paste in mysql query analyzer. That will give you the error
|
|
|
|
|
Thank you so much. I found my problem now. Its the Query Error. Thanks for your solution.
Regards
Drex
|
|
|
|
|
Hello,
I am using a datagridview and have bound it to a bindingsource.
In the datagridview i have a combo box column which gives the user a choice of either, ordered, pending, delivered.
However, In this specific grid I just want to display the pending orders. But if I click on the status and select delivered, I want the grid to display "delivered", Until I click save. However, what is happening then I click on the combo box and select delivered it will automatically refresh and not display delivered, only the pending orders. The customer would like to see all the orders that have had their status changed before saving and then displaying all the pending orders again.
The binding source is filtered to display only the orders pending when I select an order from the combo box.
My idea is to select an order from the combox box and display all the pending orders for that order number. The user can then select the status to delivered, if they want to. Then click save to save the changes. The save works fine. But the delivered row will disappear when the combo box loses focus.
Private Sub cboOrdersPending_SelectionChangeCommitted(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboOrdersPending.SelectionChangeCommitted<br />
Try<br />
Me.bsOrderDetails.Filter = String.Format("OrderID = '{0}' AND Status = '{1}'", Me.cboOrdersPending.SelectedValue, "Pending")<br />
Me.dgvPendingOrders.DataSource = Me.bsPendingOrders<br />
<br />
Catch ex As Exception<br />
MsgBox(ex.Message)<br />
End Try<br />
End Sub
The code for filling the binding source is as follows:
'Fill all pending orders - these are orders that have been ordered but have not bee delivered<br />
Private Sub FillPendingOrders()<br />
Try<br />
Me.TA_OrderDetails_dsCodeRed1.Fill(Me.DsAddComponetAndEquipment.OrderDetails)<br />
Me.bsPendingOrders.Filter = String.Format("Status = '{0}'", "Pending")<br />
<br />
Me.dgvPendingOrders.AutoGenerateColumns = False<br />
Me.dgvPendingOrders.DataSource = Me.bsPendingOrders<br />
<br />
'Me.HidePendingOrdersColumn()<br />
Catch ex As Exception<br />
MsgBox(ex.Message)<br />
End Try<br />
End Sub
Can someone please tell me if i have done something wrong with my code and explanation.
Many thanks for any help,
Steve
|
|
|
|
|
Hi,
I am trying to get results where the parameter that is passed is a date. I am only passing the date itself and not the time although the field in the datebase holds both. How can I retreve date specific results and ignore the time.
I currently have
<br />
WHERE E.Start = @Date
But it seems to be passing @Date with the time 00:00:00 at the end which obviously makes the wrong, if any, results comeback.
Any ideas appreciated. Thanks
|
|
|
|
|
SQL Server does not have a data type which only holds date information, only ones which hold date and time information.
In practice if you want any time on a specific day you have to say:
WHERE E.Start >= @Date AND E.Start < DATEADD( d, 1, @Date )
|
|
|
|
|
Yeah I was stupid enough to post without looking three post down where the answer was already written. I came up with something pretty much like you suggested
<br />
DECLARE @FromDate datetime<br />
DECLARE @ToDate datetime<br />
<br />
SET @FromDate = (CAST(@Date AS datetime ))<br />
SET @ToDate = DATEADD( D, 1, (DATEADD(mi, -1, @FromDate )) )<br />
<br />
SELECT E.ID As EventID,<br />
ET.ID As TypeID,<br />
E.Title As EventTitle,<br />
V.ID As VenueID,<br />
V.[Name] As VenueName,<br />
E.Description As EventDescription,<br />
E.Start As EventStart,<br />
E.Finish As EventFinish<br />
FROM Events E<br />
INNER JOIN Venues V<br />
ON E.VenueID = V.ID<br />
INNER JOIN EventTypes ET<br />
ON E.TypeID = ET.ID<br />
WHERE E.Start >= @FromDate<br />
AND E.Start <= @ToDate<br />
AND V.CityID = @CityID
Thanks anyways
|
|
|
|
|
You have two options of rephrasing your WHERE clause. Each solution assumes that both @Date and E.Start are declard as DATETIME:
(1) WHERE E.Start BETWEEN @Date AND DATEADD(d, 1, @Date)
This will look for E.Start values between midnight on @Date and midnight on @Date + 1 day
(2)
WHERE DAY(E.Start) = DAY(@Date) <br />
AND MONTH(E.Start) = MONTH(@Date) <br />
AND YEAR(E.Start) = YEAR(@Date)
This will explicitly compare the month, day, and year components of each field and only flag those where all three are the same.
|
|
|
|
|
hi ...
see the next Sql statment
" Select * from TableN where Dept='Human Resources' "
this statment has no error but if I use one quotation for eg , Dept='Human's Resources' .. it's make error
jooooo
|
|
|
|
|
Putting in the second quotation mark ends the parameter. Therfore you are passing in "Human" and the rest "s Resources" is sat outside of this which is wrong. You would need to do
Dept= ('Humans' + '''' + 's Resources')
If this parameter was passed in via a stored procedure then this would not matter as the parameter is seen as a single object and the quotation mark won't be seen as syntax
|
|
|
|
|
at first thanks ,,
the probles is you have an interface and you like to make query of an entry value, that value is string .. then you will make :
select * from table where Dept='" + Text1.text + "'"
that's good ..
but if the user enter any string contain single quotation : Human's Resouces .... then an error will happen..
jooooo
|
|
|
|
|
Ok originally I thought you were just writing the SQl as that but i see the problem you are encountering. There are a number of ways around this. The first would be to add code that reads the Text1.Text entry letter by letter and appends quotation marks around an quotation marks it finds. This will do the trick but you should be more aware that this method will not protect from you SQL injection attacks.
An attack of this kind would be for the user to simply write SQL code in your text box so that it too was run when you fire the statement at the SQL server. If the user had enough information they could potentially delete tables and hense your information. Not good.
The best way to get around this would be to use Stored Procedures. Stored procedures pass parameters as they come and cannot be mistaken by SQL as additional SQl code. I suggest you look this up as how you actually set them up would vary depending on your choice of platform but they do provide a much more secure solution. They really don't take that much more time to do and also make your code look alot simpler.
|
|
|
|
|
Now it's OK ..
I used Stored Procedure ..
really thanks my friend ..
jooooo
|
|
|
|
|
|
kindman_nb wrote: I used Stored Procedure ..
Or you can go with parameterized queries
|
|
|
|
|
Dear All,
I am using sql2005.
i am writing stored procedure to save various master data . I recognize master by @type (input verible) and assign it to @mst veriable then based on @mst no I perform saving task . I created sp . now I am trying to execute then I am getting error
“Invalid object name 'SizeMst'. “ I am running this query from its database.
Stored perocedure is
Alter procedure [dbo].[Sp_RestMst_Save]
@type int ,
@id varchar(20),
@shortdesp varchar(50),
@longdesp varchar(100),
@userid varchar(50),
@ipadd varchar(50)
as
declare @mst int
set @mst = @type
if ( @mst = 1)
begin ;
-- saving data in sizemst
update SizeMst set sshortdesp = @shortdesp , sdesp = @longdesp,smodifiedby = @userid , smodifieddt = getdate() ,ipadd = @ipadd where sizeid = @id;
if(@@rowcount = 0)
insert into SizeMst(sizeid,sshortdesp,sdesp,screatedby,screateddt,ipadd) values(@id,@shortdesp,@longdesp,@userid, getdate(),@ipadd);
end ;
else
if(@mst = 2)
begin ;
-- saving data in brandMst
update BrandMst set bshortdesp = @shortdesp ,bdesp = @longdesp, bmodifiedby = @userid , bmodifieddt = getdate() ,ipadd = @ipadd where brandid = @id;
if(@@rowcount = 0)
insert into brandMst(brandid,bshortdesp,bdesp,bcreatedby,bcreateddt,ipadd) values(@id,@shortdesp,@longdesp,@userid, getdate(),@ipadd);
end ;
else
if(@mst = 3)
begin ;
-- saving data in metalktmst
update MetalKtMst set mshortdesp = @shortdesp ,mdesp = @longdesp, mmodifiedby = @userid , mmodifieddt = getdate() ,ipadd = @ipadd where metalktid = @id;
if(@@rowcount = 0)
insert into MetalKtMst(metalktid,mshortdesp,mdesp,mcreatedby,mcreateddt,ipadd) values(@id,@shortdesp,@longdesp,@userid, getdate(),@ipadd);
end ;
Please guide me in doing so or give me some useful link.
Thanks
regards
imran khan
|
|
|
|
|
I am passing the month value and year value only...,
With that how to display that month all dates?,
Example:
If pass month value=6 and year value =2007
Then it want to show,
'06/01/2007' to '06/30/2007'
Like that i need query...,
Hlp me...,
Regards,
Magi
|
|
|
|
|
Constructing a date is actually pretty tricky in SQL Server. It's easiest to start from 1 January of the desired year, using a string literal:
DECLARE @startDate datetime
DECLARE @endDate datetime
-- note use of ISO8601 yyyyMMdd format - unambiguous
SET @startDate = CAST( CAST( @year AS varchar(4) ) + '0101' AS datetime ) Then you can add the month information:
-- Month is 1-based but we don't want to add anything for January
-- so we subtract 1 from the supplied month number
SET @startDate = DATEADD( m, @month - 1, @startDate ) In the results, we want anything up to 30 June 2007 23:59:59, so I set the end date to be the start date plus one month and then select values greater than or equal to the start date, and less than the end date.
SET @endDate = DATEADD( m, 1, @startDate ) If you really want the last day of the month, you can subtract one day with DATEADD( d, -1, @endDate ).
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
