DATEDIFF(hour, start_date, end_date) will give you the number of hour boundaries crossed between start_date and end_date. If you need the number of fractional hours, you can use DATEDIFF at a higher resolution and divide the result: DATEDIFF(second, start_date, end_date) / 3600.0 The documentation for DATEDIFF is available on MSDN: http://msdn.microsoft.com/en-us/library/ms189794%28SQL.105%29.aspx
CONVERT(VARCHAR(32), HashBytes(‘MD5′, ’[email protected]’), 2)
You can do both in one query using the OVER clause on another COUNT select count(*) RecordsPerGroup, COUNT(*) OVER () AS TotalRecords from temptable group by column_1, column_2, column_3, column_4
To get more information about the cause of an “ODBC–call failed.” error we can loop through the DBEngine.Errors collection and see if there are other messages that might be a bit more descriptive. For example, with the code qdf.Connect = strConnectionString qdf.SQL = ” EXEC [dbo].[SAMPLE_TEST]” qdf.ReturnsRecords = True On Error GoTo oops Set rst … Read more
Here are some scripts I wrote for reverse engineering SQL server schemas. They may be of some use. Also, as a general interest they give some examples of how to get various bits of information out of the data dictionary. I’ve added an MIT license below to make permission-to-use explicit and for some basic no-implicit-warranty … Read more
I believe there are three different cases that you have to worry about: strings (anything that requires quotes): ”” + replace(@string, ””, ”””) + ”” names (anything where quotes aren’t allowed): quotename(@string) things that cannot be quoted: this requires whitelisting Note: Everything in a string variable (char, varchar, nchar, nvarchar, etc.) that comes from user-controlled … Read more
I was able to fix it by running: net stop winnat net start winnat Source: https://github.com/docker/for-win/issues/9272#issuecomment-776225866
This is a part of the INSERT syntax INSERT INTO TableName DEFAULT VALUES Read more here: https://learn.microsoft.com/en-us/sql/t-sql/statements/insert-transact-sql
N.B. – this question and answer relate to the 2000 version of SQL Server. In later versions, the restriction on INSERT INTO @table_variable … EXEC … were lifted and so it doesn’t apply for those later versions. You’ll have to switch to a temp table: CREATE TABLE #tmp (code varchar(50), mount money) DECLARE @q nvarchar(4000) … Read more
For SQL Server, if using a newer version, you can use select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=’tableName’ There are different ways to get the schema. Using ADO.NET, you can use the schema methods. Use the DbConnection‘s GetSchema method or the DataReader‘sGetSchemaTable method. Provided that you have a reader for the for the query, you can … Read more