Friday, November 13, 2015

run sql script from command line




 sqlcmd -S ATIK-PC\SQLEXPRESS -d STUDENT_DEV -U sa -P sa123 -i c:\schema.sql -o c:\log.txt  


Friday, November 6, 2015

SQL split a comma separated string

SQL split a comma separated string


 DECLARE @valueList varchar(8000)  
 DECLARE @pos INT  
 DECLARE @len INT  
 DECLARE @value varchar(8000)  
 DECLARE @i INT=0  
 SET @valueList = ',Atik,Khabir,Shahed,Shain,Ashek,Noman'  
 set @pos = 0  
 set @len = 0  
 WHILE CHARINDEX(',', @valueList, @pos+1)>0  
 BEGIN  
   set @len = CHARINDEX(',', @valueList, @pos+1) - @pos  
   set @value = SUBSTRING(@valueList, @pos, @len)  
      set @i=@i+1   
   --SELECT @pos, @len, @value /*this is here for debugging*/  
     IF(@i=1) -- now you can set condition  
           BEGIN  
            PRINT @value   
           END  
            IF(@i=2)  
           BEGIN  
            PRINT @value   
           END  
            IF(@i=3)  
           BEGIN  
            PRINT @value   
           END  
            IF(@i=4)  
           BEGIN  
            PRINT @value   
           END  
   set @pos = CHARINDEX(',', @valueList, @pos+@len) +1  
 END  


SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...