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 4956 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 4996 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 4889 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 5040 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 4999 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 4997 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 4869 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 4896 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 4842 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 4874 times