SQL notes and SQL notes

SQL notes and SQL notes

------- Select * Table by pressing Ctrl + 3.
USE [NB]
GO
/*Object: StoredProcedure [dbo]. [SP_Select] script Date: 05/28/2015 21:46:25*/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create Proc [dbo]. [SP_Select]
@ OName varchar (100)
As
Declare @ Str Varchar (1000 ),
@ Dbname varchar (40)
Set @ dbname = db_name ()
Set @ Str = 'select * from' + @ dbname + '. dbo.' + @ OName
Exec (@ Str)

------- Select the table name and configure it to Ctrl + 8 to query all the column names of the table.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create proc [dbo]. [sp_syscolumns]-Exec sp_syscolumns 'eemploye'
@ Object NVARCHAR (1000)
As
/*
Function: obtains the items of all columns of an object (mainly for tables)
Remark: Create By Deam L 2013/4/7
*/
Begin
Set nocount on

Declare @Name NVARCHAR (1000)Select  @Name= Isnull(@Name +',', '')+name From syscolumns Where id=object_id( @Object)Print   @NameSet nocount off

END