Easy way to reseed identity column ? TIP #77
Sometimes, we may require to reseed identity column of a table due to various reason.
For example we have deleted a...
2014-12-20
504 reads
Sometimes, we may require to reseed identity column of a table due to various reason.
For example we have deleted a...
2014-12-20
504 reads
Although it is a old feature for those who knows ORACLE but for SQL server developers it is a new...
2014-12-10
260 reads
When you do SQL Server maintenance one of important aspect is available space on server drive because your SQL SERVER...
2014-12-06
329 reads
You are reading this post just because of two reason
1) You are curious whether it is possible or not...
2014-11-20
274 reads
Sometimes it may require that you don’t know what will be output of a stored procedure ? what kind of result...
2014-11-19
446 reads
This is very interesting feature and I recently come to know this awesome feature.
Lets understand this by an example below...
2014-11-14
317 reads
Suppose, sometimes you just need entry in the table with all the default values.
For example you have a Student...
2014-11-10
205 reads
Suppose, We are working on a stored procedure in which some complex operation is going. We are fetching some value...
2014-11-09
278 reads
Hello friends,
Many times it happened with me I forgot the instance name of SQL Server.
So here is a small trick...
2014-11-07
290 reads
Recently , one of my friends shared that some interviewer asked him a question “How to copy table structure only from...
2014-11-03
729 reads
Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Hi folks I have two tables, both with a NAME, START and END fields...
I am in the process of migrating from MySQL to SQL Server. I have...
I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers