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 5215 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 5267 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 5393 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 5330 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 5307 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 5200 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 5256 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 5332 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 5351 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 5310 times