Nitesh Kejriwal

13/10/2014 by Nitesh

How To Create a Responsive Menu Using HTML, CSS & jQuery

Friends, This is Part 5 of the series I started a long time back for creating menus, from simple to complex. In today’s era when smartphones are making a lead in browsing websites, adapting menus to smartphones and other devices is equally important. In this post, we will see how can we create a menu…

07/10/2014 by Nitesh

SQL Script To List All Columns of a Table in SQL Server

Friends, In my last post, I explained how can you list all tables from a specific table in a database. In this post, we will see different ways of retrieving all columns from a specific table in a database. It is a very simple script to get all columns for a table from a database….

06/10/2014 by Nitesh

SQL Script To List All Tables Present In a Database

Friends, In this small post, we will see 2 different ways of retrieving all the tables from a specific database. It is a very simple script to get all tables from a database. We can do it using 2 ways. They are as below – Using INFORMATION_SCHEMA.TABLES table Using sys.Tables table The below script lists…

05/10/2014 by Nitesh

Solution: SSDT – Error SQL70001 This statement is not recognized in this context

Friends, In this post we will see how can we resolve a very common error while working with SQL Server Data Tools in Visual Studio. The error statement is – “Error SQL70001: This statement is not recognized in this context“. This error occurs in Visual Studio whenever we try to execute some SQL statements which are…

30/09/2014 by Nitesh

How To List The Name of Current Active Window in C#

Friends, In this post, we will see how can we get the name of currently active window using C#. Since a .Net application cannot access objects outside the application, to get the active window we will use few functions of Windows API provided by Microsoft. We will specifically use GetForegroundWindow() and GetWindowText() functions to implement…