DBCC CHECKDB is executed on the SQL Server database to check the physical and logical integrity of the database’s integral components. These objects include tables,
Category: SQL Server
SQL Server Administration, Development and Maintenance
USE of GO in SQL Server
GO is interpreted by SQL Server utilities as a signal to deliver the current batch of Transact-SQL statements to a SQL Server instance. All statements
Can we convert TIMESTAMP to date time?
The short answer is, NO. Let’s consider the following example. USE testDB GO CREATE TABLE tbOrders ( iOrderID INT IDENTITY(1,1) PRIMARY KEY, dtOrderDate DATETIME, dcPaidAmount
Stored Procedure – RAISERROR
Here’s an example of how to make a user-defined error message and raise it in the event that something goes wrong. — Creating the procedure
SQL Sample Datasets and Assignments
Here is a compilation of earlier blog posts that were relevant to Sample datasets, Sample projects, and Sample assignments. For quick reference only. Â
Hadoop Default Ports
Computers are able to distinguish between various traffic types with the use of ports. A default open port is a port number that is preconfigured
Big Data & SQL 