Author: semt20

LOGO,SQL,VISUAL STUDIO,C#,DELPHI, PHOTOSHOP, WORDPRESS, PS, PHP, SMS VIA PC, EXCEL,DEVEXPRESS,LOGO MUHASEBE, LOGO ERP,SQL,MYSQL, SQL SERVER, ETC...

visual studio react native java jdk ayarla

On By semt20In TOOLS, visual studioLeave a comment
vscode file – preferencies – settings
workplace settings yaz java.home edit de

{
“java.home”:“C:\\Program Files\\AdoptOpenJDK\\jdk-11.0.3.7-hotspot”
}

sonra user settingse java.home yaz onada edit de

{
“editor.suggestSelection”: “first”,
“vsintellicode.modify.editor.suggestSelection”: “automaticallyOverrodeDefaultValue”,
“java.home”:“C:\\Program Files\\AdoptOpenJDK\\jdk-11.0.3.7-hotspot”
}

https://nodejs.org/en/download/ indir ve kur

cmd

npm install -g expo-cli

npm install -g react-native-cli

npm install -g create-react-native-app

react-native init projectNameHere

cd projectNameHere

react-native run-android

F:\masaustussd\react native\projectNameHere\android\ klasorunun icine local.properties isminde dosya YARAT ve icine sdk.dir = C:\\Users\\Pnp\\AppData\\Local\\Android\\sdk

SQL SERVER DATABASEDE ISTENILEN DEĞERİ ARAMA PROSEDURE

On By semt20In SqlLeave a comment 
--EXEC SearchAllTables 'a' 

CREATE PROC SearchAllTables( @SearchStr nvarchar(100))
    AS
 BEGIN
     CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))
        SET NOCOUNT ON

    DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
        SET @TableName = ''
        SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

      WHILE @TableName IS NOT NULL
      BEGIN
        SET @ColumnName = ''
        SET @TableName = (
                            SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
                              FROM INFORMATION_SCHEMA.TABLES
                             WHERE TABLE_TYPE = 'BASE TABLE'
                               AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
                               AND OBJECTPROPERTY( OBJECT_ID( QUOTENAME(TABLE_SCHEMA)
                                                      + '.' + QUOTENAME(TABLE_NAME) ),
                                                  'IsMSShipped' ) = 0
                         )
      WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
              BEGIN
                        SET @ColumnName = ( SELECT MIN(QUOTENAME(COLUMN_NAME))
                       FROM INFORMATION_SCHEMA.COLUMNS
                      WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)
                        AND TABLE_NAME = PARSENAME(@TableName, 1)
                        AND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar')
                        AND QUOTENAME(COLUMN_NAME) > @ColumnName )
                         IF @ColumnName IS NOT NULL
                              BEGIN
                                        INSERT
                                          INTO #Results
                                          EXEC ( 'SELECT ''' + @TableName + '.' + @ColumnName + ''',
                                                 LEFT(' + @ColumnName + ', 3630) FROM ' + @TableName + '
                                                 (NOLOCK) ' + ' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2 )
                                END
                END
       END
SELECT ColumnName, ColumnValue
  FROM #Results
   END

SQL OTOMATIK YEDEK ALMA

On By semt20In BACKUP, SqlLeave a comment
SQL SERVER 2005 ve 2008 ÜZERİNDE OTOMATİK YEDEK ALMA
SQL SERVER 2005 ve 2008 ÜZERİNDE OTOMATİK YEDEK ALMA

SQL Server üzerinde Maintenance Plans sekmesinden yeni bir plan oluşturularak otomatik yedek aldırmak için bir görev yapılır. Maintenance Plans kullanımı için SQL Server Windows Authentication modda çalıştırılmalı ve mixed modda kurulmalıdır.
Aynı zamanda SQL Server ile birlikte SQL Server Agent’ ında çalışıyor olması gerekmektedir. Maintenance Plans kullanımı için kullanıcı sysadmin yetkisinde olmalıdır.