Tag: tips

SQL Server – Saving changes is not permitted. The changes you have made require the following tables to be dropped...

AbundantCode 1 year ago in SQL Server 0

There are times when you get an error stating “Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.” You can easily resolve this issue by following the steps mentioned…

How to Derive a Class (Inheritance) in Javascript (WinJS) ?

AbundantCode 1 year ago in Windows 0

If you want to derive a class from another class in Javascript when developing a Windows store app using WinJS library , you can use the WinJS.Class.derive method to do it. How to Derive a Class (Inheritance) in Javascript (WinJS) ? Below is a sample code snippet demonstrating how to derive a class in WinJS.

Example of Property Elements in Xaml

AbundantCode 1 year ago in XAML 0

The Syntax for the property element in Xaml is as follows below TypeName.PropertyName The property elements are always contained inside a typename object and they don’t have the attributes of their own. An example of the property element is the Button.Content property which is used to set the content of the button control which is of type object. The Below code is used to set…

using IN clause to provide a list of values for Search Criteria

AbundantCode 1 year ago in SQL Server 0

In SQL Server , you can use the IN clause to providing the list of values for a search criteria. For example , you want to display the employee records who’s job title is one of the following : ‘Design Engineer’,’Tool Designer’. The above query uses the IN clause to filter the employee records using the arbitrary list of values. Alternatively , you can also…

C Program to print a Half Pyramid using *

AbundantCode 1 year ago in C 0

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * * * * * * How to create and display Half Pyramid pattern in C ? Output Abundantcode.com Coding samples Enter the total number of rows: 5 * * * * * * * * * * * * * *…

Exit the Current Scope without returning a value in SQL Server

AbundantCode 1 year ago in SQL Server 0

You can use the RETURN statement to discontinue the execution of a the T-SQL batch statement. For example , you want to display the Employees whose MaritalStatus is Divorced. You donot want the SQL Statements following it to be executed if this condition doesn’t match. You can use the IF NOT EXISTS and use the RETURN statement as shown in this example. The second statement…

Inner Join in SQL Server

AbundantCode 1 year ago in SQL Server 0

You can use inner join to get the result of two tables that match the criteria. For example , assume that you have a Person table and a Phone Number table where every person would have 0 or more phone number associated to him and you wish to get the person records who have at least one phone number. Here’s the query on how to…

How to check if a column exists in a table in SQL Server ?

AbundantCode 1 year ago in SQL Server 0

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

AbundantCode 1 year ago in SQL Server 0

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.