|
|
-
Mitesh Modi Liked 12 Months ago through Books
This books tries to explain the new FILESTREAM feature introduced in SQL Server 2008 from basic to advanced levels through a number of simple examples and walk-through labs...
|
|
|
-
Mitesh Modi Commented 12 Months ago through Ask
Try this query for your xml
SELECT
x.value('local-name(.)', 'VARCHAR(50)') AS VariableName,
x.value('./text()[1]','VARCHAR(50)') AS VariableValue
FROM @x.nodes('/Policies/Policy/Roles/Role/*')T(x)
OR
SELECT
x.value...
|
-
Mitesh Modi Liked 12 Months ago through Blogs
As you know well, VALUES clause is used to insert values to the table
A simple example is
declare @t table (id int , col1 int, col2 int, col3 int)
insert into @t values(1, 14, 12, 24)
select * from @t
But in version 2008, you can do more things...
|
-
Mitesh Modi learned 12 Months ago through Blogs
As you know well, VALUES clause is used to insert values to the table
A simple example is
declare @t table (id int , col1 int, col2 int, col3 int)
insert into @t values(1, 14, 12, 24)
select * from @t
But in version 2008, you can do more things...
|
-
Mitesh Modi Liked 12 Months ago through Tutorials
In this chapter, we learn about the anatomy of a SQL Trace and how the SQL Server Profiler integrates into the SSMS, Query editor and the Activity Monitor....
|
-
Mitesh Modi Commented 12 Months ago through Ask
Hi Jignesh,
Try below query
DECLARE @SurVeyId int
SET @SurVeyId=89
DECLARE @cols NVARCHAR(Max)
DECLARE @colsIsNull NVARCHAR(Max)
SELECT @cols = COALESCE(@cols + ',' + QUOTENAME(choiceTitle,'['),QUOTENAME(choiceTit...
|
-
Jignesh Desai Received Vote Up 12 Months ago through ASK
Hi Jignesh,
Try below query
DECLARE @SurVeyId int
SET @SurVeyId=89
DECLARE @cols NVARCHAR(Max)
DECLARE @colsIsNull NVARCHAR(Max)
SELECT @cols = COALESCE(@cols + ',' + QUOTENAME(choiceTitle,'['),QUOTENAME(choiceTitle,...
|
-
Jignesh Desai Received Vote Up 12 Months ago through ASK
Hi Jignesh,
Try below query
DECLARE @SurVeyId int
SET @SurVeyId=89
DECLARE @cols NVARCHAR(Max)
DECLARE @colsIsNull NVARCHAR(Max)
SELECT @cols = COALESCE(@cols + ',' + QUOTENAME(choiceTitle,'['),QUOTENAME(choiceTitle,...
|
|
|