sql server tips and tricks
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
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
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.
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.