Microsoft Query cannot run SQL code with a T-SQL variables in it?
Oct 17, 2011 · I am unable to use Microsoft Query to return data from a query that includes T-SQL variables. The weird thing is that Microsoft Query handles the data fine, but then has a …
how to disconnect and clear the user in sys.sysprocesses?
Mar 9, 2012 · Question 0 Sign in to vote SELECT db_name (dbid) as DatabaseName, count (dbid) as NoOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > …
t-sql 2012-Update statement in merge does not work
Jul 31, 2015 · In the following t-sql 2012 merge statement, the insert statement works but the update statement does not work. I know that is true since I looked at the results of the update …
Enterprise t-sql Stored Procs against tables -vs- Views
Sep 17, 2010 · Option 1 - Be sure to optimize your Database design so your application will only require at most 6 joins and used stored procs for queries using proper indexs to gain the most …
Datediff dateformat yyyymmdd Datediff
May 16, 2014 · You can also do this in t-sql and bring the fields as date datatype in report itself. You can use a logic like below SELECT CONVERT (datetime,CAST (datefield AS varchar …
Monitoring Replication using T-SQL - social.msdn.microsoft.com
Jan 23, 2008 · I want to know is it possible to monitor the Replication Agent (if thats the right bit to monitor) using T-SQL.
T-SQL query to find database information on all servers
Nov 9, 2017 · 1. sp_helpdb shows details about growth and more info a separate result set but only when a database name is specified. For all databases it just limits to the first set so I …
how to select from a stored procedure?
Mar 3, 2014 · Please mark as answer, if this has helped you solve the issue. Good Luck :) .. visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
Run SSRS report subscription on demand?
Mar 3, 2014 · What if I run a T-SQL script to modify the subscription schedule information directly in the report database? If possible, would you know where exactly the Schedule information is …
Query zip codes with extra digits - social.msdn.microsoft.com
Sep 17, 2012 · If the format of the zipcode is fixed, you can fomart the zip code using T-SQL like below: Select SUBSTRING(zipcode,1,5)+'-'+SUBSTRING(zipcode,6,4)From TableName