Recent questions tagged tsql

0 votes

795 views

1 answer

tsql - Create a SQL query to retrieve most recent records

I am creating a status board module for my project team. The status board allows the user to to set their ... ? Any help would be appreciated. See Question&Answers more detail:os...

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

0 votes

960 views

1 answer

tsql - How to get N rows starting from row M from sorted table in T-SQL

There is a simple way to get top N rows from any table: SELECT TOP 10 * FROM MyTable ORDER BY MyColumn Is ... e 3d and 4th rows are returned. See Question&Answers more detail:os...

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

0 votes

878 views

1 answer

tsql - Generating random strings with T-SQL

If you wanted to generate a pseudorandom alphanumeric string using T-SQL, how would you do it? How would you ... dashes, and slashes from it? See Question&Answers more detail:os...

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

0 votes

887 views

1 answer

tsql - When do I need to use Begin / End Blocks and the Go keyword in SQL Server?

Can someone tell me when and where I need to use begin and end blocks in SQL Server? Also, what exactly does the Go keyword do? See Question&Answers more detail:os...

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

0 votes

752 views

1 answer

tsql - How do you change the datatype of a column in SQL Server?

I am trying to change a column from a varchar(50) to a nvarchar(200). What is the SQL command to alter this table? See Question&Answers more detail:os...

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

0 votes

929 views

1 answer

tsql - What is the difference between SQL, PL-SQL and T-SQL?

What is the difference between SQL, PL-SQL and T-SQL? Can anyone explain what the differences between these ... each would be relevantly used? See Question&Answers more detail:os...

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

0 votes

741 views

1 answer

tsql - How to use an Alias in a Calculation for Another Field

Does anybody know if there is a way to replicate the method used in this question of using the alias of a sub ... for any help you can provide. See Question&Answers more detail:os...

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

0 votes

876 views

1 answer

tsql - How can I determine in SQL Server if a dateTime range overlaps another

We have eg. following table | ID | startDateTime | endDateTime | +----+---------------------+-- ... to produce the correct statement ... :( See Question&Answers more detail:os...

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

0 votes

834 views

1 answer

tsql - Using Aliases in Where Clause or an Alternative Option?

How do I get this to work, it works without the Where Clause, otherwise with the Where clause, i get the obvious ... (N) Where City is NOT Null See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

tsql - How to pivot table with T-SQL?

How to convert table from this format: Id | Data |Section ------------------------------------------ 1 |1AAA ... -------- 3 |3AAA |..... |3CCC | See Question&Answers more detail:os...

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

0 votes

986 views

1 answer

tsql - Isoweek in SQL Server 2005

In SQL Server 2008 the isoweek can be found with this: SELECT datepart(iso_week, getdate()) Before SQL Server ... of finding a good solution. See Question&Answers more detail:os...

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

0 votes

958 views

1 answer

tsql - Getting week number off a date in MS SQL Server 2005?

Is it possible to create an sql statement that selects the week number (NOT the day of week - or the day ... the week number given a date? See Question&Answers more detail:os...

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

0 votes

842 views

1 answer

tsql - How to Round a Time in T-SQL

I'me looking for a function that would receive a time and would round it to the next/previous hour / half-hour / quarter / minute. See Question&Answers more detail:os...

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

0 votes

901 views

1 answer

tsql - How to insert default values in SQL table?

I have a table like this: create table1 (field1 int, field2 int default 5557, field3 int default 1337, field4 ... column when I insert a row? See Question&Answers more detail:os...

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

0 votes

941 views

1 answer

tsql - T-SQL - function with default parameters

I have this script: CREATE FUNCTION dbo.CheckIfSFExists(@param1 INT, @param2 BIT = 1 ) RETURNS BIT AS BEGIN IF EXISTS ... Why does it not work? See Question&Answers more detail:os...

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

0 votes

818 views

1 answer

tsql - In SQL Server, what does "SET ANSI_NULLS ON" mean?

The definition says: When SET ANSI_NULLS is ON, a SELECT statement that uses WHERE column_name = NULL returns ... employees WHERE Region = NULL See Question&Answers more detail:os...

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

0 votes

812 views

1 answer

tsql - T-SQL loop over query results

I run a query select @id=table.id from table and I need to loop over the results so I can exec a store procedure ... do this in a T-SQL script? See Question&Answers more detail:os...

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

0 votes

875 views

1 answer

tsql - How to get week number of the month from the date in sql server 2008

In SQL Statement in microsoft sql server, there is a built-in function to get week number but it is the week of ... the month in MS SQL SERVER. See Question&Answers more detail:os...

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

0 votes

804 views

1 answer

tsql - How do I exclude Weekend days in a SQL Server query?

How do I exclude values in a DateTime column that are Saturdays or Sundays? For example, given the following data: ... 00:00' -- Monday Thanks! See Question&Answers more detail:os...

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

0 votes

929 views

1 answer

tsql - How do I sort a VARCHAR column in SQL server that contains numbers?

I have a VARCHAR column in a SQL Server 2000 database that can contain either letters or numbers. It depends on ... best way to achieve this? See Question&Answers more detail:os...

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

0 votes

788 views

1 answer

tsql - Understanding SQL Server LOCKS on SELECT queries

I'm wondering what is the benefit to use SELECT WITH (NOLOCK) on a table if the only other queries affecting ... Versus a SELECT WITH (NOLOCK)? See Question&Answers more detail:os...

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

0 votes

715 views

1 answer

tsql - Dynamic Sorting within SQL Stored Procedures

This is an issue that I've spent hours researching in the past. It seems to me to be something that should ... just the lead code monkey. :) See Question&Answers more detail:os...

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

0 votes

833 views

1 answer

tsql - Scheduled run of stored procedure on SQL server

Is it possible to set up somehow Microsoft SQL Server to run a stored procedure on regular basis? Question&Answers:os...

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

0 votes

791 views

1 answer

tsql - Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)

I'm using MS SQL 2008 R2, have three tables with following schema: Table 1: Contains workshift info for each worker ... wrong? How can I get the info that way? Question&Answers:os...

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

0 votes

883 views

1 answer

tsql - SQL Server: How to select all days in a date range even if no data exists for some days

I have an app that needs to show a bar graph for activity over the last 30 days. The graph needs to show all ... easier way to do it in SQL Server. Thanks much Question&Answers:os...

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

0 votes

835 views

1 answer

tsql - SQL Server: Difference between PARTITION BY and GROUP BY

I've been using GROUP BY for all types of aggregate queries over the years. Recently, I've been ... functionality, or are they something different entirely? Question&Answers:os...

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

0 votes

911 views

1 answer

tsql - Getting the minimum of two values in SQL

I have two variables, one is called PaidThisMonth, and the other is called OwedPast. They are both results of ... MIN function works on columns, not variables. Question&Answers:os...

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

0 votes

761 views

1 answer

tsql - What is a "batch", and why is GO used?

I have read and read over MSDN, etc. Ok, so it signals the end of a batch. What defines a batch? I don't see ... ] SET [CountryCode] = 'PT' WHERE code = 'PT' Question&Answers:os...

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

Categories

Just Browsing Browsing

Most popular tags