...

Hi, I would like to write CTE Query to get expected results. Here are the table and expected results. 1) declare @t table(zid int,dok varchar(100),stawka int) insert into @t values (1,'333',10), (2,'333',10), (3,'333',20), (4...

The challenge is to find the Tax Code based on Price. There is a table called "LineItems" that have Invoice Number and Price. There is another table "Sales" that contains Invoice Number, Amount and Tax Code. Each sales amount is...

...

...

...

One of my office colleague recently asked me why we are not able to generate ALTER Table script from SSMS. If we right click on the table and choose "Script Table As" ALTER To option would be disabled or Greyed out. Is it a bug?...

Despite knowing that backups are the key tools when it comes to dealing with all forms of database corruption, I never bothered to take routine backups....

...

In this post we would see one of the bad practices very commonly followed by developers which is risky as without our knowledge data would have got truncated before getting inserting into the table!...