SQL Server – I Learnt Today

SQL Server data types explained with .net data types

2016/07/19 Source / Reference : Msdn Member name Description BigInt Int64. A 64-bit signed integer. Binary Array of type Byte. A fixed-length stream of binary data ranging between 1 and 8,000 bytes. Bit Boolean. An unsigned numeric value that can be 0, 1, or null. Char String. A fixed-length stream of non-Unicode characters ranging betweenContinue reading “SQL Server data types explained with .net data types”

How to get Table Information in SQL Server (Equivalent of Oracle’s desc)

01-06-2012 You can use following stored procedures to get table information similar to what you get by calling “Desc” in Oracle. Sp_columns ‘<TableName>’ This will show the list of columns along with other useful information such as: data type, length, Is-Nullable, etc… You can also use sp_help ‘<TableName>’ For even more descriptive information This willContinue reading “How to get Table Information in SQL Server (Equivalent of Oracle’s desc)”

How To Check For NULL Values Correctly In SQL

D LINQ : How to Map Columns Which Auto Generate Values At the Database

2009-05-11 http://pagead2.googlesyndication.com/pagead/show_ads.js I have being working on a software application made on .Net and recently my client asked me to use D LINQ instead of SQL. D LINQ has great benefits loaded! As I started working with DLINQ I started to know that preventing SQL injection is not a headache anymore and misspelled SQL queriesContinue reading “D LINQ : How to Map Columns Which Auto Generate Values At the Database”