saurabhhooda

Saurabh has worked globally for telecom and finance giants in various capacities. After working for a decade in Infosys and Sapient, he started his first startup, Lenro, to solve a hyperlocal book-sharing problem. He is interested in the product, marketing, and analytics. His latest venture Hackr.io recommends the best vue.js tutorial and online programming courses for every programming language. All the tutorials are submitted and voted by the programming community.

Blogs

A New Word: Lackout

By

lackout – n. the sudden awareness that you’re finally over someone, noticing that the...

Delta Lake over Spark Connect

By

All Spark Connect Posts I have just finished an update for the spark connect dotnet...

Generating Random Strings with GenAI

By

One of the things I’ve been experimenting with in AI is taking things other...

Read the latest Blogs

Forums

Merge techniques

By purushotham.k9

In Azure SQL DB, i want to merge records from the staging table to...

SSRS error: The Value for the image 'Image1' has a constant value...

By sgmunson

Full error message: SSRS error: The Value for the image 'Image1' has a constant...

XML_COMPRESSION for existing tables

By zoggling

We are in the process of upgrading to SQL Server 2022 and would like...

Visit the forum

Question of the Day

Adding Defaults

I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.

ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE()
GO
ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate
GO
What happens when I run these two batches?

See possible answers