Game Suggestion: Knife Game (for Android)
A new game by Gama Guma Games - Knife Game Throw the knife. Hit the monster that behind the turning shield. Collect the coins. Get the new knives. Beat the boss. A new enjoyable game!…
Passing parameters to JavaScript files
You can assign an id to the <script> element and passing the arguments as data-* attributes. The resulting <script> tag would look something like this: (more…)
How to solve ajax.reload() not working for DataTables…
If you use the reload in this way then it will probably not work. table.ajax.reload(); (more…)
Default Settings for Datatable in MVC
When working with DataTables over multiple pages it is often useful to set the initialisation defaults to common values (for example you might want to set dom to a common value so all tables get the same…
Search text in all tables in SQL Server
Please note that with a little bit changing you can also use this query as a stored procedure. (more…)
How to hide message window in MS SQL…
CTRL +R toggles (hides or shows) the Messages window. (more…)
How to find the first missing value in…
Let's say we have this values in the database: num --- 1 2 4 5 6 8 9 11 To Find the first missing value, we can use this: ;WITH CteRN AS( SELECT *, RN…
How to solve ‘incorrect syntax near the keyword…
Always use with statement like ;WITH then you'll never get this error. The WITH command required a ; between it and any previous command, by always using ;WITH you'll never have to remember to do this. (more…)
How to solve ‘Size property has an invalid…
You need to define a length when specifying the varchar parameter: SqlParameter TheFirstJob = cmd.Parameters.Add("@spParam", SqlDbType.VarChar, 50); Note: You should use the same length as defined in your SQL Server stored procedure.