Questions tagged [tsql]
Transact-SQL is the Microsoft extension of ANSI standard SQL.
8
questions with no upvoted or accepted answers
1
vote
1
answer
57
views
How to take the column name dynamically with dates
I have column name with dates which comes from a table and changes from current month to last 41 month. and i have to write the column name again and again to reach the desired output. Is there any ...
1
vote
1
answer
210
views
Unable to change schema of a Publication Database using TSQL (Ready-roll): being forced stop replication
I am trying to apply schema changes using T-SQL (using Ready-Roll database source control tool with Octopus Deployment) to a Publication database however it is forcing me stop Replication for the ...
0
votes
0
answers
633
views
php 7 on Fedora 27: Uncaught Error: Call to undefined function sqlsrv_connect()
I have installed sqlsrv & pdo_sqlsrv per
https://github.com/Microsoft/msphpsql/tree/PHP-7.0-Linux
I created a test program that works perfectly from the command line but not when viewed in a web ...
0
votes
1
answer
391
views
Interpreting a Deadlock Log / XDL file
I've generated the following XML + XDL:
<deadlock>
<victim-list>
<victimProcess id="processc1eaf13468" />
</victim-list>
<process-list>
<process id="...
0
votes
1
answer
23
views
Convert into multiple data ranges
I have employee data link below
This is one example in the file a have multiple lines. Initial input can have more than 2 lines for each employee but convert logic will be the same.
Thank you for ...
0
votes
1
answer
1k
views
T-SQL Code to backup database with multiple files failed
I'm trying to write an automated script that will allow me to backup the database to a NAS with multiple files. I just started to use T-SQL.
My objective is to automatically calculate the size of the ...
0
votes
1
answer
207
views
Creating a SQL Server 2005 User Login to Backup and Restore on a Single Database
I have a SQL Server 2005 database server with multiple databases on the server. I need to create a user login 'test1'with the following restrictions:
Login 'test1' should be owner of database 'ABC' ...
0
votes
1
answer
50
views
Automatically drop FK's to re-create a table and then automatically put the FK's back
I have a number of incidents where SSMS tells me table recreation is required, even for something simple like making a column nullable. If this table is referenced by FK's, I would ideally like to ...