Category: SQL Server

How to display Row Numbers in the results in SQL Query ?

Published on September 2, 2016 by abundantcode

Filed under SQL Server

Last modified September 2, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 2704 times

How to return the SHA1 hash value of a string in SQL Server ?

Published on September 1, 2016 by abundantcode

Filed under SQL Server

Last modified September 1, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 2763 times

How to get the table structure in SQL Server ?

Published on September 1, 2016 by abundantcode

Filed under SQL Server

Last modified September 1, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 2829 times

How to return rows in random order in SQL Server ?

Published on September 1, 2016 by abundantcode

Filed under SQL Server

Last modified September 1, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 2761 times

Specify a port number when connecting to SQL Server in Management Studio

Published on September 1, 2016 by abundantcode

Filed under SQL Server

Last modified September 1, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 2768 times

Sleep Command in SQL Server

Published on August 31, 2016 by abundantcode

Filed under SQL Server

Last modified August 31, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 2690 times

How to remove a column from an existing table in SQL Server?

Published on August 31, 2016 by abundantcode

Filed under SQL Server

Last modified August 31, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 2703 times

How to copy tables from a database to another in SQL Server ?

Published on August 29, 2016 by abundantcode

Filed under SQL Server

Last modified August 29, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 2767 times

How to get all the column names of a table in SQL Server ?

Published on August 29, 2016 by abundantcode

Filed under SQL Server

Last modified August 29, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 2795 times

Inserting a line break in the NVARCHAR data in SQL Server

Published on August 29, 2016 by abundantcode

Filed under SQL Server

Last modified August 29, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 2761 times