Recent questions tagged Sql-server

0 votes

Q: How do you lock tables in SQL Server 2005, and should I even do it?

This one will take some explaining. What I've done is create a specific custom message queue in SQL ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 16, 2022 in Education by JackTerrance

0 votes

Q: How to solve "An attempt to attach an auto-named database for file..." SQL error?

I've got a local .mdf SQL database file that I am using for an integration testing project. Everything ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 16, 2022 in Education by JackTerrance

0 votes

Q: Hidden Features of SQL Server

Locked. This question and its answers are locked because the question is off-topic but has historical ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 16, 2022 in Education by JackTerrance

0 votes

Q: Data Comparison

We have a SQL Server table containing Company Name, Address, and Contact name (among others). We regularly ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 16, 2022 in Education by JackTerrance

0 votes

Q: SQL Server Profile - View Parameter Values?

In SQL Server Profile, I have it tracing SP:StmtStarting events. The "TextData" includes information like ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 12, 2022 in Education by JackTerrance

0 votes

Q: In trigger, get values from insert

When I try to create this trigger, I get this exception: The name "SITE_ID" is not permitted in ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Feb 13, 2022 in Education by JackTerrance

0 votes

Q: In trigger, get values from insert

When I try to create this trigger, I get this exception: The name "SITE_ID" is not permitted in ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Feb 13, 2022 in Education by JackTerrance

0 votes

Q: I need to add a linked server to a MS Azure SQL Server

I have tried and tried, and can not get linked. I can connect to the server using SSMS, but can not link to ... = '[password]' GO Select the correct answer from above options...

asked Feb 8, 2022 in Education by JackTerrance

0 votes

Q: SQL reporting invalid syntax when run in Power BI

I have written an SQL script which runs fine when executed directly in SQL Management Studio. However, when entering ... are removed: Select the correct answer from above options...

asked Feb 8, 2022 in Education by JackTerrance

0 votes

Q: SQL User Defined Function Within Select

I have a user defined function in SQL called getBuisnessDays it takes @startdate and @enddate and returns the number of ... WHERE ... Select the correct answer from above options...

asked Feb 8, 2022 in Education by JackTerrance