Tag: tricks
How to check if a column exists in a table in SQL Server ?
If you want to find out if a column exists in a SQL Server table , you can use the sys.columns table and specify the name of the column and table as parameter. How to check if a column exists in a table in SQL Server ? For example , you want to find out if the GroupName column exists in the table “HumanResources.Department” table…
Sleep Command in SQL Server
If you are looking at writing a query to sleep for or WAIT for a certain amount of time before the query execution can begin , you can use the WAITFOR command. For example , if you want to wait for 1 minute , the query or command for the same will be this.
Specify a port number when connecting to SQL Server in Management Studio
There are times when you want to connect to a SQL Server instance that is running on a different port number than default port (1433). How to specify a port number when connecting to a SQL Server instance in SQL Management Studio ? Just specify the SQL Server instance that you are connecting to along with the port number with comma as delimiter. For example…
How to remove or replace array element in JavaScript ?
To remove or replace an element in an array in JavaScript , you can use the splice method as shown below. How to remove or replace array element in JavaScript ? To remove the array element , you can use the splice method and specify the index of the array to remove the array element. The second parameter determines the number of elements to remove….
How to mark a file as read-only from command line in Windows 10 ?
You can set a file to a read-only mode from the command line by using the command attrib and passing in the parameters like the read-only mode and the name of the file. The format of this command is as follows attrib +R <Name of the the file> How to mark a file as read-only from command line in Windows 10 ? For example ,…
How to embed Rectangle inside a Button in Xaml ?
Below is a sample code demonstrating how to embed a rectangle inside a Button in Xaml . How to embed Rectangle inside a Button in Xaml ?
How to get the list of all tables from a SQL Server database ?
If you need to get the list of all tables from a SQL Server database , you can query the information_schema.tables by specifying the TABLE_TYPE parameter search criteria to “BASE TABLE’. How to get the list of all tables from a SQL Server database ?
Sorting the Data in a Query in SQL Server
You want the results of the query to be displayed in a sorted order based on some query. In this case , you use the ORDER BY clause in the query by specifying the column on which the sort to work. For example , you want to sort the Departments table in the database by the column DepartmentName. Here’s how the query looks like This…
How to stretch ListBox Items horizontally to full width of the ListBox in Xaml ?
If you want the list items to horizontally stretch to full width of the ListBox in Xaml , you can set the HorizontalContentAlignment property to the value as shown below. How to stretch ListBox Items horizontally to full width of the ListBox in Xaml ? Below is a sample code snippet demonstrating the usage of the ItemContainerStyle of the Listbox to set the Style.
How do you check if an index exists in a table?
You can find out if the index exists for a table by querying the sys.indexes table as shown in this blog post’s code sample. How do you check if an index exists in a table? This will list out all the indexes of the table.
Using NOT operator to inverse the condition in SQL Server
Imagine a scenario where you want to retreive records that you dont want. You can use the NOT operator to reverse the search condition. For example , You want to get all the departments having the GroupName other than ‘Research and Development’. The other way of getting the same result is using the != in every condition.
How to Generate C# class from a XML file ?
Do you want to generate C# class from an XML file ?. You can use the xsd tool to do it. How to Generate C# class from a XML file ? 1. Just launch the Visual Studio Developer Command prompt from the Windows Start menu. 2. Type the command xsd and specify the path of the xml file. xsd d:\test\test.xml 3. This will create the…