Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

SQL Truncate Table

SQL Truncate Table Using this statement you can remove all data of rows or column ( complete data ) not table. In this there is no where clause but where clause is available in Delete statement. Truncate table is faster than Delete statement ...

Introduction to SQL

Overview of SQL : SQL is a scripting language for the database handling. SQL is called as Structured Query Language. SQL is used to handle relational database, we can create, update, delete, and fetch records from the database. SQL is a powerful...

Warning of Saving Changes in not permitted in SQL

Warning: "Saving Changes in 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 cant be re-created or enabled the option Prevent saving changes that r...

PHP sr. developer

Experiencia mnima de 3 aos programando con frameworks PHP MVC Experiencia en desarrollos utilizando web services REST Conocimientos en diseo y desarrollo de bases de datos relacionales (PosgreSQL, Oracle) Experiencia mnima trabajando co...

Get all running/sleeping processes in database

Hi All, Some times we need to know the all running/sleeping process in database. We can use the below code:-- SELECT 'These processes are using database' AS Note ,[Database]=DB_NAME(dbid), spid, last_batch, status, hostname, loginame FRO...

Get the List of all tables using foreign key

Hello All, Many time, We want to know that, What are all the tables who have referenced a column as a "foreign key" which is a "Primary Key" of other table. Example:-- In a database I have one Company table which stores company information...

How to improve SQL database design and performance

In this era of software development technology, the main concern in development should be the best performance. As we already aware that database is the backbone of any software. So whilst designing the database we need to keep a few things in mi...

How to get next Date excluding weekends with start date and the number of working days using SQL ?

Hi All, While working with SQL, I came across the requirement to get the business days only. I had the number of working days and the starting date. Now the requirement was to get the next date by excluding all the Saturday Sunday and only to co...

SQL Joins and it's Uses

In SQL **joins** are used when we want to select data and information from two or more tables on the basis of some relationships between one or more columns in tables. SQL Joins are used to relate information in different tables. Thus,we ca...

Creating xml from SQL query

This blog will show you how to create an xml from sql query having sql data. Write down the followng query to generate xml:- WITH XMLNAMESPACES ('http://www.dossia.org/v2.0/xml/phr' as phr) Select OrderResultID,OrderID ,PatientID ,SpecimenNum...

Restricting data in Oracle

This blog will help you to restrict data from a database. You can restrict the rows returned from the query by using the WHERE clause. A WHERE clause contains a condition that must be met, and it directly follows the FROM clause. If the condi...

SQL - Generating XML 2

Every XML has two elements i.e. 1) Attributes and 2) Value SELECT magazineId AS '@id' , magazineName AS '@name' , CoverPage AS '@coverPage' , isActive AS '@status' , publishDate AS '@publishDate' , expiryDate A...

SQL SERVER - Generating XML - 1

Following is the XML which we want to create: SELECT magazineId , magazineName , coverPage , publishDate , expiryDate , isActive ,( SELECT ( SELECT ( ...
1 2 4 next
Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: