Simple Talk is now part of the Redgate Community hub - find out why

SQL Server 2008: Table-valued parameters

0
0
Table-valued types and parameters are among the many exciting new features of the recently released SQL Server 2008. These table-valued types allow you to pass table data to stored procedures and functions. But why is this useful? In previous versions of SQL Server one could pass parameters to stored procedures and functions. A single parameter … Read more
0
0

The unexpected behaviour of DirectoryInfo.GetFiles() with three letter extensions

0
1
There is a documented, but certainly counterintuitive issue with the DirectoryInfo.GetFiles() method in .Net. This method returns a list of files that match a particular pattern. For example in the following example it will return us all the files on drive Z: that have the exact extension “.foobar” DirectoryInfo folder = new DirectoryInfo(@”z:”); FileInfo[] files … Read more
0
1

Type less in SQL Server 2008 (variable initialization and multiple row inserts)

0
0
Among the large number of new features in SQL Server 2008 there are two, almost insignificant features, that I use almost constantly. These are variable initialization and the values clause of insert statements that now accept multiple rows. When playing with SQL one inevitably declares some variables. After the declaration, and as per the SQL … Read more
0
0

The GO command can have a parameter?

0
0
I have mixed feelings about the GO command. It is not a T-SQL statement, it is just something that Management Studio and the other SQL Server tools understand as a batch separator command. Indeed, you can change it to whatever you wish in Management Studio under Tools->Options->Query Execution->SQL Server->General->Batch separator.So you can write queries like … Read more
0
0

How you log in to Simple Talk has changed

We now use Redgate ID (RGID). If you already have an RGID, we’ll try to match it to your account. If not, we’ll create one for you and connect it.

This won’t sign you up to anything or add you to any mailing lists. You can see our full privacy policy here.

Continue

Simple Talk now uses Redgate ID

If you already have a Redgate ID (RGID), sign in using your existing RGID credentials. If not, you can create one on the next screen.

This won’t sign you up to anything or add you to any mailing lists. You can see our full privacy policy here.

Continue