Learning lessons for Sitecore, C#, .NET, SQL Server

Many times you may get Sybase IQ error like Syntax error near 'SET'. Suppose if I am trying to execute below statements SET T...

In SQL Server, sp_executesql stored procedure is used to execute a dynamic Transact-SQL statement or batch statements. But in Sybase I...

Suppose you have two tables TableA and TableB . Both these table contains ID column. Now if you are trying to access ID column as below ...

If you are executing SELECT statement in Sybase IQ with having same alias name of two columns as below SELECT       School . cCreat...