ACCESS SQL COLUMN DATA TYPE

HELLO

i have an sql server database, with a table an some columns.

how can i get the data type of each column and the lengh define in the database table?

Are you working with SQL Server 2000 or 2005?

|||

sql 2000

|||

Fire up profiler, filter to your spid, and run sp_help on a table. See what SQL Server does. You can copy the code from what SQL Server does and use it for yourself. To start with, check out syscolumns in books online.

|||

Or, you could use the INFORMATION_SCHEMA views to do it:

SELECT *FROM INFORMATION_SCHEMA.columnsWHERE table_Name =table  

HTH,

Stu

ACCESS PARAMETER (ssrs) urgent

HI ,
how can i access the different dataset parameter in th SSRS. i have created one dataset and define Bu as a parameter. then i created separate dataset called dataset2 and need to access that BU parameter from dataset2. i cant access it using normal way. ex strtoset(@.Bu)..... ?

dear Friend,

Inside my report, I have a field that is the sum of one field in a dataset and other field in other dataset...:

Code Snippet

=Sum(Fields!NC_FPA_OpFinanc.Value, "DataSet_FPAtribuidos")+Sum(Fields!CM_ENT_ReqFundosPropriosRC.Value, "DataSet_ActivoPonderado")

Helped you?
Regards!

|||i need to access it in my mdx query. is it possible to access like following?
SET [FilteredBUList] AS strtoset(@.BU,"Dataset2")