Tag: database

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 4172 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 4198 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 4106 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 4242 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 4191 times

How to drop a table if it exists in SQL Server 2014 ?

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 4203 times

How to rename a column 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 4091 times

How to escape a single quote 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 4103 times

How to find the duplicate records on certain fields 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 4064 times

How to get the list of all tables from a SQL Server database ?

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 4099 times