|
 HI,
Do we have a tool to capture requests made to a Syabse Server, same like SQL Profiler.
Bala
|
|
|
|
|
Have you looked around at Sybase? I don't know much about Sybase, and I cannot really help you other than recommending looking at Sybase's resources.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
hi, what is the difference between SQL 2005 32bit and 64 bit and which one should i install
|
|
|
|
|
The 32-bit edition can only use up to 2GB of virtual address space on 32-bit editions of Windows (3GB if the OS is booted with the /3GB switch but it's not recommended), or 4GB on 64-bit editions of Windows. SQL Server supports the 'address windowing extensions' feature which allows more physical memory to be used, but it's not particularly efficient.
The 64-bit editions (there are separate editions for AMD/Intel 'x64' processors - all new Athlon 64, Opteron, Core 2 and Xeon processors are - and Intel Itanium processors) can use a huge virtual address space - 48 bits' worth.
In general, if you've got a 64-bit computer with the 64-bit OS, you should install the appropriate 64-bit version of SQL Server. If you have an Itanium system, you'd know about it and you wouldn't be asking the question!
|
|
|
|
|
Hi, after saving scripts for creating a mysql database table as a .SQL file, how do I execute it in mysql? Also in what folder must I put it? Thank you in advance for your help.
|
|
|
|
|
Executing SQL Statements from a Text File[^].
Please don't ask me questions on MySQL directly as I have no experience with the product. Post them here if you want, but we're generally more experienced in Microsoft SQL Server, so a MySQL forum (e.g. here[^]) might be able to help you better.
|
|
|
|
|
ASPnoob wrote: after saving scripts for creating a mysql database table as a .SQL file, how do I execute it in mysql?
You exectue it from the mysql command line or from a gui.
ASPnoob wrote: Also in what folder must I put it?
It doesn't matter, you spcify the location of the file.
Google is great for this sort of thing you know.[^]
|
|
|
|
|
Hi this is my probs...,
Its working in query analyzer...,
But its not working, when the values passing from asp.net to stored procedure...,
I am getting error like "Incorrect syntax near '/'...,
Sorry before msg i really confused lot...,
declare @appdate as smalldatetime
declare @noofdays as varchar(50)
declare @month as varchar(50)
declare @year as varchar(50)
set @appdate='8/1/2007'
Set @noofdays=Day(DateAdd(Month, 1, @appdate) - Day(DateAdd(Month, 1,@appdate)))
set @month =datepart(month,@appdate)
set @year=datepart(year,@appdate)
begin
SELECT EM.empId, TC.carddate,SD.Whrs,sd.edate,MHD.Appwhours as AppHours,MHD.AppOtHours as AppOtHours
FROM dbo.tblEmployeeMaster EM INNER JOIN dbo.tblTimeCardmain TC ON EM.empId = TC.empid
INNER JOIN dbo.tblSalaryDetails SD ON EM.empId = SD.EmpID
left outer join dbo.tblMonthHourdetails MHD ON TC.empid=MHD.empid and TC.Carddate=MHD.Sdate
inner join (select empid,max(edate) as edate from tblsalarydetails
where edate <= @month + '/' + @noofdays + '/' + @year group by empid) z on SD.empid=z.empid and SD.edate=z.edate
WHERE TC.carddate = @appdate AND TC.app1 = 1 AND TC.projectid = 104 order by EM.Empid
end
GO
Regards,
Magi
|
|
|
|
|
Why aren't you using a DATETIME type?
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
Hey there,
I've never liked databases and will probably never do so rather than trying to build my own database connection class I copied one written in VB.Net.
Dont know why but it does not work :-?
Here is the code:
[code]
Public Sub FindAndSelect(ByVal TheTableName As String, ByVal oFindValue As String, ByVal ColName As String, ByVal xColName As String, ByRef xValue As String)
Dim i As Integer
For i = 0 To MyDts.Tables(TheTableName).Rows.Count - 1
If MyDts.Tables(TheTableName).Rows(i).Item(ColName) = oFindValue Then
xValue = MyDts.Tables(TheTableName).Rows(i).Item(xColName)
Exit For
End If
Next
End Sub
[/code]
That looks this way after converting it (at least imho  )
[code]
public static void FindAndSelect(string tableName, string findValue, string colName, string xcolName, string xValue)
{
for(int i = 0; i < MyDts.Tables.Count; i++)
{
if(MyDts.Tables[tableName].Rows[i].Item[colName] = findValue)
{
DataRow row = new DataRow();
xValue = MyDts.Tables[tableName].Rows[i].Item[colName];
DataRowCollection col = new DataRowCollection();
break;
}
}
}
[/code]
But that causes a compiler error in the lines:
if(MyDts.Tables[tableName].Rows[i].Item[colName] = findValue)
&
xValue = MyDts.Tables[tableName].Rows[i].Item[colName];
saying that "System.Data.DataRow does not contain a definition for 'Item'".
I dont understand that since it works in VB.Net and according to the MSDN the DataRow class has a 'Item' member.
http://msdn2.microsoft.com/en-us/library/system.data.datarow_members(VS.71).aspx
Any ideas?
|
|
|
|
|
Drop the .Item and just refer to Rows[i][colName]. This is an indexer property so it doesn't need the Items.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
That works, thank you.
Still I dont understand why the .Item doesn't work.
|
|
|
|
|
The collection is called .Items and not .Item. In order to do this, you would have to do .Items[...].
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
c0rvus wrote: But that causes a compiler error in the lines:
if(MyDts.Tables[tableName].Rows[i].Item[colName] = findValue)
&
xValue = MyDts.Tables[tableName].Rows[i].Item[colName];
bolded code replace with Rows[i][colName]
all what to do is to remove .Item property
I Love SQL
|
|
|
|
|
Hi all,
How to communicate an AJAX and SQL. I want to pass values directly from AJAX to SQL, with out any server side script(like asp,php). Is it possible to do so? If there is an option plz send me the link or plz guide me.
Thanks in advance
Know is Drop, Unknown is Ocean
Know is Drop, Unknown is Ocean
|
|
|
|
|
You would presumably have to use the Classic ADO interface, but:
* There have been security issues in some ADO components (ADODB.Stream) which have led to them being blocked from loading in Internet Explorer;
* It is very unlikely, and very bad practice, for the SQL Server to be exposed to the internet.
|
|
|
|
|
declare @noofdays as varchar(5)
declare @month as varchar(5)
declare @year as varchar(5)
declare @appdate as smalldatetime
set @appdate=8/1/2007
Set @noofdays=Day(DateAdd(Month, 1, '@appdate') - Day(DateAdd(Month, 1,'@appdate')))
set @month =datepart(month,'@appdate')
set @year=datepart(year,'@appdate')
select @noofdays,@month,@year
Hi in this i am getting error like "Syntax error converting datetime from character string."
How to solve that ...,
Plz help me,
Advance thanks...,
Regards,
Magi
|
|
|
|
|
Hi Dear Remove quotation from all Variables
Like this or run this code.
declare @noofdays as varchar(5)
declare @month as varchar(5)
declare @year as varchar(5)
declare @appdate as smalldatetime
set @appdate=8/1/2007
Set @noofdays=Day(DateAdd(Month, 1, @appdate) - Day(DateAdd(Month, 1,@appdate)))
set @month =datepart(month,@appdate)
set @year=datepart(year,@appdate)
select @noofdays,@month,@year
Regard
Sohail
|
|
|
|
|
Hi Dear Remove quotation from all Variables
Like this or run this code.
declare @noofdays as varchar(5)
declare @month as varchar(5)
declare @year as varchar(5)
declare @appdate as smalldatetime
set @appdate=8/1/2007
Set @noofdays=Day(DateAdd(Month, 1, @appdate) - Day(DateAdd(Month, 1,@appdate)))
set @month =datepart(month,@appdate)
set @year=datepart(year,@appdate)
select @noofdays,@month,@year
Regard
Sohail
|
|
|
|
|
Hi plz check it,it wont work...,
Give some different date ...,
It will show the same values and see the year it will give 1900
Regards,
Magi
|
|
|
|
|
Dates to be enclosed with in single quotes
other wise they will be taken as 01/01/1900
Regards
KP
|
|
|
|
|
Solution given to you basing on the code what you have given.
Regards
KP
|
|
|
|
|
Very good.
request you please learn SQL before using not the other way.
your questions shows that you a fresher to SQL
Regards
KP
|
|
|
|
|
What do you expect? You've specified that put quotes around your @appdate entries turning them from variables into constants. Remove them.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Two errors in your code
1. only string constants to be enclosed in quotations. Not variables.
Remove quotations ( this is for Syntax Error)
2. Dates should be enclosed within quotation. (this is for logical error. other wise it takes as 01/01/1900)
Regards
KP
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
