Uniqueidentifier not working in stored procedure?
I’m trying to establish a NEWID() (copy) and getting error that uniqueidentifier is incompatible with int – what am I doing wrong?
Prevent Insert in stored procedure from being rolled back by caller
I created a stored procedure with an insert like this:
Should I create a reference table to run a stored procedure for specific values to run at specific period of time?
I have a stored procedure where I want to select ‘TransType = ‘100” at certain times of the day and then run the same procedure to run for ‘TransType !=’100’ at other times during the day.
Self join to compare rows of table?
We are using SQL Server 2017 for our document management application. In our application one document can have many versions. Access can be given to users at revision level. We store user access information in DOCUMENT_ACL table.
SQL Server : stored procedure insert errors
I have a question about stored procedure insert errors.
Assign values to a variable from String SQL Query with in a stored procedure
I have an existing stored procedure which takes the Source and Target table names as a Varchar argument and does some complex logics. My requirement is to use the Source table’s column1 and with that value build a concatenated output. Ex.,