How to make Bootable Pendrive (USB Drive)

Boot a Pendrive
_______________________________

 Boot cmd :

step1: diskpart
step2: list disk
step3: select disk 1
step4: clean
step5: create partition primary
step6: format fs=fat32 quick or format fs=ntfs quick
step7: active
step8: assign
step9: exit
step10: exit

Check if a stored procedure has a specified parameter with a SQL script

INFORMATION_SCHEMA view that you could use is PARAMETERS. This query will list all stored procedures that have such a parameter:


SELECT DISTINCT p.SPECIFIC_NAME
FROM INFORMATION_SCHEMA.PARAMETERS p
WHERE p.PARAMETER_NAME = '@x'

Syntax


SELECT DISTINCT p.SPECIFIC_NAME
FROM INFORMATION_SCHEMA.PARAMETERS p
WHERE p.PARAMETER_NAME = '@Pageno'