Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It originated from the Sybase SQL Server codebase, which is why both products use the extension of SQL called Transact-SQL (T-SQL).

learn more… | top users | synonyms (2)

-1
votes
1answer
1k views

how cursor implementations are different for each cursor type in sql server

In Oracle, there are only 2 types of cursor i.e. Implicit and Explicit cursor. Which is easy to understand. But, in SQL Server there are 4 Cursor AFAIK i.e. Static,Dynamic,Forward Only and Scroll. ...
-1
votes
2answers
2k views

Select query having count and variable

I have a table like the one below. I need to form a select query. I'm going to pass a RefID like SELECT SNo FROM Register WHERE RefID = 1 And beside the SNo in the Statement, I need to have ...
-2
votes
1answer
53 views

Process staging table by getting unique rows only [closed]

I have several staging tables where I bulk import data with duplicates and sometimes I upload historical data mixed with real-time data, just importing everything without caring if it is already in ...
-2
votes
1answer
106 views

Sql server sqllogship.exe…full docs?

Are the internals and all the logic of sqllogship documented? Eg so i can manage it directly, without the wizard? Or replace it with my own tool? I find this syntax (which is real, from a live SQL ...
-3
votes
1answer
738 views

Getting number of errors in stored procedure [closed]

I am getting an error in stored procedure as follows: Msg 156, Level 15, State 1, Procedure K2_CHECKENTRYINFILELOG, Line 27 Incorrect syntax near the keyword 'if'. Msg 102, Level 15, State ...
-3
votes
2answers
1k views

How to improve TempDb on RAMDisk showing performance on par with physical hard drive [closed]

Given 2 SQL Server Instances where the second instance is configured with a RAMDisk for tempdb and the following test case. -- Create source data select top(1000000) * /* ~10 cols */ into #t1 from ...
-4
votes
1answer
2k views

SQL Server 2000 to 2008 R2

When I try to restore a database abackup from a SQL Server 2000 to 2008 R2m, I get this error: Actually, I don't quite get it. What does the error actually mean? And how can I solve it?