Recent questions tagged sql-server

0 votes

670 views

1 answer

sql-server - 如何在SQL中从DateTime格式获取时间？(How to get Time from DateTime format in SQL?)

I want to get only Time from DateTime column using SQL query using SQL Server 2005 and 2008 Default output: (我想使用SQL Server ... 02-09 14:10:00 14:10 ask by Jig12 translate from so...

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

0 votes

726 views

1 answer

sql-server - 如何使用TSQL获取数据库中所有表的列表？(How do I get list of all tables in a database using TSQL?)

在SQL Server上的特定数据库中获取所有表名的最佳方法是什么？ ask by Ray Vega translate from so...

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

0 votes

865 views

1 answer

sql-server - 如何检查SQL Server表中是否存在列？(How to check if a column exists in a SQL Server table?)

I need to add a specific column if it does not exist. (如果它不存在，我需要添加一个特定的列 )I have something like the following, but ... 如何检查SQL Server数据库表中是否存在列？) ask by Maciej translate from so...

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

0 votes

614 views

1 answer

sql-server - 如何从子查询中消除外部引用(How to eliminate outer reference from subquery)

I have a query as: (我有一个查询：) SELECT DISTINCT A2P.p_year [Year], A2P.aid [CoAuthor] FROM sub_aminer_author2paper A2P ... 不想在CoAuthor列中显示Author ) ask by maliks translate from so...

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

0 votes

767 views

1 answer

sql-server - T-SQL CASE语句返回不同的过滤器(T-SQL CASE statement returning a different filter)

