Blue Ray Plus - Latest Technology News - Stories tagged with SQL

SQL

1
Ups

Hold Up

How do I determine if a column exists in a given table?

published 240 days, 20 hours, 51 minutes ago posted by

admin 241 days, 1 hour, 52 minutes ago

How do I determine if a column exists in a given table?

// home // advanced search // news // categories // sql build chart // downloads // statistics ASP FAQ HomeASP FAQ Tutorials 8000XXXX Errors Alerts ASP.NET 2.0 Classic ASP 1.0 Databases Access DB & ADO General SQL Server & Access Articles MySQL Other Articles Schema Tutorials Sql Server 2000 Sql Server 2005 General Concepts Search Engine Optimization (SEO) Contact Us Site Map Search Web aspfaq.com tu... (more)

category: SQL | clicked: 1 | comment | | source: databases.aspfaq.com

tags: SQL

1
Ups

Hold Up

Blog by Hemant Gupta: Data Types in SQL Server 2008

published 240 days, 20 hours, 51 minutes ago posted by

admin 247 days, 19 hours, 44 minutes ago

Blog by Hemant Gupta: Data Types in SQL Server 2008

I Read a great article on database journal lately about data types in 2008 , i am sharing some basic info. Numeric data types An Integer is a counting number with no decimal point or fractional piece. All negative numbers, positive numbers, and zero are integers. SQL Server breaks integers into four sizes: BigInt: -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Int: -2,147,483,648 to 2,147,483,648 SmallInt: -32,768 to 32,767 TinyInt: 0 to 255 Here as a part of software design you nee... (more)

category: SQL | clicked: 0 | comment | | source: hemantg.blogspot.in

tags: MS Server, SQL, SQL Server

1
Ups

Hold Up

Blog by Hemant Gupta: SQL server order of precedence

published 240 days, 20 hours, 51 minutes ago posted by

admin 247 days, 19 hours, 48 minutes ago

Blog by Hemant Gupta: SQL server order of precedence

Anyone who has been writing queries must have come across a situation where somehow the query looks fine but the result is not matching to the expectation. Well then one major problem here is that you are not aware of the logical or arithmetic operator sequence. I have tried to simplify, present to you the order that you should have in mind. 1~ (Bitwise NOT)2* (Multiply), / (Division), % (Modulo)3+ (Positive), - (Negative), + (Add), (+ Concatenate), - (Subtract), & (Bitwise AND), ^ (Bitwise Exclusiv... (more)

category: SQL | clicked: 1 | comment | | source: hemantg.blogspot.in

tags: MS Server, SQL

1
Ups

Hold Up

Coalesce vs. ISNull SQL, Coalesce SQL

published 247 days, 19 hours, 43 minutes ago posted by

kailash 254 days, 21 hours, 17 minutes ago

// home // advanced search // news // categories // sql build chart // downloads // statistics ASP FAQ HomeASP FAQ Tutorials 8000XXXX Errors ASP.NET 2.0 Classic ASP 1.0 Databases Access DB & ADO General SQL Server & Access Articles MySQL Other Articles Schema Tutorials Sql Server 2000 Sql Server 2005 General Concepts Search Engine Optimization (SEO) Contact Us Site Map Search Web aspfaq.com tutorials.asp... (more)