Skip to content

Tag: sql

SqlDependency onchange event infinite loop

I have a simple query, and the event fires at the correct time. However, once fired, the property, .HasChanges, of the SqlDependency object is always set as true. The first time OnChange is fired, the SqlNotificationEventArgs Info property is “Inserted”. The second time the event is fired it&#8217…

convert datetime (mm/dd/YYYY) to decimal(YYYYmmDD)

I am trying to get the following result in Sql: example: 23/05/2014 to 20142305 but get this: result:41780 anyone know how you can get the following format?? (if possible ??) regards and thanks Answer In many databases (including SQL Server), you can just do: Some databases don’t support these functions…

Select from row to last row

Is it possible for me with MySQL to select the from a specific row to the end of the table, without knowing how many rows there are left? My query at the moment is: But I want to be able to something like: Can this be done? Answer Just use a large value like 999999999 that is going to be

Query JSON inside SQL Server 2012 column

I have a column inside my SQL Server 2012 table which contains following Json data. Now I want to use this column data in my query like Is there a way to query JSON data in SQL Server 2012? Answer Honestly, this is a terrible architecture for storing the data, and can result in some serious performance issues…

MySQL #1064 Error DATETIME

I’m making a web based mail system, and I have to create a table with this code: MySQL says: #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”messages'( ‘ID’ INT(250) NOT NULL AUTO_INCRE…