Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
Eg: CREATE PROCEDURE test (@i_Year INT, @i_Month INT) BEGIN DECLARE @v_date DATE; SET @v_date = <need to assign 1st day of the input month/year i.e, '20140101'> END Input values passed to the stored procedure: @i_Year = 2014 @i_Month = 1 Below is what I figured out: SELECT CONVERT(DATE, (CONVERT(VARCHAR,@v_Year)+CONVERT(VARCHAR,@v_Month)+'01') )
|export all data from one table to multiple text files||4||69|
|T-SQL Stored Procedure - Search multiple tables (Single column) for similar values||7||38|
|Auditing with Temporal Tables||4||17|
|SQL query to summarize items per month||5||27|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!