GROUP BY a column with NULLs - social.msdn.microsoft.com
Jun 26, 2008 · When comparing the NULL value to anything using the T-SQL "=" operator the result is always FALSE, even when comparing NULL to NULL. When grouping by a column …
Dynamically checking job status with T-SQL
Dec 5, 2018 · In SQL Server 2008, is there a way to check the status of a job using T-SQL? I have tried several variations of the following but none of them seem to work: EXEC
How to implement OOP in sql server - social.msdn.microsoft.com
Jan 28, 2014 · T-SQL is declarative, much like any other flavour of SQL you'll find. If you really want to work with database modelling with (for instance) objective C, I'd recommend SQLite …
How To Calculate WTD,MTD,YTD in T-SQL?
Dec 3, 2012 · I have a requirement lets say i.e to create the MTD,WTD sales for a column based on the given date.I can do it in MDX because we have the date cals defined but i dont know …
Extract Phone numbers from a line feed text column and show it in …
Sep 8, 2014 · Now I need t-sql query to show above source data into 3 columns by extracting phone numbers from each line feed.. new t-sql query output should look like this...
How to do token in T-SQL Stored Proc? - social.msdn.microsoft.com
Nov 8, 2007 · Now I have a string: "ab,cd,ef,", and I would like to use SQL to token this string to a string array like "ab" "cd" "ef". Then I want to do a loop to insert these values into a table like: …
ClickOnce WinForm application - How can I apply a number of T …
Jan 25, 2007 · How do I programmatically run a number of T-SQL Scripts against a SQL Server Express database? I am connecting to the database using a user instance connection.
Delete a File in T-SQL - social.msdn.microsoft.com
Jan 10, 2018 · T-SQL is just a language which operate on database instead of file system, SQL Server can only call other methods like cmdshell and CLR to do that. Why do you want to do it …
T-SQL Equivalent - social.msdn.microsoft.com
Mar 8, 2010 · So I am assuming that you want a SQL Server equivalent of the above mentioned Oracle statement.
POSTING TIPS - Code, Images, Hyperlinks, Details
Oct 1, 2014 · When you're posting a question - please search the forum first! If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below. If you want to show us what …