parkc
Last Activity: Jan 7 '08, 01:33 PM
Joined: Feb 22 '07
Location:
-
Thank you for the response however, I am wanting to see if the order in which primary key columns have changed from one database to another. Therefore, it is important to know how to change the ordinal position for testing purposes. -
information_schema.key_column_usage system table
How do you change the order of key columns in a primary key and view the difference between two tables that have the same name?
For example, table x has a primary key called pk_x. PK_x contains two key columns x and y in the order 1 and 2 now I want to change it so that columns x and y are 2 and 1. How do I do that? -
I couldn't find it in the book. Thanks everyone for the help.Leave a comment:
-
Simple C# question
After you return a value from a method, how do you use the value returned in another method?
public string methodname()
{
return stringname;
}
public string anothermethodna me()
{
//use return value from 1st method in this method + "endingprefixna me"
} -
Problem resolved. Thinking was off....Leave a comment:
-
Question when subtracting two queries
I want to return the difference number of records.
Here are the queries:
--subtracting columns with columns and descriptions (columns - columns and descriptions)
--difference of 30 records
--243
select
h.name as 'DataBase Name'
,t.name as 'Table Name'
,c.name as 'Column Name'
from sys.tables t
inner join sys.schemas h
... -
Visual Studio 2005. By the way, both gridviews are sorted in the aspx page, which is why I'm puzzled. I used gridView2.Impor tRow(gridView1) ; to copy the contents of gridView1 and append them to gridView2. However, no sorting as stated in the apsx page.Leave a comment:
-
Question on GridViews
I have two gridviews and a transfer all button on both grids. Transferring one record at a time in the right order works. However when I click the transfer all button, the records move to the other grid, but out of order. Can someone please advise? -
testing to see if this reply worksLeave a comment:
-
Need Advice on Really Big Databases
I have 2000 tables to put in databases. Should I put them all in one database with multiple schemas, or should I put them in multiple databases (one per schema)?
I'm concerned about these issues:
Size of files for system admin tasks
Efficiency (developer and run time)
Foreign keys and adhoc query tool access -
Infragistics 2 WebDateChooser Question
Is there any way to justify a WebDateChooser control drop down list to have two spaces before it? For instance if I want to indent my label, I would like the WebDateChooser control drop down list to be indented so the label will be aligned with the WebDateChooser. -
Infragistics2.WebUI.WebDateChooser.v6.1 Question
Does anyone know how to reset a drop down WebDateChooser back to its default "Null"?
No activity results to display
Leave a comment: