|
For example,
SELECT * FROM sub_query
Can the sub_query contain a CTE?
I want to optimize sub_query by not changing anything outside sub_query.
Thanks.
professional
|
|
|
|
|
Well, quicker than posting in a forum and waiting for a reply, why not try it and see?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I've tried a lot  , but I find no way.
professional
|
|
|
|
|
Well, I would guess not as the WITH part of a CTE has to be the first statement in your sql.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi,
I am going to desing a appicaion with is based on sending / recieveing sms, (Java and MySql),
The question is, wheather to handle sending / recieveing sms module in Java or MySql, pls advice some good
source/tools for creating technical desing for this type of applications.
Thanks Very much
|
|
|
|
|
hi all ,i have 2 windows applications in c# connected with sql2005 database at the same time .these 2 windows applications insert a data in the database .i want that when one of these applications insert a row in database ,sqlserver2005 send a message or anything to the other application to inform it that a new row is inserted .it means that sql2005 send message to application.how i can do this?
Essampro 
|
|
|
|
|
Look at sql server broker notification, that should do it.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
think first in a LOCK protection (if you don´t have one).
i don´t know really how can i help you but, i suggest you to run/trigger a procedure to show the changed data since you logged out(meaning this user), i think is more important that the "on time update" info.
you can also create a log table, will be lot of aid there, to get who changed what and when!!!
do you need that kind of on time info, something like stock market info?
listen, you can make that on time info, or you can trigger a procedure after a short period of time, say 5min.
if i was you i would create a procedure to get the changed data since my last login/out and a procedure to get that on time info triggered each 5 min or like you said.
good luck 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
You don't need to do all this, with SQL Server 2005 there is a thing called Broker Service Notification which does it for you - well almost - you do have to write a bit of code yourself 
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Broker Service Notification? what the f*** is that? 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
It was introduced in SQL Server 2005. Here is a link to the definitive book [^]
and here is a link to the msdn details [^]
nelsonpaixao wrote: Broker Service Notification? what the f*** is that
As I frequently tell posters, try Google!
Bob
Ashfield Consultants Ltd
|
|
|
|
|
thanks, i will see what that for and if is usefull for me 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
what is the difference between ado.net and ado.net db
What is the difference between trigger and Stored Procedure
modified on Sunday, September 21, 2008 2:15 PM
|
|
|
|
|
Try googling. You'll find plenty of explanation there.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
arunmca.r wrote: what is the difference between ado.net and ado.net db
What is the difference between trigger and Stored Procedure
And why should anyone else do your homework?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi guys
I want to know how to display a picture stored in an attachment field in an Access 2007 database in a Visual C# picture box or more generally exporting a file from an attachment field in access 2007, I searched a lot but couldn't find, Please help.
Thanks.
|
|
|
|
|
Don't cross post.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I need a solution.
Assmbler
|
|
|
|
|
Cross posting to demand a solution from people isn't the ideal approach, either. Now, that aside, what have you tried doing with your problem so far? What is the field type you are using in Access to store the attachments? Are the attachments of one type, or is it various types of file formats?
People will need a little more detail if you expect any real help.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
The field type is Access2007 Attachment data type,the files stored in those fields are 90% jpg images plus some png and bmp images, When I try to get the contents of the field in c# it only returns their file name, I'm sure that there must be a way to get files from db. VBA has LoadFromFile and SaveToFile functions for working with attachments, but We need the equvalent ADO functions.
Assmbler
|
|
|
|
|
Could you show code example why you are just getting the filename in return?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Thanks for the reply.
strCmd = "SELECT FLAG FROM SongsFlagsContinents WHERE SECT='" + CountryName + "'";
cmd = new OleDbCommand(strCmd, Main.Connection);
cmd.Connection.Open();
rdr = cmd.ExecuteReader();
rdr.Read();
MessageBox.Show(rdr["FLAG"].ToString());
cmd.Connection.Close();
where FLAG column is an attachment column with image(s) attached.
|
|
|
|
|
Hi!
I am experiencing the following error and I couldn't find a solution. UserType field doesn't allow null values in the table as it has defined so. Before I INSERT the value for the field I get 1 as a value ofor the USERTYPE field. The data types are identical in both table and in the stored procedure.
I am using VS2008 and with SQLEXPRESS 2008.
However It pops up the following error message. If you know the solution, please let me know.
<br />
<br />
Cannot insert the value NULL into column 'UserType', table 'HolidayDB.dbo.Administration'; column does not allow nulls. INSERT fails. The statement has been terminated.<br />
<br />
'USER TYPE DEFINITION IS AS BELOW<br />
<br />
SetUserType = New SqlParameter()<br />
SetUserType.ParameterName = "@GetUserType"<br />
SetUserType.SqlDbType = SqlDbType.BigInt<br />
SetUserType.Size = 8<br />
SetUserType.IsNullable = False<br />
SetUserType.Direction = ParameterDirection.Input<br />
SetUserType.Value = CType(GetUserType.SelectedValue, Object)<br />
MYCOMMAND.Parameters.Add(SetUserType)<br />
<br />
<br />
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
Could you post the SP?
Intelligence is almost useless for those who have nothing else!
Email: caiokf@gmail.com
|
|
|
|
|
Thanks for responding. Here is my stored procedure but none of stored procedures are functioning in SQL server. I have no idea why. I am able to insert a data into tables by querying but when I try to invoke a stored procedure I always get an error message. For the following storedprocedure I get "@GetUserType is not supplied " error message even I supply the data.
Thank you.
ALTER PROCEDURE dbo.StoredProcedure3
(
@GetUserType bigint,
@GetAccountStatus bit,
@GetTitle nchar(10),
@GetFirstName nvarchar(50),
@GetMiddleInitial nchar(2),
@GetLastName nvarchar(50),
@GetEmailAddress nvarchar(125),
)
AS
INSERT INTO Customer
VALUES (
@GetUserType,
@GetAccountStatus,
@GetTitle,
@GetFirstName,
@GetMiddleInitial,
@GetLastName,
@GetEmailAddress,
EXEC StoredProcedure3
RETURN
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
