Multiplying two positive numbers resulting in a negative number
Weird multiplication Error What would you do when multiplying two positive numbers resulting in a negative result ? If its
Read moreWeird multiplication Error What would you do when multiplying two positive numbers resulting in a negative result ? If its
Read moreDeleting duplicate rows in SQLServer is very simple. Example : Check this table let me call it as Sample, order
Read moreWhile importing data from Excel to SQLServer, if a Excel column in has both Text and Numeric values then either
Read moreSQL Server Cursor is a necessary evil. Its useful but at the same time its slow and time consuming when
Read moreWhether you are copying query output from SQL Server Management Studio or Saving result as .csv file, if you need
Read more– by Alexander Chigrik An extended stored procedure (xp) is a dynamic link library that runs directly in the address
Read more3 Techniques 1. Simple Fixed ‘N’ SELECT TOP 10 NewsURL, ArticleTitle, ArticleAuthor FROM NewsStoriesTable ORDER BY PublicationDate DESC 2. Dynamic
Read moreSet Conn = Server.createobject(“ADODB.Connection”) Conn.Open “Provider=sqloledb;” & _ “Data Source=ServerName;” & _ “Initial Catalog=DatabaseName;” & _ “User Id=UserID;” & _
Read more