SQL Server
If you want to return the current date time in SQL Server , the easiest way to do it is...
- SQL Server
- December 3, 2024
By default , the SQL Server listens to the port number 1433 and assume that if your server name is...
- SQL Server
- December 3, 2024
There are times when you might have a column names in your SQL Server database table that might looks like...
- SQL Server
- December 2, 2024
There are times when you want to add an column with a default value to the existing table in SQL...
- SQL Server
- December 1, 2024
You might have a scenario where you want to find out how much space that each of the tables in...
- SQL Server
- December 1, 2024
Here’s another tip where you could export the query result to .csv file in SQL Server. How to Export the...
- SQL Server
- November 30, 2024
SQL Server provides an function ISNULL if the value placed in the 2nd parameter if the first parameter passed to...
- SQL Server
- November 29, 2024
Below is a sample SQL query that demonstrates how to count the number of tables in a SQL Server database...
- SQL Server
- November 28, 2024
Last few weeks , I have been playing around with this cool tool called Open DBDiff . As the name...
- SQL Server
- November 28, 2024
To check if the table exists in a database in SQL Server , you can use the INFORMATION_SCHEMA view. How...
- SQL Server
- November 27, 2024
When we want to specify a alias for a column in SQL Query , we tend to use the double...
- SQL Server
- November 27, 2024
Microsoft SQL Server comes in different versions that includes SQL Server Enterprise SQL Server Business Intelligence SQL Server Standard SQL...
- SQL Server
- November 26, 2024
If you want to pause the execution of the code block until a specific time is reached , you can...
- SQL Server
- November 26, 2024
Assume a scenario where you are trying to get the records from the table where some of the records contains...
- SQL Server
- November 25, 2024
When we work on SQL Server query , we use the AS keyword to specify the alias name for a...
- SQL Server
- November 24, 2024
Below are few points that differentiate the DELETE and TRUNCATE command. Sl. No. DELETE TRUNCATE 1 This removes the rows...
- SQL Server
- November 22, 2024
You can create a Database Backup in SQL Server easily by using the SQL Scripts. Just specify the BACKUP DATABASE...
- SQL Server
- November 21, 2024
You might want to sort the results of an query in a different order from the traditional sort (Ascending/Descending) order....
- SQL Server
- November 18, 2024
Assume that you have a table named “Employee” in MS SQL Server and you would like to delete the top...
- SQL Server
- November 17, 2024
There are times when you don’t have a specific value to find but you might have to use the general...
- SQL Server
- November 17, 2024
Categories
- .NET
- AI
- Alternatives
- Analytics
- Android
- Apple
- ASP.NET
- Azure
- Blog
- Blogging
- Business
- C Programming
- C++
- Coaching
- Content Writing
- CSharp
- Data
- DB2
- Delphi
- Design / Branding
- Finance
- General
- Guide
- How To
- Interview Q&A
- Java
- JavaScript
- List
- Microsoft Office
- MySQL
- news
- Oracle
- OutSystems
- PowerShell
- Python
- Software Testing
- SQL Server
- Sybase
- Uncategorized
- Visual Studio
- Windows
Tags
c#
C# Compiler Errors
C# Programs
C++ examples
C programs
csharp
DB2 Errors
Delphi Errors
Download
Excel
Excel 2016
Excel Automation
excel functions
excel tips
excel tutorials
Excel VBA
Functions in Excel
how to
HPE NonStop SQL/MX
Java examples
Microsoft
Microsoft Excel
MS Office
MySQL Errors
Oracle Errors
Outlook Errors
PolarDB for PostgreSQL
Python examples
python programs
SQL Server
SQL Server Errors
Sybase Error Message
tips
tricks
troubleshoot
Visual Studio
Visual Studio 2012
Win32
Windows 11
Windows 11 tutorials
Windows BSOD Errors
windows phone
windows phone 8
Windows Store
wp8
