Tags » SQL

DB can’t be accessed from other machines.

For e.g.:- <<PC-NAME>>DB can’t be accessed from other machines.

Solution

Start Menu>sql server configuration

Change db browser to automatic

Check for TCP connection

Open Properties… 31 more words

SQL SERVER - Error: Msg 245 - Conversion failed when converting the varchar value 'Inactive' to data type int

Using CASE statements is something I see a lot of developers use. They use it in complex environments and I have been fortunate to troubleshoot and look at code blocks that run for pages using the standard CASE statements. 369 more words

SQL Authority

Open Data: .CSV and SQL Queries

For the open data task we have been asked to find a publicly available data set and convert it into a useful format that can be viewed on Google Earth. 476 more words

Uni Work

SQL Database Administrator (SQL Server and Postgres)

Arts Alliance Media

Location: Hammersmith
Hours: 40 (9am-6pm)
Job Type: Contract (rolling)

Company Overview

Arts Alliance Media (AAM) is a global leader in digital cinema software and services. 810 more words

All Jobs

Software Test Engineer

Arts Alliance Media

Location: Hammersmith
Hours: 40 (9am-6pm)
Job Type: Permanent

Company Overview

Arts Alliance Media (AAM) is a global leader in digital cinema software and services. 612 more words

All Jobs

Handling Duplicate Records in SQL

This happens a lot (to me at least :) ) so I decided to make a note here!

Following SQL script will allow you to SELECT duplicate records in a given table. 100 more words

Source Code &amp; Example