Recent questions tagged TSQL

0 votes

561 views

1 answer

tsql - SQL Server: Number of 8K Pages Used by a Table and/or Database

Can I use T-SQL to show me the number of 8K pages that a table is using to store its rows? Also, can I ... of 8K pages that a database is using? See Question&Answers more detail:os...

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

0 votes

631 views

1 answer

tsql - How to get time part from SQL Server 2005 datetime in 'HH:mm tt' format

How to get time part from SQL Server 2005 datetime in HH:mm tt format E.g. 11:25 AM 14:36 PM See Question&Answers more detail:os...

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

0 votes

469 views

1 answer

tsql - ALTER TABLE [dbo].[MyTable] CHECK CONSTRAINT [FK_MyTable_SomeCol]

If I script a table with a foreign key, it looks like this: GO ALTER TABLE [dbo].[MyTable] WITH ... ] CHECK CONSTRAINT [FK_MyTable_SomeCol])? See Question&Answers more detail:os...

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

0 votes

574 views

1 answer

tsql - T-SQL Column alias on computed column - Invalid column name

I'm using an alias to refer to a computed column. Here is a snippet from the actual code I'm trying to make ... , how would I make this work? See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

tsql - Split/explode comma delimited string with Sybase SQL Anywhere

UPDATE: Someone marked this question as duplicate of How do I split a string so I can access item x. But ... function will return as result. See Question&Answers more detail:os...

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

0 votes

477 views

1 answer

tsql - Querying a SQL Server 2008 table to find values in a column containing Unicode characters

I've run into a problem in a project I'm working on: some of the string values in a specific SQL Server 2008 ... how many rows need to be fixed? See Question&Answers more detail:os...

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

0 votes

527 views

1 answer

tsql - Difference between INNER JOIN and WHERE?

First Query: Select * from table1 inner join table2 on table1.Id = table2.Id Second Query: Select * from ... performance which should one use? See Question&Answers more detail:os...

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

0 votes

665 views

1 answer

tsql - SQL Server Management Studio - Finding all non empty tables

Is there a way for SQL Server Management Studio Express How to list all the non empty tables? I have over 100 ... go through and check for data. See Question&Answers more detail:os...

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

0 votes

529 views

1 answer

tsql - T-SQL Trigger Update

I have a table with 3 fields [ID, Name, LastUpdated]. LastUpdated has a default value of "GetDate() so it ... Trigger event (and so on) ? See Question&Answers more detail:os...

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

0 votes

500 views

1 answer

tsql - Return row of every n'th record

How can I return every nth record from a sub query based on a numerical parameter that I supply? For example, ... record for a paging control. See Question&Answers more detail:os...

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

0 votes

514 views

1 answer

tsql - Return row of every n'th record

How can I return every nth record from a sub query based on a numerical parameter that I supply? For example, ... record for a paging control. See Question&Answers more detail:os...

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

0 votes

565 views

1 answer

tsql - SQL Server: Effects of using 'WITH RECOMPILE' in proc definition?

My understanding of the WITH RECOMPILE option with stored procedures is generally limited to using the clause with a single ... .. proc code ... See Question&Answers more detail:os...

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

0 votes

491 views

1 answer

tsql - How to trace T-SQL function calls

I'm trying to debug a rather complicated formula evaluator written in T-SQL UDFs (don't ask) that recursively ( ... find any sollution at all... See Question&Answers more detail:os...

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

0 votes

746 views

1 answer

tsql - sql - how to split fullname into first and last name

If I have a table with a column that contains fullnames such as : fullname ------------ Joe Bloggs Peter Smith ... -------- Bloggs Smith Jones See Question&Answers more detail:os...

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

0 votes

511 views

1 answer

tsql - Code to read xlsx sheet into a table in a SQL Server database

I am trying to read data from an Excel sheet (.xlsx file) into a table in SQL Server 2008. I want this to be ... me? I have admin rights. ~TIA See Question&Answers more detail:os...

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

0 votes

678 views

1 answer

tsql - FullText search with CONTAINS on multiple columns and predicate - AND

I have a search table with, say, 4 columns of text data to search. I do something like this: SELECT * ... put the property names into that. See Question&Answers more detail:os...

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

0 votes

566 views

1 answer

tsql - How to count the number of times a character appears in a SQL column?

For a user logging table I have in a SQL database, I track the some of the parameters off of a ... where RequestedReportParams Like '%,%' See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

tsql - Dynamic SQL Not Converting VARCHAR To INT (shouldn't anyway)

I'm receiving an error: Conversion failed when converting the varchar value 'INSERT INTO TableRowCount (IntFieldID, ... 't sound correct). See Question&Answers more detail:os...

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

0 votes

701 views

1 answer

tsql - T-Sql xml query with namespace

This is a follow up question to T-Sql xml query If I add a namespace to xml data, nothing is returned again. ... 100 | AAAA-BBBB-CCCCC-DDDDD | See Question&Answers more detail:os...

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

0 votes

634 views

1 answer

tsql - T-SQL VARCHAR(MAX) Truncated

DECLARE @str VARCHAR (MAX); SELECT @str = COALESCE(@str + CHAR(10), '') + 'EXECUTE CreateDeno ' + ... suggestion would be warmly appreciated. See Question&Answers more detail:os...

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

0 votes

613 views

1 answer

tsql - SQL: avoiding hard-coding or magic numbers

Question: What are some other strategies on avoiding magic numbers or hard-coded values in your SQL scripts or ... WHERE [IsAcknowledged] = 1) See Question&Answers more detail:os...

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

0 votes

579 views

1 answer

tsql - Why does EXCEPT exist in T-SQL?

I was just reading about EXCEPT and INTERSECT in the MSDN Library and came across this example of how to use ... WHERE W.ProductID IS NULL ? See Question&Answers more detail:os...

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

0 votes

603 views

1 answer

tsql - Select all empty tables in SQL Server

How to get the list of the tables in my sql-server database that do not have any records in them? See Question&Answers more detail:os...

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

0 votes

538 views

1 answer

tsql - How to turn one column of a table into a csv string in SQL Server without using a cursor

I want to return the results of select Column from Table into a comma separated string using SQL Server. ... handle very large result values. See Question&Answers more detail:os...

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

0 votes

649 views

1 answer

tsql - Return multiple values from a SQL Server function

How would I return multiple values (say, a number and a string) from a user-defined function in SQL Server? See Question&Answers more detail:os...

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

0 votes

612 views

1 answer

tsql - How do I use T-SQL's Case/When?

I have a huge query which uses case/when often. Now I have this SQL here, which does not work. (select ... of them, probably even more cases. See Question&Answers more detail:os...

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

0 votes

825 views

1 answer

tsql - SQL Server PRINT SELECT (Print a select query result)?

I am trying to print a selected value, is this possible? Example: PRINT SELECT SUM(Amount) FROM Expense See Question&Answers more detail:os...

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

0 votes

689 views

1 answer

tsql - What is the T-SQL To grant read and write access to tables in a database in SQL Server?

What is the exact SQL to assign db_datareader and db_datawriter roles to a user in SQL Server? The user name is MYUSER and the database is MYDB. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags