Rank = RANKX( All('First Inspections'), -- Use ALL on the Provider ID column to remove any filters applied to it CALCULATE( COUNTROWS('First Inspections'), -- Count the rows for each Provider ID ALLEXCEPT('First Inspect...
DECLARE @sqlQuery NVARCHAR(MAX) DECLARE @outputFilePath NVARCHAR(MAX) SET @sqlQuery = 'SELECT * FROM [AdventureWorks2016].[dbo].[AWBuildVersion]' SET @outputFilePath = N'E:\programming\File.csv' DECLARE @bcpCommand VARCHAR(2000) SET @bcpCommand = ...
create proc Get_full_details (@customer_id INT) as Select * from [AdventureWorks2016].[Sales].[Customer] where [CustomerID] = @customer_id; GO
/Code // insert at the end of an aray using System; namespace MyApplication { class Program { static void Main() { // Inserting at the end of an Array int[] intArray = new int[6]; // Make a variable to store the length because .length is based off ca...
-- How many columns are there in this table? select * from sys.syscolumns where id = OBJECT_ID('Production.Location') SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'YourTableName' AND COLUMN_NAME LIKE '%my_column%'; -- most encourag...
--nesting example DECLARE @Var1 INT = 15 IF @Var1 % 5 = 0 BEGIN IF @Var1 % 3 = 0 BEGIN print 'the number is divisible by 3 and 5' END ELSE BEGIN print 'the number is divisible by 5' END END ELSE BEGIN IF @Var1 %...