Microsoft SQL Server is a relational database management system (RDBMS).
table1 (id, name) table2 (id, name) Query: SELECT name FROM table2 -- that are not in table1 already
sql sql-server tsqlI am working with a query which contains "CASE" statement within "WHERE" clause. But SQL Server 2008 is giving some errors …
sql sql-server caseWhat is the best way to remove all spaces from a string in SQL Server 2008? LTRIM(RTRIM(' a b …
sql sql-server string whitespace trimI have a string that is up to 3 characters long when it's first created in SQL Server 2008 R2. I would …
sql-server tsqlAfter having created a temporary table and declaring the data types like so; CREATE TABLE #TempTable( ID int, Date datetime, …
sql sql-server temp-tablesI just need to select the first day of the month of a given datetime variable. I know it's quite …
sql sql-server tsql sql-server-2008 datetimeI want to use the ROW_NUMBER() to get... To get the max(ROW_NUMBER()) --> Or i guess …
sql sql-server row-numberWe all know that to select all columns from a table, we can use SELECT * FROM tableA Is there a …
sql sql-server tsqlI have read the stuff on MS pivot tables and I am still having problems getting this correct. I have …
sql sql-server pivot pivot-tableI have this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. What is the best way to …
sql sql-server sql-server-2005 sql-server-2008