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
3,630 total views, 1 views today
Home ยป
sql server tips and tricks
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
1,307 total views
Change the column name and data type of result set of stored procedure
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
Enable Dark theme in SQL Server Management studio
How to get dark theme for SQL Server Management studio?
By default it is hidden in SQL Server management studio, you can quickly check by following below steps.
29,252 total views, 4 views today
Displaying Emoji in SQL Server
In SQL Server we can create a database, table and write T-SQL query using emoji.
Here we will create a table and then insert few records into table.
6,607 total views, 2 views today