|
Hi
Can anybody help me to list the stored procedure parameters and return type in sql server 2005/2000 for a given stored procedure.
For ex:
Parameter_Name Data_Type Length
---------------------------------
kesavan
|
|
|
|
|
Here it is a version (displays from master database the parameters name, type and length for sp_addserver stored procedure):
-- SQL 2000/2005
if exists (select * from syscolumns where id = object_id('sp_addserver'))
begin
select
name
, type_name(xusertype)
, length
from syscolumns where id = object_id('sp_addserver')
end
-- SQL 2005
if exists (select * from sys.all_parameters where object_id = object_id('sp_addserver'))
begin
select
name
, type_name(user_type_id)
, max_length
from sys.all_parameters where object_id = object_id('sp_addserver')
end
Cristian
Nuclear launch detected
|
|
|
|
|
Hello if anyone can please give me just a tiny sample of how I'd do this, not just what to do I will be so grateful.
Just so you know. I have been googling for days on this and I'm not sure what to do as I am still pretty new to c#.
This is what I want to do. I have a dataset and datagrid(search results table) displaying results like this.
Siann Skills1
Siann Skills2
Siann Skills3
I want it to show this
Siann Skills1,Skills2,Skills3.
I have my select statement, then I have created a new datacolumn as I was told to do as below. Now after that, what do I do? How do I get all the skills in one column. I know I have to concatenate, and I have tried searching the net, but I can't find anything useful. is there any possibility for an example?
dgSearchResults.Columns.Add(new DataColumn("skills", GetType()));
I then have my foreach. I need to put something in the foreach.
foreach (DataSet1.EmpSkillsRow empskillsRow in empskillsDT.Rows)
{
}
I was told on the C# forum to try here. I am not using sql 2005 so I can't use cte.
|
|
|
|
|
Thats retarded that they told you to ask here...
Try this and forgive VB, I have been stuck in VB land for too long and can no longer do c# from memory.
<br />
Dim ds as New DataSet() 'substitute your data set<br />
Dim dt as DataTable = ds.Tables(0) 'substitute your data table<br />
Dim dr as DataRow<br />
<br />
Dim strColumnAValue as String = String.Empty<br />
Dim strColumnBValues as New StringBuilder()<br />
<br />
For Each dr in dt.Rows<br />
If (Convert.ToString(dr(0)) = strColumnAValue) Then 'we are working on the same user "Siann" in this case and will append values<br />
strColumnBValues.Append(Convert.ToString(dr(1)).Trim() & ",")<br />
<br />
Else 'You are working on a new person and not "Siann"<br />
If strColumnBValues.Length <> 0 Then 'there is a user/ skillset to write out<br />
strColumnBValue = strColumnBValue.Remove(strColumnBValue.ToString().LastIndexOf(","), 1) 'remove the last comma<br />
Console.Writeline("User: " & strColumnAValue & " - Skills: " & strColumnBValues.ToString()) 'write out the value<br />
strColumnBValues.Length = 0 'clear the string builder<br />
strColumnAValue = Convert.ToString(dr(0)) 'set the new column A Value<br />
strColumnBValues.Append(Convert.ToString(dr(1)).Trim() & ",") 'add the first value<br />
End If<br />
End If<br />
<br />
<br />
<br />
Next 'dr<br />
<br />
|
|
|
|
|
I am in SQL server
Say i entered a statement, though didn't finish it, i get:
mysql> SELECT id, size, color, quantity FROM product WHERE size = 'One size fits
'>
'>
'>
'>
'>
'>
'>
'>
what is the command to exit this unfinished statement and get back to the mysql> prompt? I know it if very simple, like backslash something. I went through the whole alphabet front a backslash, and still so success. Must finish this homework assignment.
|
|
|
|
|
sonywar wrote: I am in SQL server
sonywar wrote: what is the command to exit this unfinished statement and get back to the mysql> prompt?
These are two separate products. It appears you are using MySQL not SQL Server.
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
yes i am in MySQL Server command prompt and need to know how to get back to the regular prompt after pressing enter before my statement was complete.
do you know what the command is? i have read my starter sql book, and looked on many forums though i can not find a solution. I can restart the prompt though that is the long way. there is a simple backslash command i can type.
mysql> (is the regular prompt)
'>
'>
'>
'> (my prompt)
|
|
|
|
|
I'm not familiar with MySQL, but it may be waiting for a ';' semicolon to terminate the statement. Try ; <enter>. Don't use any non-whitespace characters after the ';', just press the enter key after the semicolon.
David
---------
Empirical studies indicate that 20% of the people drink 80% of the beer. With C++ developers, the rule is that 80% of the developers understand at most 20% of the language. It is not the same 20% for different people, so don't count on them to understand each other's code.
http://yosefk.com/c++fqa/picture.html#fqa-6.6
---------
|
|
|
|
|
Try "go" to send the command to the server.
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
Hello
i wanna know how can create a maintenance plan tl back up the database to remote server
i can do it but it backup the data on local desk. i want to do that but on remote desk
plz help me in this problem, its important to me
iam waiting ur responses.
thanks
|
|
|
|
|
Hi all
I have installed a SQL2005, i have an Acces database that i want to import to SQL200, i know that the Wizard we had in version 2000, is no longer available, please help me to import the database.
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
|
Thanks Paul
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi,
I am looking at saving my customer's date of birth, what is the best data type to use for this. I'm looking for advice. Should I just use varchar(8) or should I use the datetime datatype?
Regards
Brendan
|
|
|
|
|
Well, the obvious question is, why do you think there's a datetime type ? Some ideas that spring to mind:
1 - if you use the date type, you can do queries based on date ranges, etc
2 - if your DB gets moved to a PC with a different date format, the varchar will break, but the datatime will work fine
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Always for a date field use datetime.
Nuclear launch detected
|
|
|
|
|
DateTime every time.
And why would you want to know the customer's birthdate? I always enter 1900-01-01.
|
|
|
|
|
Marketing. Use a HTML template to congratulate the customer on birthday date...
Nuclear launch detected
|
|
|
|
|
hi all,
can I create sp which take table name ,first column ,secound column as a parameters to create table
(2 columns only) with this varibles name
for example to demonestrate my idea
ex:
---------------------------------
create proc Createtable
@tablename,
@firstColumn Varchar(40),
@secoundColumn Varchar(40)
as
create table @Tablename (@FirstColumn Varchar(40),@SecoundColumn Varchar(40))
----------------------------------
this is my idea Plz help me
Kareem Elhosseny
|
|
|
|
|
sp_executesql 'create table ' + @Tablename + '(' + @FirstColumn + <br />
' Varchar(40), ' + @SecoundColumn + ' Varchar(40))'
- Regards - JON Life is not measured by the amount of breaths we take, but by the moments that take our breath away.
|
|
|
|
|
|
you can use this command
SELECT RAND(@counter) Random_Number
123
|
|
|
|
|
Hi,
How can Select first 5 records of a table In SQL Server 2000?
In SQL Server 2005 can use Select Top(5) ... but in 2000 what?
Best wishes
|
|
|
|
|
Select Top Num? * from Tablename?
example ;
i need top 5 rows from Orders.
Select top 5 from Orders
123
|
|
|
|
|
It's the same syntax in both versions.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|