T-SQL (Transact Structured Query Language) is the extension of SQL functionality supported by Sybase ASE and Microsoft SQL Server.
I can extract the month and day by using Day(Date()), Month(Date()). I can't extract hours, with HOUR(Date()). …
sql tsql datetime sql-server-2005 hourWhat is a "stored procedure" and how do they work? What is the make-up of a stored procedure (things each …
sql sql-server tsql stored-proceduresHow would I return the column names of a table using SQL Server 2008? i.e. a table contains these columns- …
sql sql-server tsqlI want to update two tables in one go. How do I do that in SQL Server 2005? UPDATE Table1, Table2 …
sql sql-server sql-server-2005 tsqlIn SQL I (sadly) often have to use "LIKE" conditions due to databases that violate nearly every rule of normalization. …
sql sql-server oracle tsql plsqlI need to write a T-SQL stored procedure that updates a row in a table. If the row doesn't exist, …
sql sql-server sql-server-2008 tsqlWhich one: datetime datetime2 is the recommended way to store date and time in SQL Server 2008+? I'm aware of differences …
sql sql-server tsql datetime datetime2I'm running some administrative queries and compiling results from sp_spaceused in SQL Server 2008 to look at data/index space …
sql-server tsqlIs it possible to specify a condition in Count()? I would like to count only the rows that have, for …
sql sql-server tsqlI have SQL Server database and I want to change the identity column because it started with a big number 10010 …
sql sql-server tsql sql-server-2008