Recent questions tagged tsql

0 votes

632 views

1 answer

How do I check if a year is a leap year? I have this code: declare @year int set @year = 1968 SELECT ... YEAR' END Expected result: LEAP YEAR See Question&Answers more detail:os...

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

0 votes

564 views

1 answer

tsql - Does SQL Server wrap Select...Insert Queries into an implicit transaction?

When I perform a select/Insert query, does SQL Server automatically create an implicit transaction and thus treat ... wrapped in a transaction? See Question&Answers more detail:os...

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

0 votes

765 views

1 answer

tsql - Rounding down decimal numbers in SQL Server 2008

I read all rounding functions of T-SQL like Round, Floor, and Ceil, but none of them has rounded down decimal ... .g. 142600 ==> 143000)? See Question&Answers more detail:os...

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

0 votes

490 views

1 answer

tsql - How to use BULK INSERT when rows depend on foreign keys values?

My question is related to this one I asked on ServerFault. Based on this, I've considered the use of ... good practices nevertheless. =) See Question&Answers more detail:os...

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

0 votes

481 views

1 answer

tsql - GROUP BY WEEK with SQL

I have the following: http://sqlfiddle.com/#!6/226ae/1 I'm trying to now add one row for each week of ... 's the best way to accomplish this? See Question&Answers more detail:os...

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

0 votes

506 views

1 answer

tsql - How to debug SQL Server T-SQL in Visual Studio 2012

How does one debug a T-SQL stored procedure in a multi-tier application in Visual Studio 2012? To be ... VS 2012 No Application Debugging See Question&Answers more detail:os...

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

0 votes

615 views

1 answer

tsql - Efficient way to convert second to minute and seconds in sql server 2005

Suppose I have 90 seconds. If I want to display the result in terms of minutes and second, I do it by using ... to do such a conversion? Thanks See Question&Answers more detail:os...

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

0 votes

528 views

1 answer

tsql - Create a nullable column using SQL Server SELECT INTO?

When I create a temp table using a select into in SQL Server, is there a way to specify that a column ... 't see how you specify nullability. See Question&Answers more detail:os...

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

0 votes

571 views

1 answer

tsql - T-SQL CTE materializing techniques not working on SQL Server 2012

I have to use the following techniques to materialized my CTEs and increase the view performance: WITH CTE AS( ... this things are not valid? See Question&Answers more detail:os...

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

0 votes

458 views

1 answer

tsql - Is there a "Default Order By Column" in SQL Server?

When I execute a query like SELECT col1, col2, col3 FROM table, it gets sorted by the primary key ... unintuitive, but just wondering anyway. See Question&Answers more detail:os...

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

0 votes

479 views

1 answer

tsql - How do I add the identity property to an existing column in SQL Server

In SQL Server (in my case, 2005) how can I add the identity property to an existing table column using T-SQL ... alter column bar identity(1,1) See Question&Answers more detail:os...

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

0 votes

543 views

1 answer

tsql - generate structured (xml) document from hierarchical table data (T-SQL)

I have a table like this (simplified): ID | Name | Parent --------------------------------- 1 ... of the task, I added the DDL for the table See Question&Answers more detail:os...

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

0 votes

695 views

1 answer

tsql - SQL Server - Include NULL using UNPIVOT

UNPIVOT will not return NULLs, but I need them in a comparison query. I am trying to avoid using ISNULL the ... ) ) AS unpvt Any alternatives? See Question&Answers more detail:os...

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

0 votes

647 views

1 answer

tsql - SQL Server uses high CPU when searching inside nvarchar strings

Check out the following example. It shows that searching within a unicode string (nvarchar) is almost eight times as ... elapsed time = 6911 ms. See Question&Answers more detail:os...

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

0 votes

830 views

1 answer

tsql - Format number as percent in MS SQL Server

I am trying to simply format a number as a percent with two decimal places. If it is 37 divided by 38 ( ... any function that would be helpful. See Question&Answers more detail:os...

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

0 votes

509 views

1 answer

tsql - What characters are valid in an SQL Server database name?

We're going to provide our clients with a tool that (among other things) creates a new SQL Server database, ... SQL Server's actual behavior? See Question&Answers more detail:os...

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

0 votes

502 views

1 answer

tsql - Rename SQL Azure database?

How can i rename the database in sql Azure? I have tried Alter database old_name {MODIFY NAME = new_name} but ... in SQL Azure or not? See Question&Answers more detail:os...

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

0 votes

526 views

1 answer

tsql - How do I get the month and day with leading 0's in SQL? (e.g. 9 => 09)

DECLARE @day CHAR(2) SET @day = DATEPART(DAY, GETDATE()) PRINT @day If today was the 9th of December, the above ... do I go about doing this? See Question&Answers more detail:os...

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

0 votes

712 views

1 answer

tsql - using the TSqlParser

I'm attempting to parse SQL using the TSql100Parser provided by microsoft. Right now I'm having a little ... PrintStatement(sstmnt); } } See Question&Answers more detail:os...

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

0 votes

702 views

1 answer

tsql - How to truncate string using SQL server

i have large string in SQL Server. I want to truncate that string to 10 or 15 character Original string this is test ... string. this is ...... See Question&Answers more detail:os...

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

0 votes

666 views

1 answer

tsql - LINQ: Group by month and year within a datetime field

I have a table with a datetime field. I want to retrieve a result set grouped by the month/year combination and ... wouldn't say that works... See Question&Answers more detail:os...

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

0 votes

608 views

1 answer

tsql - Determine SQL Server Database Size

SQL Server 2005/2008 Express edition has the limitation of 4 GB per database. As far as I known the database ... how to get the database size? See Question&Answers more detail:os...

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

0 votes

453 views

1 answer

tsql - Fully automated SQL Server Restore

I'm not very fluent with SQL Server commands. I need a script to restore a database from a .bak file and move ... I'm pretty new to SQL Server. See Question&Answers more detail:os...

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

0 votes

525 views

1 answer

tsql - What is the T-SQL syntax to connect to another SQL Server?

If I need to copy a stored procedure (SP) from one SQL Server to another I right click on the SP in SSMS ... way from me to accomplish this. See Question&Answers more detail:os...

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

0 votes

483 views

1 answer

tsql - Best way to work with transactions in MS SQL Server Management Studio

Let's say I have an SQL statement that's syntactically and semantically correct so it executes. In Management Studio ... (in a separate query?) See Question&Answers more detail:os...

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

0 votes

574 views

1 answer

tsql - Select IN on more than 2100 values

How can you do a select in on more than 2100 values? <cfquery name="result.qryData"> SELECT sub_acct_no, .. ... new many fields being passed in. See Question&Answers more detail:os...

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

0 votes

501 views

1 answer

tsql - Getting a query to index seek (rather than scan)

Running the following query (SQL Server 2000) the execution plan shows that it used an index seek and Profiler ... left them out for brevity See Question&Answers more detail:os...

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

0 votes

495 views

1 answer

tsql - SQL Server 2008 - split multi-value column into rows with unique values

In a SQL Server 2008 database, I have a column with multiple values separated by semi-colons. Some values contain ... .value stuff is magic. O_o See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags