I need to connect to a SQL server 2000 Database from SQL server 2008. SQL server 2000 properties: ServerName:WinxpV1\\SQL2k
The OUTPUT 开发者_StackOverflow中文版clause is compatible with SQL Server 2005 but not SQL Server 2000.
Is it possible to have a case statement within a case\'s when true then statement? case when true then
I want to create a dynamic command using @sqlQuery variable.I\'ve also declared a cursor (example: @myCursor).How can I \"SET @myCursor = CURSOR FO开发者_运维百科R @sqlQuery\".The syntax I just noted
I have a result set as below: ItemExpectedQtyReceivedQtyShort Item0130455 Item0120455 Item0240382 item03509010
I have the following table GroupID SequenceName 110Mary 125Jack 117Jill 23Peter 242Henry 250Paul The following query returns a row with the next lowest sequence (10) for a given group (1) and a giv
Here is my query: DECLARE @MM INT -- Current month DECLARE @开发者_运维问答DD INT -- Current date
This question already has answers here: Closed 11 years ago. Possible Duplicate: Pivot using SQL Server 2000
Short Version: Does anyone know of a way --inside a SQL 2000 trigger-- of detecting which process modified the data, and exiting the trigger if a particular process is detected?
I have a bunch of orderIds \'1, 18, 1000, 77 ...\' that I\'m retreiving from a nvarchar(8000).I开发者_JAVA百科 am trying to parse this string and put the id into a temporary table.Is there a simple an
加载中,请稍侯......