|
A function can return either a single scalar value or a table variable. This has been explained to you previously. A stored procedure can return multiple scalar values, so you could consider using one of those instead.
Paul Marfleet
|
|
|
|
|
hi guys, is it possible that i can retrieve records from different database like SQL Server 2000 and MySQL?
example, assuming i have table in SQL Server 2000 and i also have table in MySQL. the table in SQL Server 2000 for example is Table1 and in MySQL is Table2.
if i create a query that will combine or retrieve the fields of the two database, is it possible?
if so anyone who have idea with that and how to do that?
Thank You.
Don't block the drive way of all the newbies in programming. 
|
|
|
|
|
I don't know, but guess with the use of LINQ, may be you can get this!
Please someone answer back if more information related to this is found.
thanks,
|
|
|
|
|
Does anybody knows where to find a vb 6 code that can manipulate database.. e.g. add, edit and delete a field... also code that can manipulate existing fields.. thnks..
|
|
|
|
|
Can anyone point me to more resources on Application partitioning using SQL Server? I'm thinking about developing multi-company portal so I'm in research phase for finding something that'll work out best in that case.
Thanks in advance!
|
|
|
|
|
hi , i have build an ASP.net application using Enterprise library 1.1. Curremtly i was using sql server 2000. Now i have to take my DB to sql server 2005. my question is that my current application will work with SQL server 2005??? Is enterprise library 1.1(june 2005) work well with SQL server 2005????? please reply soon...
|
|
|
|
|
Hi,
In sql plus if i type user name and password it showing account is locked.
How to release the locked account
Thanks in advance
Regards
Azeem
|
|
|
|
|
You might have to go in as admin and fix it. If it is the admin account that is locked, then not much can really be done.
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
|
I'm using SQL Server 7 on the LAN network and I would like to block other SQL Servers from detecting or at least from accessing it.
The server still must allow access to users via applications so logins must exist. I just don't want other SQL servers on the network to be able to connect to and import/export, view table and SP, etc.
Any ideas?
|
|
|
|
|
CAn't be done. Best you can do is lock it down so that your applications use a login that has limited permissions, and make sure noone has the details of the admin account.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
It cannot be done. You need to have the particular server just not be accessed by the others.
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
|
May this work.
In sql server's properties, theres one check box as "register in ad server". Try to uncheck it and then see.
thanks,
|
|
|
|
|
CREATE FUNCTION dbo.abc (@a int)
RETURNS @Products TABLE (
CategoryName nvarchar(15)
, ProductID int)
can i , through this function type return more then one value ,I mean , scalar function return one value, or u can say in the programming languages like c# we can use ref keyword for the function parameters to get the updated value.are these parameters , refererence like parameters in c#.
and one more thing , how can i use the these updated parameters in the stored procedure , that are declared in the function under
TABLE( CategoryName nvarchar(15)
, ProductID int)
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Functions can either return a single scalar value or a table variable. Stored procedures can return more than one value if you append the OUTPUT keyword to any of your parameter declarations.
I don't understand the second part of your question. Your function returns a table variable. What do you mean by 'updated parameters'?
Paul Marfleet
|
|
|
|
|
How use of function, cursor, trigger in stored procedure in sql server
|
|
|
|
|
These are three separate areas that I recommend you reading up on by googling or buying a book.
In themselves they are fairly weighty topics so if you could be more specific you may get more specific help.
Do you understand what the these three components do?
Based on SQL Server 2000(and over-simplifying):
A function is used for returning a single value, or a table.
A cursor allows you to process one row at a time in a table, so that you can manipulate the data row by row.
A trigger is a rule that is applied to a table when an insert, update or delete s performed.
Hope this helps...
You always pass failure on the way to success.
|
|
|
|
|
I would recommend reading pl/sql from Ivan byross (sorry for spelling mistakes).
|
|
|
|
|
can i use the reference parameteres in the sql user defined functions.
actuallty i wanted to retrieve two values from the function.
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
|
ThanQ
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Here is a link to an article that clearly explains about the three types of User-Defined function's that can be Implemented in sql server.
UDF's Explained with a real world example[^]
Regards
J O H N ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
"Even eagles need a push." David McNally
|
|
|
|
|
ThanQ
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
From Data menu when I select Add new data source. I get wizard which shows
3 options , after selecting database as first option It shows second page
Of new connection,I get Add Connection box. On which change Button gives list of available databases. (All this for first chapter of ADO.net step by step.)
I have installed SQL server 2005.net,VC#2005.net still it does not show SQL server option in list. It just shows Microsoft SQL server database file,which is of no use.
Will any one will help me for same.
When I open SQL server 2005,it really does not have anything like Query analyser
or Enterprise Manager.
|| ART OF LIVING ||
|
|
|
|
|
You really need to RTFM rather badly.
SQL Server 2005 == Microsoft SQL Server.
SQL Server management Studio ~= Enterprise manager + query Analyzer.
There is no such thing as SQL Server 2005.net (drop the .net).
sounds like the book you chose is a crappy one. Using the wizards is always a bad Idea, since you never get a real idea of how the code should be done, but a least common denominator solution instead.
|
|
|
|
|
Hi friends,
what is the boolean or bit datatype available in ORACLE ?
Please help me.
Regards,
Jegastar.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
