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 management studio
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 Default Constraint
The DEFAULT constraint is used to provide a default value for a columns, when the INSERT INTO statement does not provide a specific value to columns.