Home
Q&A
Education
Technology
Credit
General
Health
Insurance
Questions
Ask a Question
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
sql-server
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
sql-server
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
sql-server
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
sql-server
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
sql-server
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
sql-server
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
sql-server
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
#azure-sql-database
#server
#linked-server
sql-server
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
sql
sql-server
powerbi
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
sql
sql-server
select
user-defined-functions
Page:
« prev
1
2
3
next »
...