Senin, 15 November 2010

List of datatypes supported in SQL Server

We frequently use some datatypes like INT, CHAR, VARCHAR,etc. But there are currently 37 datatype supported by SQL Server. If you want to know the list of supported datatype, run the following methods Method 1 : Use system stored procedure sp_datatype_infoexec sp_datatype_infoMethod 2 : Use system table sys.typesselect * from sys.typesThere are other system stored procedures specific to each

Tidak ada komentar:

Posting Komentar