Microsoft SQL Server is a relational database management system (RDBMS).
Can you help me with SQL statements to find duplicates on multiple fields? For example, in pseudo code: select count(…
sql sql-server tsql sql-server-2008How can I select data in the same query from two different databases that are on two different servers in …
sql sql-serverIs there a Boolean data type in Microsoft SQL Server like there is in MySQL? If so, what is the …
sql-server types booleanI have an existing query that outputs current data, and I would like to insert it into a Temp table, …
sql sql-server ssmsHow to change the column size of the salary column in the employee table from numeric(18,0) to numeric(22,5)
sql sql-server database tsql alter-tableWhat is the main purpose of using CROSS APPLY? I have read (vaguely, through posts on the Internet) that cross …
sql sql-server performance tsql cross-applyI have developed a query, and in the results for the first three columns I get NULL. How can I …
sql sql-serverI have a stored procedure that I am trying to test. I am trying to test it through SQL Management …
sql-server stored-proceduresWhy doesn't the following work? SELECT name FROM (SELECT name FROM agentinformation) I guess my understanding of SQL is wrong, …
sql sql-server nested subquery queryingI'm writing an SQL Query, where a few of the columns returned need to be calculated depending on quite a …
sql sql-server sql-server-2005 select nested