Recent questions tagged TSQL

0 votes

540 views

1 answer

tsql - SQL Server check resultant data type of expression

Normally I would put the data type into a temp table and inspect the table column type, e.g. select 1.0 N ... What is the name of this function? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

563 views

1 answer

tsql - SQL Server - synchronizing 2 tables on 2 different databases

I have 2 tables with same schema on 2 different databases on the same server with SQL Server 2008 R2. One ... to achieve the sync. process ? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

537 views

1 answer

tsql - SQL Server Find What Jobs Are Running a Procedure

Is there a way to find out what jobs are using a certain stored procedure? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

576 views

1 answer

tsql - How do I add a “last modified” and "created" column in a SQL Server table?

I'm design a new db schema for a SQL Server 2012 database. Each table should get two extra columns called ... couldn't find the answer yet. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

488 views

1 answer

tsql - How to deploy a existing SSIS Package in sql server 2012?

I am working on SSIS Package .I added one more data flow task to existing ssis package.After complition of ... deploy it to Development server? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

580 views

1 answer

tsql - How to write a foreach in SQL Server?

I am trying to achieve something along the lines of a for-each, where I would like to take the Ids of a ... error: Invalid column name 'idx'. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

562 views

1 answer

tsql - Use set in a case statement in SQL Server

I would like to set a variable in SQL Server using a CASE statement. For example: DECLARE @UNITY VARCHAR(5) DECLARE ... ' THEN @AUX = 'M3' END See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

564 views

1 answer

tsql - Full outer join not returning all rows?

I have a table that contains multiple records for multiple dates. I am trying to see the ... p.BusinessDataDate = @PreviousBusinessDataDate) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

706 views

1 answer

tsql - SQL SERVER - Group records by n minutes interval

I have a table like this: [SDate - DateTime] [Value - Decimal] 2010-11-16 10:32:22 1 2010-11-16 10:58: ... . I am using SQL SERVER 2012. Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

537 views

1 answer

tsql - SQL Split function

I'm looking for a way to do this ... SELECT FirstName, LastName, Split(AddressBlock, ' ', 1), Split( ... the function needs to be reusable. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

674 views

1 answer

tsql - T-SQL: How to join @variable tables (another try)

I know, this is a duplicate question of this question. But i encountered the same problem and maybe i can provide ... why i get this error? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

467 views

1 answer

tsql - Sql Server Precision Crazyness

I am having an issue with sql server precision. I have the following queries: DECLARE @A numeric(30,10) ... help would be much appreciated! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

tsql - FIND_IN_SET() equivalent in SQL Server

SELECT * FROM users WHERE uid IN (SELECT doctors FROM MainPage WHERE Valid=1) users table uid INT Mainpage table ... achieve the same result ? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

649 views

1 answer

tsql - Converting / Casting an nVarChar with Comma Separator to Decimal

I am supporting an ETL process that transforms flat-file inputs into a SqlServer database table. The code is ... Thank you for your ideas. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

760 views

1 answer

tsql - Mod negative numbers in SQL just like excel

I'm having trouble replicating the mod function in SQL sever. In excel, mod (-3, 7) = 4. But in SQL, ... wrong, or does SQL do mod differently? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

571 views

1 answer

tsql - Row_Number simulation in Sql server 2000

I have a sample input table as Declare @input TABLE(Name VARCHAR(8)) INSERT INTO @input(Name) values('Aryan') ... Joseph 9 Marya 10 Vicky 16 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

606 views

1 answer

tsql - Alternate synonym in SQL Server in one transaction

I am new to Transact SQL programming. I have created a stored procedure that would drop and create an ... suggestion to the solution. Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

533 views

1 answer

tsql - SQL query to convert date ranges to per day records

Requirements I have data table that saves data in date ranges. Each record is allowed to overlap previous record(s) ... defined by record ID = 2 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

567 views

1 answer

tsql - SQL Server varbinary bigint with BitConverter.ToInt64 values are different

I save my long value in a SQL Server table as varbinary(max): var savedValue = BitConverter.GetBytes(longValue ... Have that issue any solution? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

486 views

1 answer

tsql - Can UNION ALL be faster than JOINs or do my JOINs just suck?

I have a Notes table with a uniqueidentifier column that I use as a FK for a variety of other tables in ... code that is slowing things down? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

431 views

1 answer

tsql - how to prevent SQL Injection

I am using stored procedures. In order to save time, I made some generic procedures that uses dynamic sqlin ... sql injection with this code? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

508 views

1 answer

tsql - Read Dynamics NAV Table Metadata with SQL

I would like to be able to read the Dynamics NAV 2013 Table Metadata directly from the SQL Server database ... usable format would be helpful. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

449 views

1 answer

tsql - SQL server: convert rows to columns

I have a table with columns sales(int), month(int). I want to retrieve sum of sales corresponding to every ... for for each column(month). See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

524 views

1 answer

tsql - SQL Server truncates decimal points of a newly created field in a view

I have a view in SQL server, something like this: select 6.71/3.41 as NewNumber The result is 1.967741 ( ... result or give more accurate one? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

503 views

1 answer

tsql - How to see progress of running SQL stored procedures?

Consider the following stored procedure.. CREATE PROCEDURE SlowCleanUp (@MaxDate DATETIME) AS BEGIN PRINT ' ... running stored procedure? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

609 views

1 answer

tsql - What special characters are allowed in T-SQL column name?

I would like to know what special characters are allowed to be used in column name in T-SQL, MSSQL. So I know I ... [] to refer to this column? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

540 views

1 answer

tsql - Round to .5 or 1.0 in SQL

I'm looking to round values like 2.3913 -> 2.5 4.6667 -> 4.5 2.11 -> 2 How can I manage this in SQL? Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

379 views

1 answer

tsql - SQL Server error handling: exceptions and the database-client contract

We're a team of SQL Servers database developers. Our clients are a mixed bag of C#/ASP.NET, C# and Java web ... ours are all 50,000 of course) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags