code language | SQL Studies

Tag Archives: code language

Backup a password, change it, then restore it.
3
May 30, 2013 by Kenneth Fisher

A couple of months ago I talked about moving a login from one server to another without the password. The …
Continue reading

Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: code language, dynamic sql, language sql, microsoft sql server, security, sql statements, T-SQL
Using CROSS APPLY to calculate an aggregate across a single row.
2
May 28, 2013 by Kenneth Fisher

I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, CROSS APPLY, language sql, microsoft sql server, sql statements, T-SQL
Using CROSS APPLY instead of a calculated variable
3
May 22, 2013 by Kenneth Fisher

Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, CROSS APPLY, language sql, microsoft sql server, sql statements, T-SQL
The many uses of CROSS APPLY
4
May 20, 2013 by Kenneth Fisher

Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, CROSS APPLY, language sql, microsoft sql server, sql statements, T-SQL
CREATE SCHEMA can do what?!?!?
4
May 15, 2013 by Kenneth Fisher

So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, sql statements, T-SQL
INFORMATION_SCHEMA the un-sung system views
13
April 29, 2013 by Kenneth Fisher

I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others. …
Continue reading

Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: code language, INFORMATION_SCHEMA, language sql, microsoft sql server, sql statements, system functions, T-SQL
How do I tell the stored procedure name from inside the stored procedure?
1
April 24, 2013 by Kenneth Fisher

I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: code language, language sql, microsoft sql server, object functions, object id, sql statements, system functions, T-SQL
Calculating the length of a string (Len vs DataLength)
3
April 14, 2013 by Kenneth Fisher

This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, sql statements, string code, T-SQL, unicode strings
How do I use a variable in an IN clause?
16
April 8, 2013 by Kenneth Fisher

I see this question in one form or another a lot. I’ve seen this or something like it probably half …
Continue reading

Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, dynamic sql, language sql, microsoft sql server, split function, sql statements, T-SQL
UNPIVOT a table using CROSS APPLY
23
April 1, 2013 by Kenneth Fisher

I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, sql statements, T-SQL

« Older Entries

Newer Entries »

SQL Studies

Tag Archives: code language

Backup a password, change it, then restore it.

Using CROSS APPLY to calculate an aggregate across a single row.

Using CROSS APPLY instead of a calculated variable

The many uses of CROSS APPLY

CREATE SCHEMA can do what?!?!?

INFORMATION_SCHEMA the un-sung system views

How do I tell the stored procedure name from inside the stored procedure?

Calculating the length of a string (Len vs DataLength)

How do I use a variable in an IN clause?

UNPIVOT a table using CROSS APPLY

Follow me via RSS

Follow me via Email

Follow me on Twitter

Archives

Categories

Meta