120 private links
DECLARE
@object_name SYSNAME
, @object_id INT
, @SQL NVARCHAR(MAX)
SELECT
@object_name = '[' + OBJECT_SCHEMA_NAME(o.[object_id]) + '].[' + OBJECT_NAME([object_id]) + ']'
, @object_id = [object_id]
FROM (SELECT [object_id] = OBJECT_ID('dbo.WorkOut', 'U')) o
SELECT @SQL = 'CREATE TABLE ' + @object_name + CHAR(13) + '(' + CHAR(13) + STUFF((
SELECT CHAR(13) + ' , [' + c.name + '] ' +
CASE WHEN c.is_computed = 1
THEN 'AS ' + OBJECT_DEFINITION(c.[object_id], c.column_id)
ELSE
CASE WHEN c.system_type_id != c.user_type_id
THEN '[' + SCHEMA_NAME(tp.[schema_id]) + '].[' + tp.name + ']'
ELSE '[' + UPPER(tp.name) + ']'
END +
CASE
WHEN tp.name IN ('varchar', 'char', 'varbinary', 'binary')
THEN '(' + CASE WHEN c.max_length = -1
THEN 'MAX'
ELSE CAST(c.max_length AS VARCHAR(5))
END + ')'
WHEN tp.name IN ('nvarchar', 'nchar')
THEN '(' + CASE WHEN c.max_length = -1
THEN 'MAX'
ELSE CAST(c.max_length / 2 AS VARCHAR(5))
END + ')'
WHEN tp.name IN ('datetime2', 'time2', 'datetimeoffset')
THEN '(' + CAST(c.scale AS VARCHAR(5)) + ')'
WHEN tp.name = 'decimal'
THEN '(' + CAST(c.[precision] AS VARCHAR(5)) + ',' + CAST(c.scale AS VARCHAR(5)) + ')'
ELSE ''
END +
CASE WHEN c.collation_name IS NOT NULL AND c.system_type_id = c.user_type_id
THEN ' COLLATE ' + c.collation_name
ELSE ''
END +
CASE WHEN c.is_nullable = 1
THEN ' NULL'
ELSE ' NOT NULL'
END +
CASE WHEN c.default_object_id != 0
THEN ' CONSTRAINT [' + OBJECT_NAME(c.default_object_id) + ']' +
' DEFAULT ' + OBJECT_DEFINITION(c.default_object_id)
ELSE ''
END +
CASE WHEN cc.[object_id] IS NOT NULL
THEN ' CONSTRAINT [' + cc.name + '] CHECK ' + cc.[definition]
ELSE ''
END +
CASE WHEN c.is_identity = 1
THEN ' IDENTITY(' + CAST(IDENTITYPROPERTY(c.[object_id], 'SeedValue') AS VARCHAR(5)) + ',' +
CAST(IDENTITYPROPERTY(c.[object_id], 'IncrementValue') AS VARCHAR(5)) + ')'
ELSE ''
END
END
FROM sys.columns c WITH(NOLOCK)
JOIN sys.types tp WITH(NOLOCK) ON c.user_type_id = tp.user_type_id
LEFT JOIN sys.check_constraints cc WITH(NOLOCK)
ON c.[object_id] = cc.parent_object_id
AND cc.parent_column_id = c.column_id
WHERE c.[object_id] = @object_id
ORDER BY c.column_id
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 7, ' ') +
ISNULL((SELECT '
, CONSTRAINT [' + i.name + '] PRIMARY KEY ' +
CASE WHEN i.index_id = 1
THEN 'CLUSTERED'
ELSE 'NONCLUSTERED'
END +' (' + (
SELECT STUFF(CAST((
SELECT ', [' + COL_NAME(ic.[object_id], ic.column_id) + ']' +
CASE WHEN ic.is_descending_key = 1
THEN ' DESC'
ELSE ''
END
FROM sys.index_columns ic WITH(NOLOCK)
WHERE i.[object_id] = ic.[object_id]
AND i.index_id = ic.index_id
FOR XML PATH(N''), TYPE) AS NVARCHAR(MAX)), 1, 2, '')) + ')'
FROM sys.indexes i WITH(NOLOCK)
WHERE i.[object_id] = @object_id
AND i.is_primary_key = 1), '') + CHAR(13) + ');'
PRINT @SQL
communauté de voyageurs francophones
Library
Tips
Code
POur connaître son IMEI: #06#
Pour le changer: Root nécessaire.
Taper ##3646633## OU #7465625# et appel.
Trouver le menu "CDS", le nom peut varier.
Check out for Radio information.
If you have dual SIM, there will be two options for you, select the one which you want to go with.
Now to change IMEI number follow –
AT +EGMR=1,7,”XXXXXX_IMEI_1” and “AT +EGMR=1,10,”XXXXX_IMEI_2” (replace IMEI_1 and IMEI_2 with your IMEI no)
Envoyer et rebooter le tel.
Pour vérifier taper: *#06#
Ou alternativement et plus simple (root aussi):
Avec l'appli "MTK Engineering Mode" --> "MTK settings" --> "Telephony" --> "GPRS" --> Select Sim -->"Write IMEI"
Rebooter.
Pour vérifier taper: *#06#
I thought Ligaya Turmelle's post on SQL joins was a great primer for novice developers. Since SQL joins appear to be set-based, the use of Venn diagrams to explain them seems, at first blush, to be a natural fit. However, like the commenters to her post, I found that the Venn diagrams didn't quite match the SQL join syntax reality in my testing.
Pearls of wisdom for programmers collected from leading practitioners. Contributions Appearing in the Book plus the Other Edited Contributions, browse Contributions in Progress, view the list of Contributors.
DECLARE @TestTable AS TABLE (
[Id] VARCHAR(20),
[Name] XML
)
INSERT INTO @TestTable
SELECT '001',
'<Name><First>Ross</First><Last>Geller</Last></Name>'
UNION ALL
SELECT '002',
'<Name><First>Rachel</First><Last>Green</Last></Name>'
SELECT Id,
x.value('(/Name/First)[1]', 'varchar(20)') AS [First],
x.value('(/Name/Last)[1]', 'varchar(20)') AS [Last]
FROM @TestTable t
CROSS APPLY [Name].nodes('/Name') AS tbl ( x )
---------- TEST 2 -----------
DECLARE @x XML
SET @x = '
<Root>
<row code="1979" CodeName="Luna" ><name>Remus</name><oflw>Patronum</oflw></row>
<row code="2004"><name>Viktor</name></row>
<row code="2003" />
</Root>
<Root>
<row code="700000" CodeName="Albus" ><name>harry</name><oflw>riddikulus</oflw></row>
<row code="500000"><name>Ron</name></row>
<row code="4195" CodeName="Petunia" ><name>Snape</name><oflw>Patronum</oflw><item><book>Fire</book><book>Stone</book></item></row>
</Root>'
SELECT T.c.query('.') AS result
FROM @x.nodes('/Root') T(c)
SELECT T.c.query('.') AS result
FROM @x.nodes('/Root/row') T(c)
SELECT T.c.value('./name[1]', 'nvarchar(max)') AS NAME
,T.c.value('./oflw[1]', 'nvarchar(max)') AS oflw
,T.c.value('@code', 'nvarchar(max)') AS code
,T.c.value('@CodeName', 'nvarchar(max)') AS CodeName
FROM @x.nodes('/Root/row') T(c)
SELECT T.c.value('./name[1]', 'nvarchar(max)') AS NAME
,T.c.value('./oflw[1]', 'nvarchar(max)') AS oflw
,T.c.value('@code', 'nvarchar(max)') AS code
,T.c.value('@CodeName', 'nvarchar(max)') AS CodeName
,T.c.value('./item[1]/book[1]', 'nvarchar(max)') AS book
FROM @x.nodes('/Root/row') T(c)
SELECT T.c.value('./../name[1]', 'nvarchar(max)') AS NAME
,T.c.value('./../oflw[1]', 'nvarchar(max)') AS oflw
,T.c.value('../@code', 'nvarchar(max)') AS code
,T.c.value('../@CodeName', 'nvarchar(max)') AS CodeName
,T.c.value('./book[1]', 'nvarchar(max)') AS book
,T.c.value('../name[1]', 'nvarchar(max)') AS name2
,T.c.value('../oflw[1]', 'nvarchar(max)') AS oflw2
FROM @x.nodes('/Root/row/item') T(c)
The purpose of this guide is to prepare a USB Flash Drive with the installation files of Windows Vista™ or Windows 7™. Most Netbook does not come with a CD/DVD drive and therefore installing or upgrading to a new operating system is always a challenge. The guide is divided into two parts, the first part talks about the preparation of the Flash Drive and the later talks about how to copy the installation file content on to the Drive for installation.
The best way to delete hiberfil.sys or disable hibernate:
Go to Start menu, type “cmd” open up command prompt
Type “powercfg.exe -h off” [make sure you are an Administrator]
ENTER
Type “exit”
ENTER