How do I fix incorrect syntax near SQL Server?
I'm trying to execute the following stored procedure:CREATE PROCEDURE dbo.Compress_taille(@nom_table VARCHAR(64)) AS PRINT @nom_table declare…
2 Answers · 8.6K Views · Answered ✓
Get a modern-day SQL Developer Training that will help you learn the basics of database querying, Microsoft SQL and the best-practices of Database Management to gain confidence with our Online SQL Certification and surmount a trending career field
I'm trying to execute the following stored procedure:CREATE PROCEDURE dbo.Compress_taille(@nom_table VARCHAR(64)) AS PRINT @nom_table declare…
2 Answers · 8.6K Views · Answered ✓
I have just been involved in a project on which I will have to develop a data migration process and a web interface that uses an already existing SQL…
1 Answer · 266 Views · Answered ✓
Alternatively, how did Microsoft make time travel possible? Consider this code: DECLARE @Offset datetimeoffset = sysdatetimeoffset(); DECLARE @UTC…
1 Answer · 1.7K Views · Answered ✓
Installed latest SQL Server. It is listening on port number 62628 according to server log. Why is the port number is not the default of 1433? How to…
1 Answer · 1.4K Views · Answered ✓
can anyone explain to me why this query returns 0.000?SELECT CAST(20/1024 AS NUMERIC(10,3))I am just trying to do a simple conversion of MB to GB.…
1 Answer · 768 Views · Answered ✓
I came across an issue today, and while I was able to fix it, I am unsure what caused the issue to happen. I have a column that is Varchar(20). It is…
3 Answers · 17.0K Views · Answered ✓
I face recently a problem when starting SQL Server Management Studio. As it can't start, I uninstall it. When trying to install it again, I am asked…
1 Answer · 319 Views · Answered ✓
Can I install SQL Server Management Studio 2012 on my desktop to access a database on a SQL Server 2012 instance? If so, where can I find the…
1 Answer · 673 Views · Answered ✓
What ports does SQL Server use on Linux? I want to be sure I'm forwarding the ports required when I run it in a container.
1 Answer · 7 Views · Answered ✓
The message that SQL Server Log File Viewer shows: Login failed for user [User] Error: 18456, Severity: 14, State 38 What it actually means: Failed…
1 Answer · 1.3K Views · Answered ✓
I want to know if composite primary keys are bad practice and if not, in which scenarios is their use beneficial? My question is based on this…
1 Answer · 7 Views · Answered ✓
I'm a bit confused with SQL Server instances. The Instance Name and Instance ID are different properties, yet Instance ID tends to be defaulted to a…
1 Answer · 3.4K Views · Answered ✓
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step SQL Server guides from industry experts
Common SQL Server interview questions, answered
Guides, tips and career advice on SQL Server from JanBask experts.
SQL Server Top 75 SSAS Interview Questions and Answers For Beginners & Experts
Prepare for your SSAS interview with our comprehensive guide featuring 75 top SQL Server Analysis Services interview questions…
SQL Server How to Become a SQL Database Administrator?
How to become a sql database administrator In 2025, discover what these professionals do, explore how much they earn and learn…
SQL Server OLAP vs OLTP: Key Differences, Architectures, Performance & Real-World Examples
Compare OLTP vs OLAP with clear definitions, architecture diagrams, real-world examples, and FAQs. Learn when to use each system…
SQL Server 70+ Most Asked SSIS Interview Questions for Freshers & Experienced
Prepare for your next SQL Server Integration Services (SSIS) interview with our top 70+ SSIS interview questions and answers.…
Pick another topic to find answers, interview questions, and real-world tips.