Skip to content
Home » SSMS

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

 2,618 total views

How to fetch alphanumeric string from table

Assume that you have a table which contains alphabetic, numeric, alphanumeric string, and special characters and you are asked to fetch only alphanumeric string from… Read More »How to fetch alphanumeric string from table

 20,589 total views,  10 views today

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

 2,977 total views

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

 6,564 total views

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

 7,108 total views,  5 views today

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

 9,537 total views,  1 views today

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.

 4,771 total views,  3 views today

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

 784 total views,  1 views today

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.

 6,219 total views,  1 views today

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.

 950 total views