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
2,460 total views, 2 views today
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
1,406 total views
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
1,139 total views
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
1,307 total views
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
6,597 total views, 5 views today
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
4,795 total views
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.
1,624 total views
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.
2,016 total views, 1 views today
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.
2,187 total views, 1 views today
SQL Server Interview Question & Answer Quiz on CREATE statement
1,601 total views
SQL interview question and answer on Substring function
3,936 total views, 1 views today
The DENSE_RANK() is a Ranking function that is used to assign ranks to rows in partitions with no gaps in the ranking values.
1,862 total views
The RANK() function is a window function that is used to assign a rank to each row in the partition of a result set.
1,633 total views, 1 views today
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.
2,372 total views
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.
1,627 total views
The Concept of User Defined table type and table valued parameters were introduced in SQL server 2008.
26,252 total views, 6 views today
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
1,879 total views
A PRIMARY KEY constraint uniquely identifies each record in a table .
1,562 total views
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?
26,601 total views, 6 views today
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 .
1,806 total views