crackyourinterview.com offers sql interview questions and some query

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Topic of Day

:) Hot Jobs

ASP.NET Developer(2-5 years)(Location:-Gurgaon(http://www.amadeus.co.in))

Software Developer(0-3 years)(Location:-ZENITH SERVICE.Plot 2N-67 BUNGALOW PLOT NEAR 2-3 CHOWK, NEAR APOORVA NURSING HOME N.I.T. FARIDABAD)

Dot Net Developer(6-7 years)(Location:-Chennai)

Software Developer(3-8 years)(Location:-Bengaluru/Bangalore)

:) Most Searchable

50 Latest questions on Azure

Different questions on Docker Container Orcas

In Master-Slave databases, all writes are written to the ____________.

Which of the following services is free?

Identify the correct statement in the following in secure programming questions

Cassandra Interview Questions Part

SaaS supports multiple users and provides a shared data model through ________ model.

Which of the following is cloud computing key enabling technologies?

DaaS is utilized for provisioning critical data on demand.

Classification problems aid in predicting __________ outputs.

cache Interview Questions Part1

Developers and organizations all around the world leverage ______ extensively.

In the public cloud, it incurs high CAPEX and less OPEX.

__________ aids in identifying associations, correlations, and frequent patterns in data.

Multiple choice questions on Javascript

:) Quiz System

Computer Quiz

Science Quiz

Banking Quiz

Sports Quiz

GK Quiz

Count Number of time a character occur in SQL Query? View:-273
Question Posted on 31 Jul 2023

Count Number of time a character occur in SQL Query?
To count the number of time a character occur in SQL....

ADS Posted In : DataBase | SQL Query

Use of keyword DISTINCT and TOP in one sql query? View:-342
Question Posted on 25 May 2023

Use of keyword DISTINCT and TOP in one sql query?
We can use DISTINCT and TOP keyword in SQL Query and ....

ADS Posted In : DataBase | SQL Query

What do you mean by SQL Latch Contention and how we can avoid this? View:-433
Question Posted on 21 Apr 2023

What do you mean by SQL Latch Contention and how we can avoid this?
When we say about SQL Latch Contentio....

ADS Posted In : DataBase | SQL Query

Query to fetch every alternate records from a table in SQL? View:-583
Question Posted on 18 Apr 2023

Query to fetch every alternate records from a table in SQL?
We can fetch every alternate records and we c....

ADS Posted In : DataBase | SQL Query

Query to get values from XML field in SQL Server? View:-653
Question Posted on 08 Mar 2023

Query to get values from XML field in SQL Server?
Below is the query to get values from XML field in SQL ....

ADS Posted In : DataBase | SQL Query

Different method to convert string to date explicitly? View:-1072
Question Posted on 22 Aug 2022

Different method to convert string to date explicitly?
When we sayabout the explicit conversion which is ....

ADS Posted In : DataBase | SQL Query

Number of row comparison operator used while doing with a subquery? View:-1098
Question Posted on 05 Aug 2022

Number of row comparison operator used while doing with a subquery?
There are mainly three row comparison....

ADS Posted In : DataBase | SQL Query

Write dynamic Query to accept dynamic variable and dynamic column in SQL? View:-1134
Question Posted on 17 Jul 2022

Write dynamic Query to accept dynamic variable and dynamic column in SQL?
Below are the two example to wr....

ADS Posted In : DataBase | SQL Query

Name the table and query and store procedure which is used to hold the stored procedure scripts? View:-1148
Question Posted on 27 Jun 2022

Name the table and query and store procedure which is used to hold the stored procedure scripts?
TableNam....

ADS Posted In : DataBase | SQL Query

Write a query to get list of triggers in database? View:-1194
Question Posted on 27 Jun 2022

Write a query to get list of triggers in database?
Query to get list of triggers in database is written b....

ADS Posted In : DataBase | SQL Query

SQL Query to find ColumnName in any table? View:-1180
Question Posted on 27 May 2022

SQL Query to find ColumnName in any table?
Below is the query is used to test that column is exists or no....

ADS Posted In : DataBase | SQL Query

Query to insert SQL carriage return and line break in query? View:-1347
Question Posted on 20 May 2022

Query to insert SQL carriage return and line break in query?
Below query will helps you to insert carriag....

ADS Posted In : DataBase | SQL Query

Write a query to get jobs working in SQL Server Database? View:-1123
Question Posted on 17 May 2022

Write a query to get jobs working in SQL Server Database?
Below are the two query which helps you to get ....

ADS Posted In : DataBase | SQL Query

Create a Role in SQL and assign to user with syntax Revoke Drop Grant? View:-1142
Question Posted on 23 Apr 2022

Create a Role in SQL and assign to user with syntax Revoke Drop Grant?
Basically role is created in SQL t....

ADS Posted In : DataBase | SQL Query

