T-SQL (Transact Structured Query Language) is the extension of SQL functionality supported by Sybase ASE and Microsoft SQL Server.
I've been learning Functions and Stored Procedure for quite a while but I don't know why and when I should …
sql sql-server tsql stored-procedures sql-functionI need to remove a highly referenced table in a SQL Server database. How can I get a list of …
sql sql-server tsqlI've a string, @mainString = 'CATCH ME IF YOU CAN'. I want to check whether the word ME is inside @mainString. …
sql-server string tsql stored-procedures sql-server-2005I'm trying to determine the best way to truncate or drop extra decimal places in SQL without rounding. For example: …
sql sql-server tsql roundingI've been using GROUP BY for all types of aggregate queries over the years. Recently, I've been reverse-engineering some code …
sql-server tsql aggregate-functions window-functionsI have a table which I want to get the latest entry for each group. Here's the table: DocumentStatusLogs Table |…
sql tsql sql-server-2005 group-by greatest-n-per-groupI need to search a SQL server 2008 for stored procedures containing where maybe the name of a database field or …
sql-server sql-server-2008 tsql stored-proceduresWhat query can return the names of all the stored procedures in a SQL Server database If the query could …
sql-server tsqlI am trying to achieve something along the lines of a for-each, where I would like to take the Ids …
sql-server tsqlAre disabling and enabling foreign key constraints supported in SQL Server? Or is my only option to drop and then …
sql-server tsql foreign-keys constraints