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 »
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
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
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.
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.