SSMS keyboard shortcuts
As a SQL Server developer you must know some keyboard shortcuts while working on SQL Server Management Studio, although it is not necessary to know… Read More »SSMS keyboard shortcuts
Home »
SSMS
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
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
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
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 color of Automatic Matching of Syntax Pairs in SQL Server Management Studio
Automatic matching of syntax pairs is a feature of SQL Server Management Studio which gives you immediate feedback on whether syntax elements that must be… Read More »Change the color of Automatic Matching of Syntax Pairs in SQL Server Management Studio
Generate Database Scripts With Data in SQL Server
You can generate a database scripts including the schema and the data by using the Generate Scripts option available in SQL Server Management Studio (SSMS),… Read More »Generate Database Scripts With Data in SQL Server
SQL Vulnerability Assessment
SQL Vulnerability Assessment (VA) is an easy to use tool that you can use to identify, track, and remediate potential database vulnerabilities. The VA service… Read More »SQL Vulnerability Assessment
SQL Server Download links
Following are the links to download SQL Server 2019 and Database sample files
SQL Server Verbose Truncation Warnings
SQL Server Verbose Truncation Warnings
Sometimes we receives data truncation error in SQL Server such as “String or binary data would be truncated” and it does not specify exact source of error in terms of Database name, table name , column name and truncated values.
SQL Server @@Version
SQL Server @@Version is a configuration function that returns system and build information for the current installation of SQL Server. SYNTAX @@Version Return Type of… Read More »SQL Server @@Version
SP_RENAME in SQL Server
SQL Server SP_NAME is SQL Server Database Engine stored procedure that is used to Changes the name of a user-created object in the current database. This object can be a table, index column or alias datatype.
Troubleshooting Database Mail in SQL Server
Troubleshooting Database Mail
If you are not getting Database Mail after configuring it , you need to got through few more step to fix it.
SQL SERVER SET DATEFORMAT
SQL Server SET DATEFORMAT is used to set the order of the month, day, and year date parts for interpreting date character strings.
SQL Server @@ERROR
SQL Server @@ERROR is a global variable that returns an error number if the last statement encountered an error but we have to trace it within just after the next line where the actual error occurred, otherwise, it will reset to 0.
SQL Server Create SCHEMA
A Schema in SQL Server is a collection of database objects associated with a database.
How to create a custom shortcuts in SQL Server
How to create a custom shortcuts for stored procedures in SQL Server ?
SSRS shared data source
A shared data source is a set of data source connection properties that can be referenced by multiple reports, models, and data-driven subscriptions that run on a Reporting Services report server .
SQL Server Interview Question & Answer Quiz on CREATE statement
SQL Server Interview Question & Answer Quiz on CREATE statement