|
If you have SQL 2005 you could also write a short user-defined aggregation function in C# that concats strings.
Regard,
Rainer.
Rainer Stropek
Visit my blog at http://www.cubido.at/rainers
|
|
|
|
|
hi i have a question about the possibility of joining 2 database tables that are on different servers in different countries, there are 2 tables that need to be stored in one location as the information changes and is updated everyday this location is seperate from the rest of the database tables that store specific company information and must be on the companies server.so i guess my question is can this be done and how to go about joining the tables
any ideas, advice as im new to development or help would be appreciated thanks in advance
Tim
|
|
|
|
|
|
How can I send data from MSSQL to HTML ? Suggestions Please.
|
|
|
|
|
|
Reply to me if solution is helpful to you.
In Sqlserver 2000
1. Goto the menu click "query" tab.
2. select "Results to file " option.
3. Execute the query F5.
4. It will prompt the window to save the file .Save the file as ".html" extension.
5. Your requirement is fullfilled.(note -->The result is not in order/linear in order).
vivek
|
|
|
|
|
Thank you Vivek for your answer but, I wanted it specifically configured in HTML format with HTML tags and sp_CreateWebTask can very well do that.
|
|
|
|
|
why " setcount on" is used in stored procedures ?
what does it actually means ?
vivek
|
|
|
|
|
used to display the "messages" return by running a sql statement. Experiment with it in Query Analyzer to see what it does to a basic SQL statement.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
Hi,
I hope that there is no option such as setcount on in sql, Instead we have a statement set nocount on/Off
The explanation is given below which is available in SQL books online please refer the same for further explanation
<definition from="" books="" online="">
Stops the message indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results.
Syntax
SET NOCOUNT { ON | OFF }
Remarks
When SET NOCOUNT is ON, the count (indicating the number of rows affected by a Transact-SQL statement) is not returned. When SET NOCOUNT is OFF, the count is returned.
The @@ROWCOUNT function is updated even when SET NOCOUNT is ON.
SET NOCOUNT ON eliminates the sending of DONE_IN_PROC messages to the client for each statement in a stored procedure. When using the utilities provided with Microsoft® SQL Server™ to execute queries, the results prevent "nn rows affected" from being displayed at the end Transact-SQL statements such as SELECT, INSERT, UPDATE, and DELETE.
For stored procedures that contain several statements that do not return much actual data, this can provide a significant performance boost because network traffic is greatly reduced.
The setting of SET NOCOUNT is set at execute or run time and not at parse time.
Happy Programming
|
|
|
|
|
How I write the condition of SQL statement to retrieve all author's name from database pubs if passing parameter is null and if user insert an author's name, then only particular name will be display..
thanks
angela
|
|
|
|
|
CREATE PROCEDURE GetAuthors
@AuthorName nvarchar(100)
AS
IF @AuthorName IS NULL
SELECT AuthorName FROM Author
ELSE
SELECT AuthorName FROM Author WHERE AuthorName=@AuthorName
Is that one?
|
|
|
|
|
when i run your SQL statement, it not return any value if i didn't insert author's name.
I get another SQL statement that can solve my problem,
Declare @au_lname char(30)
Select @au_lname = ''
select title, price,
Name = substring (au_lname, 1,40), type
from titleauthor ta JOIN authors a on ta.au_id = a.au_id
JOIN titles t on ta.title_id = t.title_id
Where 1 =
Case
When RTRIM(@au_lname) = '' Then 1
When RTRIM(@au_lname) <> '' And
RTRIM(UPPER(@au_lname)) = RTRIM(UPPER(au_lname)) Then 1
Else 0
End
it's cool;)
angela
|
|
|
|
|
Hi!
You can simplify this statement:
Declare @au_lname char(30)
Select @au_lname = ''
select title, price, Name = substring (au_lname, 1,40), type
from titleauthor ta
JOIN authors a on ta.au_id = a.au_id
JOIN titles t on ta.title_id = t.title_id
where RTRIM(@au_lname) = ''
or RTRIM(UPPER(@au_lname)) = RTRIM(UPPER(au_lname))
Regards,
Rainer.
Rainer Stropek
Visit my blog at http://www.cubido.at/rainers
|
|
|
|
|
ok, thanks for your solution
angela
|
|
|
|
|
Hi
I have a simple web page that written in C# and Asp.Net.
In that page i have asimple insert query that work by
Microsoft Accees .
When I run it in my camputer az a project I don't reciev this message but when i placed on my host or on my iis I reciev this massage .
If You Know How Can I solv this problem plz
answer me az soon az possible:->
Thanks alot .
-- modified at 8:22 Sunday 11th June, 2006
|
|
|
|
|
isiran wrote: When I run it in my camputer az a project I don't reciev this message but when i placed on my host or on my iis I reciev this massage
Sounds like a permissions issue. Make sure the db is in a location where the web user has permissions to write to.
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
-- modified at 2:33 Tuesday 13th June, 2006
|
|
|
|
|
Hi
I checked it befor.
I have write access on my db folder on my camputer an host.
Thansk alto.
|
|
|
|
|
isiran wrote: I checked it
mmmm
isiran wrote: I have write access
Your account and the web user account are differnt, remember that ISS runs with different (even more restricted) permissions than you.
Failing a permissions issue, I have no idea then. The only issues I have expereinced and seen posted on the net have been permissions related.
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
|
isiran wrote: Thanks
Your welcome, its nice to help polite people.
So I take it, the problem was a permissions one?
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
Hi
Yes it is and I checked every permissions on my folder on my host that contains my db file .I had write permission;)
I checked my host permissions on my folders(what ever that every one noticed me!)
But I had this problem yet
If U can plz help me.
Thanks alot.;)
|
|
|
|
|
I have a problem in microsoft access -- How i can retrieve AutoNumber Field After Insert a new record in microsoft access 2000
Is any one answer to me ?
|
|
|
|
|
I found my solution. it is Max(FieldName)
|
|
|
|
|
I have two datasets,
one derived from a database.
one derived from an xml file.
Is there any way to compare both these datasets?
Thanks,
Fen
|
|
|
|