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 4389 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 4457 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 4571 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 4475 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 4483 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 4381 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 4408 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 4506 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 4532 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 4487 times