Top "Sql-server-2008-r2" questions

CASE WHEN statement for ORDER BY clause

I am using SQL Server 2008 R2. I want the priority based sorting for records in a table. So that I …

sql sql-server sql-server-2008-r2

SQL Update with row_number()

I want to update my column CODE_DEST with an incremental number. I have: CODE_DEST RS_NOM null qsdf …

sql-server sql-server-2008-r2 sql-update

Calculating distance between two points (Latitude, Longitude)

I am trying to calculate the distance between two positions on a map. I have stored in my data: Longitude, …

sql sql-server tsql math sql-server-2008-r2

what is numeric(18, 0) in sql server 2008 r2

I found a table with this a column from this data type numeric(18, 0) what is that please? and why does 0 …

sql sql-server sql-server-2008-r2

How to find difference between two columns data?

I have a temp table with two columns of integer data i want to find the difference between two columns …

sql-server tsql sql-server-2008-r2 addition temp-tables

SQL Server - Create a copy of a database table and place it in the same database?

I have a table ABC in a database DB. I want to create copies of ABC with names ABC_1, ABC_2, …

sql sql-server-2008 tsql sql-server-2008-r2

Conversion failed when converting date and/or time from character string in SQL SERVER 2008

I have below SQL. UPDATE student_queues SET Deleted=0, last_accessed_by='raja', last_accessed_on=CONVERT(VARCHAR(24),'23-07…

sql-server sql-server-2008-r2 date-conversion

Create a view with ORDER BY clause

I'm trying to create a view with an ORDER BY clause. I have create it successfully on SQL Server 2012 SP1, …

sql-server database tsql view sql-server-2008-r2

A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)

I am having error while connecting to SQL Server: Details in Stack Trace are: =================================== Cannot connect to ServerName. =================================== A connection …

sql-server sql-server-2008-r2

SQL Server 2008 R2 can't connect to local database in Management Studio

I am using SQL Server 2008 R2 Express. I first installed SQL Server 2008 R2 Express Management Studio and then I installed …

sql-server sql-server-2008-r2