Database

.NET Enthusiast wrote:

Currently the tables are printed huge and there is a lot of white space in between.

neodeaths wrote:

i am trying to create an stored procedure which would call an function from the asp.net function when an event(e.g when data in an perticular table is changed)

-- 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

<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 />

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?