Create an Embedded Data Source in SSRS
An Embedded data source, also known as a report-specific data source is a data connection that is saved in the report definition, and embedded data… Read More »Create an Embedded Data Source in SSRS
Home »
Sql Query
SQL Server Date
Date data type allows you to store the date data in the database. It takes 3 bytes to store a date value. SYNTAX date The… Read More »SQL Server Date
SQL IS NULL
The IS NULL is used in SQL to find a NULL value. It returns TRUE if a NULL value is found, otherwise it returns FALSE.… Read More »SQL IS NULL
Delete Horizontal White Space in SQL Serve
When you are required to import data received from different different file format such as .txt, .csv., or excel files, sometimes you see a white… Read More »Delete Horizontal White Space in SQL Serve
View Collation Information in SQL Server
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. You can easily find SQL collation at the server, database… Read More »View Collation Information in SQL Server
Change the column name and data type of result set of stored procedure
SQL Server 2012 has released a new feature WITH RESULT SETS, which allows column names and their data types to be changed in the result set… Read More »Change the column name and data type of result set of stored procedure
SQL Server Lag Function
SQL Server LAG() function is a Analytics Functions that provides access to a row at a given physical offset that comes before the current row.
SQL Server CONCAT_WS Function
SQL Server CONCAT_WS() function is a string function that is used concatenates two or more strings together with a separator.
It separates those concatenated string values with the delimiter specified in the first function parameter.
SQL Server Computed Columns
A computed column is a virtual column which is used to add a new column to a table with the value derived from the values of other columns in the same table.
Computed column is not physically stored in the table, unless column is marked PERSISTED and it is persisted only if its expression is deterministic.
SQL Server Interview Question & Answer Quiz on CREATE statement
SQL Server Interview Question & Answer Quiz on CREATE statement
SQL SERVER Interview Q & A QUIZ on SUBSTRING()
SQL interview question and answer on Substring function
SQL Server DENSE_RANK()
The DENSE_RANK() is a Ranking function that is used to assign ranks to rows in partitions with no gaps in the ranking values.
SQL RANK()
The RANK() function is a window function that is used to assign a rank to each row in the partition of a result set.
SQL Server ROW_NUMBER()
SQL Row_Number() is a ranking function/window function that is used to assign a sequential integer to each row within a partition of a result set. The row number starts with one for the first row in each partition.
SQL SERVER INTERSECT
The SQL INTERSECT clause is used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement.
SQL SERVER User Defined Table Type and Table Valued Parameters
The Concept of User Defined table type and table valued parameters were introduced in SQL server 2008.
SQL Q & A on SELECT Statement
Q 1 > SELECT Count(1) as Output 1> NULL 2> Error 3> 1 4> Invalid select statement Answer Q 2 > SELECT Count(*) as… Read More »SQL Q & A on SELECT Statement
How to access a data of table from another database in SQL Server?
How to copy a data of table from another database in SQL Server?
Suppose, you have a database1 and table1 and one another database2 and table2 in SQL server.
Now you are required to select data of a table1 of database1 from database2 of table2.
What would be a query for that?
SQL LOGON Trigger
It fires in response to LOGON events of SQL Server is raised .
A LOGON Triggers can be useful in may ways, such as to restrict number of connection made by a Login or to prevent a user from logging-in outside .