I have a column named TimeSlots that holds a twelve hour range of dates, 7:00:00 thru 19:00:00 . (我有一个名为列TimeSlots保存日期的十 ... be done? (如何才能做到这一点？) ask by StanB13 translate from so...

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

0 votes

698 views

1 answer

sql-server - 如何在SQL中从DateTime格式获取时间？(How to get Time from DateTime format in SQL?)

I want to get only Time from DateTime column using SQL query using SQL Server 2005 and 2008 Default output: (我想使用SQL Server ... 02-09 14:10:00 14:10 ask by Jig12 translate from so...

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

0 votes

670 views

1 answer

sql-server - 如何使用TSQL获取数据库中所有表的列表？(How do I get list of all tables in a database using TSQL?)

在SQL Server上的特定数据库中获取所有表名的最佳方法是什么？ ask by Ray Vega translate from so...

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

0 votes

801 views

1 answer

sql-server - 如何检查SQL Server表中是否存在列？(How to check if a column exists in a SQL Server table?)

I need to add a specific column if it does not exist. (如果它不存在，我需要添加一个特定的列 )I have something like the following, but ... 如何检查SQL Server数据库表中是否存在列？) ask by Maciej translate from so...

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

0 votes

828 views

1 answer

sql-server - 如何在SQL Server中创建是/否布尔字段？(How do you create a yes/no boolean field in SQL server?)

从访问数据库转换或一般情况下，创建是/否布尔字段的最佳做法是什么？ ask by leora translate from so...

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

0 votes

802 views

1 answer

sql-server - 使用输出参数执行存储过程？(Execute stored procedure with an Output parameter?)

I have a stored procedure that I am trying to test. (我有一个要测试的存储过程 )I am trying to test it through SQL Management Studio. ( ... (如何运行带有输出参数的存储过程？) ask by user70192 translate from so...

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

0 votes

933 views

1 answer

sql-server - 如何在SQL Server中创建是/否布尔字段？(How do you create a yes/no boolean field in SQL server?)

从访问数据库转换或一般情况下，创建是/否布尔字段的最佳做法是什么？ ask by leora translate from so...

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

0 votes

833 views

1 answer

sql-server - 使用输出参数执行存储过程？(Execute stored procedure with an Output parameter?)

I have a stored procedure that I am trying to test. (我有一个要测试的存储过程 )I am trying to test it through SQL Management Studio. ( ... (如何运行带有输出参数的存储过程？) ask by user70192 translate from so...

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

0 votes

675 views

1 answer

sql-server - LIKE vs SQL Server上的CONTAINS(LIKE vs CONTAINS on SQL Server)

Which one of the following queries is faster (LIKE vs CONTAINS)? (以下哪个查询更快（LIKE vs CONTAINS）？) SELECT * FROM ... Contains(Column, "test"); ask by user667429 translate from so...

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

0 votes

852 views

1 answer

sql-server - 如何对SSIS包进行单元测试和集成测试？(How do I unit test and integration test my SSIS packages?)

This question mentions two libraries, both of which aren't maintained and one has broken links to the source and documentation. ... 的单元测试数据流) ask by mattrowsboats translate from so...

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

0 votes

637 views

1 answer

sql-server - LIKE vs SQL Server上的CONTAINS(LIKE vs CONTAINS on SQL Server)

Which one of the following queries is faster (LIKE vs CONTAINS)? (以下哪个查询更快（LIKE vs CONTAINS）？) SELECT * FROM ... Contains(Column, "test"); ask by user667429 translate from so...

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

0 votes

925 views

1 answer

sql-server - 如何对SSIS包进行单元测试和集成测试？(How do I unit test and integration test my SSIS packages?)

This question mentions two libraries, both of which aren't maintained and one has broken links to the source and documentation. ... 的单元测试数据流) ask by mattrowsboats translate from so...

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

0 votes

695 views

1 answer

sql-server - SQL Server数据库错误和已知信息(SQL Server database error and known information)

There are many queries of restoring database in SQL Server - below are two: (在SQL Server中有许多恢复数据库的查询-以下是两个：) Query #1 (查询 ... 简单还原和主还原之间有什么区别？) ask by Ahmed Javed translate from so...

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

0 votes

604 views

1 answer

sql-server - SELECT INTO T-SQL中的表变量(SELECT INTO a table variable in T-SQL)

Got a complex SELECT query, from which I would like to insert all rows into a table variable, but T-SQL doesn't allow it. (有一个 ... ...或者告诉我，如果我做错了 ) ask by Indrek translate from so...

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

0 votes

687 views

1 answer

sql-server - SQL Server字符串到日期的转换(Sql Server string to date conversion)

I want to convert a string like this: (我想这样转换一个字符串：) '10/15/2008 10:06:32 PM' into the equivalent DATETIME value ... easier way? (有没有更简单的方法？) ask by JosephStyons translate from so...

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

0 votes

729 views

1 answer

sql-server - SQL Server字符串到日期的转换(Sql Server string to date conversion)

I want to convert a string like this: (我想这样转换一个字符串：) '10/15/2008 10:06:32 PM' into the equivalent DATETIME value ... easier way? (有没有更简单的方法？) ask by JosephStyons translate from so...

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

0 votes

754 views

1 answer

sql-server - SQL Server字符串到日期的转换(Sql Server string to date conversion)

I want to convert a string like this: (我想这样转换一个字符串：) '10/15/2008 10:06:32 PM' into the equivalent DATETIME value ... easier way? (有没有更简单的方法？) ask by JosephStyons translate from so...

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

0 votes

781 views

1 answer

sql-server - 聚簇索引和非聚簇索引实际上是什么意思？(What do Clustered and Non clustered index actually mean?)

I have a limited exposure to DB and have only used DB as an application programmer. (我对DB的接触有限，只使用DB作为应用程序程序员 )I want to know ... ? (有人可以用简单的英语解释吗？) ask by P.K translate from so...

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

0 votes

716 views

1 answer

sql-server - 在SQL Server中使用JOIN更新表？(Update a table using JOIN in SQL Server?)

I want to update a column in a table making a join on other table eg: (我想更新在其他表上进行联接的表中的列，例如：) UPDATE table1 a ... 不正确 ) What is wrong here? (怎么了) ask by Manjot translate from so...

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

0 votes

867 views

1 answer

sql-server - 如何在不重复声明的“INSERT INTO dbo.Blah”部分的情况下插入多行？(How do I insert multiple rows WITHOUT repeating the “INSERT INTO dbo.Blah” part of the statement?)

I know I've done this before years ago, but I can't remember the syntax, and I can't find it anywhere due to ... near the keyword 'VALUES'.) ask by Timothy Khouri translate from so...

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

0 votes

763 views

1 answer

sql-server - 如何将逗号分隔的值拆分为列(How to split a comma-separated value to columns)

I have a table like this (我有这样的桌子) Value String ------------------- 1 Cleo, Smith I want to separate the comma ... fixed extra columns (我只需要两个固定的额外列) ask by Gurru translate from so...

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

0 votes

777 views

1 answer

sql-server - 如何在不重复声明的“INSERT INTO dbo.Blah”部分的情况下插入多行？(How do I insert multiple rows WITHOUT repeating the “INSERT INTO dbo.Blah” part of the statement?)

I know I've done this before years ago, but I can't remember the syntax, and I can't find it anywhere due to ... near the keyword 'VALUES'.) ask by Timothy Khouri translate from so...

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

0 votes

821 views

1 answer

sql-server - 如何将逗号分隔的值拆分为列(How to split a comma-separated value to columns)

I have a table like this (我有这样的桌子) Value String ------------------- 1 Cleo, Smith I want to separate the comma ... fixed extra columns (我只需要两个固定的额外列) ask by Gurru translate from so...

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

0 votes

686 views

1 answer

sql-server - 在SQL Server中使用JOIN更新表？(Update a table using JOIN in SQL Server?)

I want to update a column in a table making a join on other table eg: (我想更新在其他表上进行联接的表中的列，例如：) UPDATE table1 a ... 不正确 ) What is wrong here? (怎么了) ask by Manjot translate from so...

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

Categories

Just Browsing Browsing

Most popular tags