|
SELECT pag_id, 3 + 5 AS expr1, CASE WHEN isnull(expr1 + , 0) <> 0 THEN pag_expire ELSE 10 END AS expr2
FROM dbo.cms_page_loc
query a valid one on sql server , its work
fine in MS access.
please ignore the logic of the query, i just want to know how to validate
an evaluated expansion i.e(expr1)
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
expr1 does not exist yet. It is part of the metadata of the result set. To evaluate it in the following column definition you need to either repeat the expression that created expr1 or to evaluate it in a subquery so that it is passed up to the main query.
|
|
|
|
|
Dear All,
This is related to IList concept in .net 2.0,
I have Ilist property i.e CourseOptions,
There one storedProcedure That return result like this
ID VALue Text
1 Averages YES
2 Honor Rolls NO
4 Marking Period Totals YES
8 Class Ranks NO
16 Transcripts YES
32 PRC YES
64 Attendance NO
128 Print On Schedule NO
256 Print On Matrix NO
512 Offered Course NO
1024 Nat'l. Hon. Soc. NO
2048 No Marks NO
8192 Junior Hon. Soc. NO
I Want to get all the values of Text column.
These columns i need to bound to IList of CourseOptions I can doit
Pls help me in this
Thanks N Advance
|
|
|
|
|
shakeela wrote: please help me in this very urgent
I offer help. I don't priorities because someone said their problem is urgent. To each of us our own problems are always the most urgent. If your problem is truely urgent them I'm sure you wouldn't mind paying for a support call. However, you are here, so it obviously isn't that urgent.
You will also have to make your request clearer. I don't really understand what you want to do. Are you looking for SQL code or are you looking for how to get the data in the .NET application? Or do you already have the data in the .NET application and need to coerce it into an object that implements IList?
|
|
|
|
|
Hello,
After filling a DataTable with the DataAdapter i get no information regarding which column is the unique key one.
Basically it sets all of the column to false on the unique property of the column even if it's not so on the DataBase.
Also i go through hell to retrieve the Sql Data type of the column in the DataTable.
Anyone has an answer to that?
thanks,
Leo
|
|
|
|
|
You dont know how to do it?
all of us here allready knows.
|
|
|
|
|
Hi guys, I've got this problem, hope someone can help me out.
I've written and application and it works fine on my computer and i can connect to SQL through a Text file
connection string in the Text box : Data Source= NameOfMyDataSource;Initial Catalog= DataBaseName ;Integrated Security=True
As I said, it works fine on my computer but NOT on other computers !!!
I installed my application on another computer and also installed SQL server, then attached my database and it works fine, but when i run my progran and enter ID and Pass get this error !
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
A friend from here suggested:
By default, SQL Server blocks remote access. To get round this, log into SQL Server Configuration Manager and make sure that you have enabled Named Pipes. Then, go into the Surface Area Configuration Tool and make sure it's set for Local and/or remote connections for Named Pipes. Now, restart the SQL Server instance.
I did that but still get the same error !!! what should I do ???
Thanx
|
|
|
|
|
I am guessing that your servername is incorrect. On the machine that it is not working on, try ping the server name. If you are using something like localhost that for sure would not work on remote systems. If you can't ping the sql server, then you might have a name resolution issue which would be solved with a DNS entry on your network.
Hope that helps.
Ben
|
|
|
|
|
Hey, how can I fix this resolution issue thing ???
Mr.K
|
|
|
|
|
Can you ping the ip address or sql server name?
Ben
|
|
|
|
|
It's not on a server, everything 's on a single computer !
so i don't think I can ping the IP !
Mr.K
|
|
|
|
|
If everything is on a single computer, you probably don't want to put in the ip address, but you still would need to put the sql server name. You should still be able to create an odbc connection to it and the test connection should work.
Ben
|
|
|
|
|
Check these two things, it might help:
1. Add SQL Server instance to the permitted list of applications in the firewall settings (Control Panel-> Security)
2. Check if port 1434 is not block using telnet <sql ip=""> 1434.
Regards,
Pratyush Shukla
ssssssssssss
|
|
|
|
|
One more thing to check - make sure that you are using the database instance name, if any.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi, How can I check my database instance name ???
Mr.K
|
|
|
|
|
Adding another issue, you may not be able to use Integrated Security (Windows Authentication) if the server and client are not members of the same domain. If they are not, the user running the client needs to have a Windows account on the server and the passwords need to be the same.
Also, your database server will need to grant the CONNECT privilege to the user or to a group that the user belongs to, and the login will need to be mapped to a user in the database you're trying to use, with appropriate rights for what you're trying to do.
|
|
|
|
|
The thing is this is all happening on one computer, I'm soot running it on a server then connect to it with clients. everything is on one computer !
|
|
|
|
|
Hi,
You should connect to SQL Server by SQL Server Authentication(User sa) and not Windows Authentication.
|
|
|
|
|
Hi i have a table of tests each of which has its own col but when displaying this test data it must be displayed down the table ie
Test Name Average Res Results
test 1 a res 1 res 1
tes 2 a res 2 res 2
so i am just lookin for some advice on how to go about altering the layout and specifically whether i shud try and do it with C# or SQL and help is appreciated
Thanks
Tim
|
|
|
|
|
Dear all,
I am trying sql server reporting service 2005.
I made one simple report through business intelligence project and deployed that project to report server.Now when i trying to export to pdf or excel or any option. it only get hanged, does not export.
I am currently not able to identify problem.
Please suggest some idea where i am going wrong
Thanks
regards
imran khan
|
|
|
|
|
Hi all,
Here am Using oracle10g database as backend in my application.
In my database there is some data table having Name Field.
For instance consider,There is a Name value called Bobby.
In Future,at the time of data insertion i wanna check whether the Name value(Here Bobby)already exists or not and that too it must b case insensitive.
Means it mustnt take bobby,boBBy,bobbY etc.
Programatically in c# am having awareness abt remaining part,but strucked at this Query part.
Here i tried with this Query but no clarity.
SELECT e.ID from Emp e , Empusers ue WHERE e.ID = ue.UID
AND e.employeename = :employeename
Pls Guide me,thanks in advance
Have a Nice Day Dudes
|
|
|
|
|
Try:
SELECT e.ID from Emp e
WHERE UPPER(e.employeename) = UPPER(:employeename) If that is too slow then Oracle allows you to specify a unique function-based index that uses "UPPER(EmployeeName)" instead of a column.
|
|
|
|
|
Thanks for the Reply,
Got the solution by using Lower(),as u said earlier.
Have a Nice Day Dudes
|
|
|
|
|
I'm using the Execute method of ADODB.Connection in VB 6 to execute an SQL delete statement. The rows from the table are deleted but I (sometimes) get a runtime error:
ADO Error #-2147352566
Description Out of present range.
Source Provider
A normal reason for this would be trying to insert a numerical value that is indeed out of range - but this is a deletion(!?). I can execute the SQL (cut and pasted from the VB) in PL/SQL Developer and get no error. It's as though the state of the connection or another component of the ADO is causing the failure . Initially thought that it was something to do with the number of strings in the SQL's IN statement (169 of them, all 9 chars matching against a VARCHAR2(9) in the table) but I have now tested up to the 1000 limit (after which I get the expected Oracle error).
I have Googled for:
ADO Error Out of present range
ADO Error -2147352566
ADO Error 0x8002000A
ADO Error 8002000A
and variations on this theme but have not found anything useful.
Have any of you guys encountered this before (where it's not for the obvious reason - out of range)? Any ideas?
|
|
|
|
|
Which database driver and connection string are you using?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
