Jak w temacie moze ktos podopowiedziec a najlepiej podac przyklad :-P gdzie za pomoca zapytania jest zwracany typ i rozmiar kolumny ? za pomoc z gory dzieki
0
0
Kawalek kodu z mojego programu. Ogolnie wszystko masz w
SELECT * FROM information_schema.columns WHERE TableName = 'nazwaTabeli'
lub bezposrednio w
SELECT * FROM syscolumns WHERE id = OBJECT_ID('nazwa tabeli')
ORDER BY colid
Przerob to ze stringa na zapytanie - powinno ort!
' SELECT COLUMN_NAME, ' +
' DATA_TYPE, ' +
' CHARACTER_MAXIMUM_LENGTH, ' +
' IS_NULLABLE, ' +
' COLUMN_DEFAULT, ' +
' IDENT_SEED(%s), ' +
' IDENT_INCR(%s), ' +
' (CASE '#13#10 +
' WHEN COLUMN_DEFAULT IS NULL THEN '#13#10 +
' CASE '#13#10 +
' WHEN DATA_TYPE = ''BINARY'' OR ' +
' DATA_TYPE = ''VARBINARY'' OR ' +
' DATA_TYPE = ''IMAGE'' THEN ''0x'' '#13#10 +
' WHEN DATA_TYPE = ''CHAR'' OR ' +
' DATA_TYPE = ''NCHAR'' OR ' +
' DATA_TYPE = ''NVARCHAR'' OR ' +
' DATA_TYPE = ''TEXT'' OR ' +
' DATA_TYPE = ''NTEXT'' OR ' +
' DATA_TYPE = ''VARCHAR'' THEN '''''''''''' '#13#10 +
' WHEN DATA_TYPE = ''FLOAT'' OR ' +
' DATA_TYPE = ''MONEY'' OR ' +
' DATA_TYPE = ''SMALLINT'' OR ' +
' DATA_TYPE = ''TINYINT'' OR ' +
' DATA_TYPE = ''DECIMAL'' OR ' +
' DATA_TYPE = ''NUMERIC'' OR ' +
' DATA_TYPE = ''INT'' OR ' +
' DATA_TYPE = ''BIGINT'' OR ' +
' DATA_TYPE = ''BIT'' OR ' +
' DATA_TYPE = ''REAL'' THEN ''0'' '#13#10 +
' WHEN DATA_TYPE = ''DATETIME'' OR ' +
' DATA_TYPE = ''TIMESTAMP'' THEN ''getdate()'' '#13#10 +
' ELSE DATA_TYPE '#13#10 +
' END '#13#10 +
' ELSE REPLACE(REPLACE(COLUMN_DEFAULT, ''('', ''''), '')'', '''') '#13#10 +
' END) [Value], '#13#10 +
' COLUMNPROPERTY(OBJECT_ID(%s), COLUMN_NAME, ''IsComputed'') '#13#10 +
' FROM information_schema.columns ' +
' WHERE TABLE_NAME = %s AND ' +
' COLUMNPROPERTY(OBJECT_ID(%s), COLUMN_NAME, %s) = %d '
0
SELECT * FROM information_schema.columns WHERE TableName = 'Tabela'
invalid column name TableName
0
SELECT * FROM information_schema.columns WHERE Table_Name = 'Tabela'
0
wielkie dzieki dziala ok [browar]
0
<ort>mógłby</ort> mi kots powiedziec jak pobrac nazwy kolumn do comboboxa i i wiersze z odpowiedniej kolumny??
0
Nie, zero szczegolow.