Questions about ssms
Read more about ssms
python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
Why is the same value being return in this SQL While Loop?
I am using Microsoft SQL Server, and attempting to insert some data into a temporary table. I then want to use a while loop to loop through each row in the temporary table. I do no want to use a curso...
Lloyd Thomas
Votes: 0
Answers: 2
How to drop column that already have default value in existing table?
I've added a column to an existing table like that:
ALTER TABLE [dbo].[tbl_exampleTable]
ADD ExampleName varchar(1) NOT NULL DEFAULT('w');
It successfully added this column.
But when I try to...
dimitri
Votes: 0
Answers: 0
How to create a pre-packaged deployment script for a database project?
I have a DB project in Visual Studio and I need to deploy it to a remote system as a pre-packaged script (or similar) as a new database.
The Publish option will generate a .publish SQL script but only...
Mr. Boy
Votes: 0
Answers: 1
Unexpected behavior from CONCAT in sql server with some strange, non null value : the value after it are not added to the result
SELECT CONCAT('a', ISNULL(NameStudent, 'ccc'), 'b') as ShouldEndWithb, NameStudent, LEN(NameStudent) as Length
FROM #Student
There is a strange NameStudent value that gives the result below from thi...
Ant
Votes: 0
Answers: 1