-
as seen on SQL Blogcasts
- Search for 'SQL Blogcasts'
Hello
This is a quick follow-up blog to the Presention I gave last night @ the London UG Meeting ( 17th March 2010 )
It was a great evening and we had a big full house (over 120 Registered for this event), due to time constraints we had I was unable to spend enough time on this topic…
>>> More
-
as seen on SQL Blogcasts
- Search for 'SQL Blogcasts'
London SQL Server UG Presentation, @ Microsoft Victoria (17 th March 2010). As this was my First UG Presentation I picked a topic and dutifully researched and prepared the PowerPoint Slides & a brief introduction, @ the last minute we needed to change the order of presentations due to small technical…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a table that looks like this for about ~30 students:
StudentID Course* CourseStatus
1 Math Pass
1 English Fail
1 Science Pass
2 Math Fail
2 English Pass
2 Science Fail
etc.
*In my…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
In my database, assume we have a table defined as follows:
CREATE TABLE [Chemical](
[ChemicalId] int NOT NULL IDENTITY(1,1) PRIMARY KEY,
[Name] nvarchar(max) NOT NULL,
[Description] nvarchar(max) NULL
)
The value for Name can be very large, so we must use nvarchar(max). Unfortunately…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a scalar UDF that I know to be deterministic, however SQL doesn't. Is there a way to declare it as deterministic so that I can then use it in a persisted computed column definition?
further clarification:
The purpose of this exercise is that I need to harvest out specific values from an XML…
>>> More