Update table with Select Update, CTE, Merge and from Select statement? View:-1145
Question Posted on 21 Apr 2022

Update table with Select Update, CTE, Merge and from Select statement?
We can update table from another t....

ADS Posted In : DataBase | SQL Query

How to get Random Number for specific range in SQL Query? View:-1221
Question Posted on 20 Apr 2022

How to get Random Number for specific range in SQL Query?
To apply Rand() function to a specific range yo....

ADS Posted In : DataBase | SQL Query

A simple example of Pivot table in SQL Server(Column into Row)? View:-1528
Question Posted on 20 Jan 2022

A simple example of Pivot table in SQL Server(Column into Row)?
Below is the example to create a output i....

ADS Posted In : DataBase | SQL Query

How to set query to apply paging in SQL Query to get records? View:-1537
Question Posted on 20 Jan 2022

How to set query to apply paging in SQL Query to get records?
We can use SQL Query which helps us to appl....

ADS Posted In : DataBase | SQL Query

SQL Query to find the date when new column is added or modified in sql table? View:-1728
Question Posted on 01 Dec 2021

SQL Query to find the date when new column is added or modified in sql table?
Below is the SQL query to g....

ADS Posted In : DataBase | SQL Query

SQL Query to disable or unable foreign key constraints temporarily by using TSQL? View:-1688
Question Posted on 23 Nov 2021

SQL Query to disable or unable foreign key constraints temporarily by using TSQL?
There are certain condi....

ADS Posted In : DataBase | SQL Query

Query to get last occurrence of any character from any string? View:-1722
Question Posted on 23 Nov 2021

Query to get last occurrence of any character from any string?
Below is the query which will helps you to....

ADS Posted In : DataBase | SQL Query

Code to handle and delete Node from XML with childnode values? View:-1671
Question Posted on 22 Nov 2021

Code to handle and delete Node from XML with childnode values?
Below is the code to handle Node values fr....

ADS Posted In : DataBase | SQL Query

Get last 4 charcters of string in SQL Server query? View:-1619
Question Posted on 18 Nov 2021

Get last 4 charcters of string in SQL Server query?
Below are the two sql query to get the last 4 charact....

ADS Posted In : DataBase | SQL Query

Different SQL query to get details of every column in table with details? View:-1678
Question Posted on 16 Nov 2021

Different SQL query to get details of every column in table with details?
Below are the 3 main query to f....

ADS Posted In : DataBase | SQL Query

Write a SQL in built function which will return the count of active transactions? View:-1635
Question Posted on 04 Nov 2021

Write a SQL in built function which will return the count of active transactions?
Below is the syntax whi....

ADS Posted In : DataBase | SQL Query

Query to repeat rows N times as per the column Value in SQL Server? View:-3955
Question Posted on 04 Nov 2021

Query to repeat rows N times as per the column Value in SQL Server?
To Repeat Rows n times according to c....

ADS Posted In : DataBase | SQL Query

What action plan you create when SQL Server is not responding? View:-2168
Question Posted on 26 Oct 2021

What action plan you create when SQL Server is not responding?
Once SQL Server is not responding we will ....

ADS Posted In : DataBase | SQL Query

How to retrieve unsaved SQL query script or files? View:-1995
Question Posted on 25 Oct 2021

How to retrieve unsaved SQL query script or files?
There are many situation when SQL server Management St....

ADS Posted In : DataBase | SQL Query

Can store procedure be recursive if yes then its level? View:-1726
Question Posted on 27 Sep 2021

Can store procedure be recursive if yes then its level?
A stored procedure can be recursive and referenci....

ADS Posted In : DataBase | SQL Query

Write a query to get all even and odd number if we have some id column? View:-1837
Question Posted on 26 Sep 2021

Write a query to get all even and odd number if we have some id column?
Below is the query to get all eve....

ADS Posted In : DataBase | SQL Query

How to use xp_cmdshell in SQL? View:-1750
Question Posted on 26 Sep 2021

How to use xp_cmdshell in SQL?
We use xp_cmdshell in SQL to run DOS command. But before use of this we ne....

ADS Posted In : DataBase | SQL Query

Can we execute DOS command from SQL. View:-2026
Question Posted on 25 Sep 2021

Can we execute DOS command from SQL.
Yes we can execute DOS command by using xp_cmdshell. And to execute....

ADS Posted In : DataBase | SQL Query

1 2 3 4 5 6 7

:) Categoriese

:) Most Visited Questions

Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a More...

Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra More...

Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec More...

Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres More...

What is Gulpjs and some multiple choice questions on Gulp
Gulpjs is an open source whihc helps in building Javascript More...

Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions

PHP | Biztalk | Testing | SAP | HR |

Privacy policy | Terms and Conditions | Blog

If the copyright of any wallpaper or content or photo belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)