Ask a Question related to Coldfusion Database Access, Design and Development.
-
stallionmvp #1
MS-SQL Server - obtain pk from columns?
Hi all,
I have cfmx7 along with ms-sql2000. Given column names and table name which I
obtain dynamically, how can I find out which column(s) is/are the primary key
one? I was thinking of using store procedure to that, but I don't have that
much knowledge. Any comment or suggestion is appreciated.
stallionmvp Guest
-
I do not obtain to connect in Flash Media Server !!
Hi people I do not obtain to connect in Flash Media Server after that I installed it !!! I go in Star > Programs > Macromedia > Flash Media... -
Datagrid columns and ntext (via sql server)
Hi I've have some text inside a "ntext" data field from SQL server. I am displaying this text as a column in a datagrid using ASP.NET 1.1 and... -
Can't get value from datagrid when generating columns on the server side
Hi I have a problem with a datagrid, I need to get a value from one of the columns from when I hit a hyperlink column. The hyperlink column is... -
rename columns in sql server
hi group, am i stupid or what. I try to rename a column name via asp and getting errors all the time. what would be the right syntax: alter... -
Pad strings/concatenate columns to simulate data columns in ASP select box with SQL Server 2K
Dale, Cast all the data to fixed character data type in your select statement. For example: select cast(au_id as char(12)) +... -
mxstu #2 Re: MS-SQL Server - obtain pk from columns?
You should be able to retrieve primary key information by using one or more of
the system "views" in MS SQL 2000. I can't remember the exact syntax offhand,
but you can find the views in the documentation under INFORMATION_SCHEMA.(view
name).
HTH
mxstu Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
