Problem with Trigger insert
I am trying to get this trigger to insert the correct data. I seem to be losing the scope_identity …
![SQL]()
SQL
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data....
Read more- 11K Content
- 1.1K Contributors
Expert Spotlight
SQL Server Consultant
Database Expert with 15+ years experience (SQL, Access, Power BI).
Leading Experts In
Troubleshooting Solution
Article
Dynamic Pivot Procedure for SQL Server
by Mark Wills
PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
Article
SQL Server Database Health Checks
An introduction article to discuss about the various Database states for troubleshooting or health check purposes. More articles will be available in this series to see how to troubleshoot each and every states described in this article.
Video
Repair Corrupt SQL Database with Stellar Phoenix SQL Database Repair Software
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues…
Post
So excited for SQL Server 2017. …
So excited for SQL Server 2017.
…
…
Troubleshooting Solution
Export from SQL to EXCEL with long string
hi,
This is the code I use to export SQL output to Excel
I need to have an Excel with same number of …
This is the code I use to export SQL output to Excel
I need to have an Excel with same number of …
Troubleshooting Solution
SQL Server Query for detecting, eliminating outliers from data set.
I am having trouble making a SQL Server query for eliminating outliers in a data set (using median …
Troubleshooting Solution
Need help creating SQL for MS Access Query
I need help improving the performance of a query in MS Access which takes about two minutes to run.…
Troubleshooting Solution
Need help migrating from Access to SQL Server
I have a number of date fields in my Access database. In some cases I store just the date, in other …
Article
Estimate Execution time of DBCC CHECKDB
A clarification of some common doubts about DBCC CHECKDB for Database Administrators. Includes estimated times to repair database corruption's in production databases.
Post
It's interesting to see where the SQL co-creator sees …
It's interesting to see where the SQL co-creator sees similarities between SQL and NoSQL. …
Troubleshooting Solution
Need to see which columns got changed from previous entry.
Hi Experts,
I have a table with following columns
ScheduleID long
CaregiverID int
PatientID int
VisitDate …
I have a table with following columns
ScheduleID long
CaregiverID int
PatientID int
VisitDate …
Troubleshooting Solution
Need help converting a MS Access query to MS SQL - Definitely need an expert for this one.
I need to upsize from Access to SQL as my App has become too complex for Access..
so I'm trying to …
so I'm trying to …
Troubleshooting Solution
I have a sql function which I would like to see if I can produce the same results in an oracle query without using a function
I have this function in sql where it can determine the format of a string and would like to be able …
Troubleshooting Solution
Need to surpress meesages when IGNORE_DUP_KEY = ON
I thought I had a solution to this yesterday but it turns out that indexing with
IGNORE_DUP_KEY = ON …
Video
Query data with no SQL code (1)
Section 01: Introduction and Requirements of this course
Course: This course is …
Course: This course is …
Video
Query data with no SQL code (2)
Section 02: Introduction to SQL Server Management Studio
Course: This course is …
Course: This course is …
Video
Query data with no SQL code (3)
Section 03: Working in SQL Server Management Studio
Course: This course is created …
Course: This course is created …
Video
Query data with no SQL code (4)
Section 04: Introduction to Query Designer
Course: This course is created for …
Course: This course is created for …
Video
Query data with no SQL code (5)
Section 05: Usage of Criteria Pane of Query Designer
Course: This course is created…
Course: This course is created…
Explore solutions and more
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.