Questions tagged [tsql]

Transact-SQL is the Microsoft extension of ANSI standard SQL.

8 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
18 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
1answer
209 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
0answers
438 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
1answer
327 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
1answer
22 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
1answer
987 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
1answer
184 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
1answer
48 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 ...