Database

<br />
declare @TblName sysname<br />
<br />
set @tblName = 'Your table name'<br />
<br />
-- show identity col name<br />
select syscolumns.name from sysobjects <br />
inner join syscolumns on sysobjects.id = syscolumns.id <br />
where sysobjects.name = @tblName and syscolumns.status = 0x80<br />
<br />
-- show identity constraint name<br />
select sysobjconstraint.name from sysobjects <br />
inner join sysconstraints on sysobjects.id = sysconstraints.id <br />
left outer join sysobjects sysobjconstraint on sysconstraints.constid = sysobjconstraint.id<br />
where sysobjects.name = @tblName and sysobjconstraint.xtype = 'PK'

<br />
select COLUMNPROPERTY(OBJECT_ID('Table name'), COLUMN_NAME, 'IsIdentity') as IS_IDENTITY <br />
from INFORMATION_SCHEMA.COLUMNS <br />

a) Use the Backup and Restore facility

b) Attach and Detach facility

c) Use Link Server for remote connection

Use the export and import tool (exp.exe and imp.exe)

SELECT column1
FROM MyTable
WHERE FREETEXT (column1, 'sale')

SELECT * 
FROM MyTable 
WHERE CONTAINS(column1,'sal*')

I are troll

SELECT m.id,m.name,
SUBSTRING(m.[Name],LEN(m.[Name])-CHARINDEX(',',m.[Name])+1,LEN(m.[Name])) AS Part

FROM mytable m

'aaa,bbb,ccc'

,ccc

'A,B,C'

,C

AQQQQQ,BFFFFF,CYYYYY

,CYYYYY

ALTER PROCEDURE SP_UPDATELASTCOLUMN 
	-- Add the parameters for the stored procedure here
	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	-- VARIABLE DECLARATION SECTION

		DECLARE @CNTRECORDS INT
		DECLARE @NAMEVALS VARCHAR(50)
		DECLARE @I INT

	-- SETTING THE INITIAL VALUES
		SET @I  = 1
     
        SELECT @CNTRECORDS = COUNT(*) FROM TBLEXTRACT_STRING

		SELECT ROW_NUMBER() OVER (ORDER BY ID) AS ROWID,* INTO #TEMP FROM TBLEXTRACT_STRING

		
		WHILE ( @I <= @CNTRECORDS )

			BEGIN
					SELECT @NAMEVALS = [NAME] 
					FROM #TEMP
					WHERE ROWID = @I
					
					UPDATE TBLEXTRACT_STRING

					SET PART = (SELECT TOP 1 STRINGVAL FROM DBO.FNSPLIT(@NAMEVALS,',') 
								ORDER BY COUNTER DESC)

					WHERE ID  = (121 + @I)					
					SET @I = @I + 1		
			END

		DROP TABLE #TEMP
END
GO

ALTER FUNCTION [dbo].[fnSplit] 
(@oldstring as varchar(100),@delimeter as varchar(1))
RETURNS @mytab table(counter int,stringval varchar(100)) 
AS
Begin 
		
		Declare @newstring as varchar(100)
		Declare @pos as int
		Declare @i as int
		Declare @c as int	

		set @newstring = '';		
		set @i = 1
		set @c = 0

		set @pos = CHARINDEX(@delimeter, @oldstring) 

		WHILE (@i != 0)

			Begin

				set @c = @c +1
				insert into @mytab(counter,stringval) values(@c,@newstring + Substring(@oldstring,0, @pos))
				
				set @oldstring = Substring(@oldstring,@pos+1,len(@oldstring))

				set @pos = CHARINDEX(@delimeter, @oldstring)

				set @i = @pos;
				if (@i = 0)
                Begin
                    set @i = 0;
						set @c = @c +1
                
					insert into @mytab(counter,stringval) values(@c,@newstring + @oldstring)
				
				
                End
			End

			return

End

sujithkumarsl wrote:

Will the INDEX cause, the INSERT operation to take more time to completed?

sujithkumarsl wrote:

several SELECT as well as INSERT operation are running at same time

jonhbt wrote:

SELECT USERINFO.Name,DEPARTMENTS.DEPTNAME, main.CHECKTIME FROM (DEPARTMENTS RIGHT JOIN USERINFO ON DEPARTMENTS.DEPTID = USERINFO.DEFAULTDEPTID) INNER JOIN CHECKINOUT as main ON USERINFO.USERID = main.USERID WHERE (main.CHECKTYPE = \"I\" AND main.LOGID = (SELECT MAX(LOGID) FROM CHECKINOUT as last WHERE last.USERID = main.USERID));