Export data from SQL Server to an Excel file
Sometimes you need to export data from SQL Server tables, views or the result of any T-SQL query into excel file, reason could be anything… Read More »Export data from SQL Server to an Excel file
Home » SQL SERVER »
SQL SERVER
SQL Server Tutorials| Basics & Advance Concepts | Interview Question & Answer Series | SQL Server Tricks & Tips
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
How to fetch alphanumeric string from table
Assume you have a table containing alphabetic, numeric, alphanumeric strings, and special characters, and you need to retrieve only the alphanumeric strings from that data.… Read More »How to fetch alphanumeric string from table
FORMAT Function DAX
FORMAT function is a Power BI text function in DAX, which converts a value to text according to the specified format. Syntax FORMAT(<value>, <format_string>) value… Read More »FORMAT Function DAX
Difference between clustered index and non clustered index
SQL Server indexes are used by queries to find data values quickly in tables and views. Basically it speed up the queries performance. You can… Read More »Difference between clustered index and non clustered index
SQL NULLIF
SQL NULLIF expression compares two expression and returns a null value if the two specified expressions are equal, else it returns the first expression. NULLIFÂ … Read More »SQL NULLIF
SET STATISTICS IO
SQL STATISTICS IO is a set statement , when it is enabled it causes SQL Server to display information about the amount of disk activity… Read More »SET STATISTICS IO
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
SQL IS NOT NULL
The IS NOT NULL is used in SQL to find a non-NULL value. It returns TRUE if a non-NULL value is found, otherwise it returns… Read More »SQL IS NOT NULL
How to Update from Select Statement in SQL
SQL Server update statement is used used to modify an existing records in a table, you can also update records in table based on some… Read More »How to Update from Select Statement in SQL
Insert multi language data in table
Sometimes, you need to store multi language or multilingual data in any table column. Inserting a multilingual data into column without following some basics rules,… Read More »Insert multi language data in table
SQL Random Number
SQL RAND function is a mathematical function which returns a pseudo-random float value from 0 through 1, exclusive or a random value within any range.… Read More »SQL Random Number
How to insert the result of a stored procedure into table
Sometimes, you want to store the result of a stored procedure into table or temp table instead of returning the output. Storing output of stored… Read More »How to insert the result of a stored procedure into table
SQL Delete TOP
SQL delete statement is used to delete records from table based on specific conditions which are specified in where clause. Delete statement can also be… Read More »SQL Delete TOP
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
Date and Time Conversions in SQL Server
Sometimes you need to format a date in specific format such as format a date time string YYYY-MM-DD hh:mm:ss. mmm to date MM:DD:YY. SQL Server… Read More »Date and Time Conversions in SQL Server
Get Row Counts for all tables in SQL Server
Sometime you are required to validate the row counts for each tables in database. So getting a row counts for each tables either through using… Read More »Get Row Counts for all tables in SQL Server
Object_Id Metadata Function
Object_ID is a SQL Server Metadata function which returns the database object identification number of a schema-scoped object. It can not be used for object… Read More »Object_Id Metadata Function
Dynamic Data Masking in SQL Server
Dynamic data masking also known as DDM is a security feature in SQL Server which helps you to prevent the access of unauthorize users to… Read More »Dynamic Data Masking in SQL Server
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