<blockquote> <h1><span style="font-size:36px"><span style="font-family:inherit"><span style="color:inherit">Attaching SQL Server database without log ...
Okumaya devam et
<blockquote> <p>SELECT trigger_name = name, table_name = OBJECT_NAME(parent_obj),</p> <p> isupdate = OBJECTPROPERTY( id, 'ExecIsUpdat...
Okumaya devam et
<p>ALTER DATABASE SManagement SET SINGLE_USER WITH ROLLBACK IMMEDIATE<br /> ALTER DATABASE SManagement COLLATE SQL_Latin1_General_CP1_CI_AS<br /> ALTE...
Okumaya devam et
<blockquote> <p>CREATE PROC SearchAllTables</p> <p><br /> (<br /> @SearchStr nvarchar(100)<br /> )<br /> AS<br /> BEGIN<br /> CREATE TABLE #Results (...
Okumaya devam et
<pre> <code>SELECT trigger_name = name, trigger_owner = USER_NAME(uid), table_name = OBJECT_NAME(parent_obj), crdate FROM sysobjects WHERE type = ...
Okumaya devam et
SELECT STFIC.AFFECTCOLLATRL, STFIC.LOGICALREF, STFIC.GRPCODE, STFIC.TRCODE, STFIC.IOCODE, STFIC.FICHENO, STFIC.DATE_, STFIC.FTIME, STFIC.DOCODE, STF...
Okumaya devam et
Alt+X, Ctrl+E, F5 : Sorguları çalıştırmanızı sağlarlar. (Execution işlemi) Ctrl+T : Sorgu sonucunu text şekline getirir. Ctrl+D : Sorgu sonucunu grid...
Okumaya devam et
Aynı vergi kimlik numarasına carileri gruplayıp , ilk sıradakini alma SELECT * FROM LG_003_CLCARD CL JOIN ( SELECT ROW_NUMBER() OVER(PARTITION B...
Okumaya devam et
CASE WHEN IT.CARDTYPE = 1 THEN 'Ticari Mal ' WHEN IT.CARDTYPE = 2 THEN 'Karma Koli' WHEN IT.CARDTYPE = 3 THEN 'Depozitolu Mal' WHEN IT.CARDTYP...
Okumaya devam et
DECLARE @Names VARCHAR(max) SELECT @Names = COALESCE(@Names + ', ', '') + CODE FROM LG_003_CLCARD lc PRINT @Names
Okumaya devam et