SQL

Sometimes we may need to insert a row into Table with Default Values and don't want to provide column list. Use below Query: INSERT I...

We can pause and resume any Database Mirroring any time. Pausing mirroring preserves the mirroring state. Sometime pausing is very useful...

CREATE FUNCTION NumToWords_Ver2(@num numeric) RETURNS varchar(1000) AS BEGIN DECLARE @cNum varchar(20) SET @cNum = @num DECLARE @le...

When you're setting up a new MS-SQL connection, you might get the following error: Not associated with a trusted SQL Server connection...

In an MSSQL corruption problem, you might see error messages after running DBCC Checkdb command. Such situations render MDF files inaccessi...