where Column_name='columnName' and Table_name='TableName'
Begin
End
Microsoft.ACE.OLEDB.12.0
Excel 12.0
SET ARITHABORT OFF
Salary + ( Salary *Id* 0.05 )
Salary + ( Salary *Id* (5/100) )
Salary + ( (Salary/100) *Id * 5 ) )
like isnull(@Name,name)%
@Name ='T%'
FOR XML PATH(''), TYPE).value('.','VARCHAR(max)'), 1, 1, '')
FOR XML PATH(''), TYPE).value('.','VARCHAR(max)'), 1, 0, '')
INFORMATION_SCHEMA.PARAMETERS
Distinct
"select Distinct GroupID From"
Right
Time
isnull(@user_id,NULL)
select @user_id=isnull(@@Identity,0/*non null value like 0*/) from user login
IF EXISTS
If exists(Select * from TableName Where Primarycolumnvalue=@Param)