sql-server

相关标签：javascript jquery android 多少钱 iPhone

how to make a UDF in sql for determining month of year?

I want to make a user defined function for calculating the month number from date. But the problem is that I have the months numbered as 1, 2, 3 ... and each month is of 26 days, that makes a total o[详细]

2023-04-12 12:31 分类：问答
SQL server code (UPDATE)

i ha开发者_运维知识库ve a problem of how to update data from table A to table B andmake in horizontal from vertical..example is[详细]

2023-04-12 12:25 分类：问答
SQL: Correctly identify and correct(if possible) names in database

I have a large database of names, and I\'m hoping to identify incorrect capitalization. Right now I\'m using the fo开发者_StackOverflowllowing...[详细]

2023-04-12 12:16 分类：问答
Run stored procedure for each val in array

Can\'t wrap my head around this one.. I have two separate stored procedures, let\'s call them: createTable (takes a varchar userID as input)[详细]

2023-04-12 11:53 分类：问答
How can I join a MS-SQL and MySQL table in a query?

I want to do a join accross a MS-SQL and MySql database. The MS-SQL query generates an index, effectively, and then I want to pull all MySQL records back that match the result of this query. (I could[详细]

2023-04-12 11:53 分类：问答
SQL server Cursor not working ... Any ideas?

I am creating a simple cursor which fetches all the record from a table and for each record it checks for a conditionin another table and updates the first table.[详细]

2023-04-12 11:49 分类：问答
SQL Server Rounding Issue

I\'m using SQL Server 2005. And I\'m using ROUND T-SQL function to round a decimal column value. But it seems that the rounded value is incorrect.[详细]

2023-04-12 11:34 分类：问答
Convert to valid decimal data type

I have a column [Cash] nvarchar(50) that has data that will later be converted to decimal(9,3) during an import process,some of the data is consistent with normal looking numeric valu开发者_如何学编程[详细]

2023-04-12 11:32 分类：问答
How do I rewrite a query to suit a CLUSTERED INDEX?

I just observed that my query: SELECT X.A, X.B, X.GroupName FROM TableA X INNER JOIN TableB Y -- Huge table[详细]

2023-04-12 11:20 分类：问答
DBCC CheckIdent existing tables inserts + 1 - nunit tests are now unpredictable

Have a problem with DBCC CHECKIDENT. I clear out all db tables before my NUnit tests and I need to be able to add a new user by specifying the Id = 1.For this I need to delete all data in the db, then[详细]

2023-04-12 10:41 分类：问答