Category: SQL Server
How to display Row Numbers in the results in SQL Query ?
If you want to return the row number as a part of your results in the SQL Query , you can use the ROW_NUMBER function and specify the ORDER BY clause to it as shown in this blog post. How to display Row Numbers in the results in SQL Query ?
How to return the SHA1 hash value of a string in SQL Server ?
SQL Server provides a function HashBytes function that returns the SHA1 , MD2 , MD4 and few other hash value of the specified input. How to return the SHA1 hash value of a string in SQL Server ? Just pass the ‘SHA1’ as the first parameter and the input as second parameter value to the HashBytes function to get the SHA1 hash value.
How to get the table structure in SQL Server ?
To get the details of the table structure along with the indexes and the constraints , you can use the sp_help command as demonstrated in this blog post. How to get the table structure in SQL Server ?
Specify a port number when connecting to SQL Server in Management Studio
There are times when you want to connect to a SQL Server instance that is running on a different port number than default port (1433). How to specify a port number when connecting to a SQL Server instance in SQL Management Studio ? Just specify the SQL Server instance that you are connecting to along with the port number with comma as delimiter. For example…
Sleep Command in SQL Server
If you are looking at writing a query to sleep for or WAIT for a certain amount of time before the query execution can begin , you can use the WAITFOR command. For example , if you want to wait for 1 minute , the query or command for the same will be this.
How to return rows in random order in SQL Server ?
Do you want to return rows sorted in random order , here’s how you do it. How to return rows in random order in SQL Server ? This example demonstrates how to sort the Employee table and display the results in random order.
How to remove a column from an existing table in SQL Server?
Use the DDL (Data definition language) query to remove a column from an existing table in SQL Server. How to remove a column from an existing table in SQL Server? ALTER command will allow the user to remove a column from the table. Syntax to remove the column from the table. ALTER TABLE <tablename> DROP COLUMN <columnname>; For example , assume that you have a…
How to copy tables from a database to another in SQL Server ?
There are times when you may want to copy the tables from one database to another along with the data or import data along with the schema in SQL Server. One of the ways to do this is using the SQL Server Import/Export Wizard. How to copy tables from a database to another in SQL Server ? 1. Launch SQL Server Import and export wizard…
How to get all the column names of a table in SQL Server ?
If you have a scenario where you need to get all the column names of a table in SQL Server , you can query the database’s INFORMATION_SCHEMA.Columns table by specifying the table name. How to get all the column names of a table in SQL Server ? Here’s a query to demonstrate how to achieve this. This would display all the columns of the table…
Inserting a line break in the NVARCHAR data in SQL Server
For inserting the character break in a data of type NVARCHAR in SQL Server , you can use CHAR(13). Inserting a line break in the NVARCHAR data in SQL Server Inserting a line break in the NVARCHAR data in SQL Server
FOLLOW US
