Forum Replies Created
Viewing 15 posts - 1,876 through 1,890 (of 5,356 total)
-
RE: Creating Dynamic databases
Sorry, but in my opinion this is presentational stuff.
I assume, you need this for some kind of international application. I wuold do the localisation at the front end.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Creating Dynamic databases
Your description is , ehm, a little bit vague and unclear.
Can you post an example of what you mean?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Identity_Insert on remote servers
Can you post any more information, such as error messages...?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Varying return values for Servername
Yup, done! Since this is my laptop that wasn't much of a problem.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: SQL Server 6.5 on W2K3
"Will not work" might be the wrong expression. "Will not be supported" seems to be more precise, when you read this http://www.microsoft.com/sql/howtobuy/windowsnetsupport.asp.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: String formatting - Postcode
Glad to hear it worked!
Why run around the block when you can nip through the alley
...because one sometimes can't see the forest from the trees (or how do you...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: String formatting - Postcode
Aah, great solution for the lazycoder
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Varying return values for Servername
Damn, I found the wrong name in several places in the registry. Just did a global hack and replaced all occurences with the correct name and hope nothing will break...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: String formatting - Postcode
Untested! What about:
SELECT
'BD153TY', LEFT('BD153TY',LEN('BD153TY')-3)+ ' '+RIGHT('BD153TY',3)
, 'LE34TY', LEFT('LE34TY',LEN('LE34TY')-3)+ ' '+RIGHT('LE34TY',3)
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Connecting to sql server from Query Analizer
Windows XP? SP2?
Maybe one of these will help:
http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2otech.mspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;841249
http://support.microsoft.com/default.aspx?scid=kb;EN-US;839279
http://support.microsoft.com/default.aspx?scid=kb;EN-US;841394
http://support.microsoft.com/default.aspx?scid=kb;EN-US;841251
http://support.microsoft.com/default.aspx?scid=kb;EN-US;841252
http://support.microsoft.com/default.aspx?scid=kb;EN-US;839269
Good luck!
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Connecting to sql server from Query Analizer
Could this be the case? http://support.microsoft.com/kb/822473
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Connecting to sql server from Query Analizer
What is the exact error message you get?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Need script for Search and Update in all columns in all tables using keyword
Do a search in the script section here. Very likely you'll find there what you are looking for.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Returning Id Column after insert
And in case you need it for your developers in written what Adam said, have a look at BOL for "IDENT_CURRENT". Also contains a nice example about the differences between...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Enable/Disable IDENTIFY
I believe Dinesh meant the same, however have a look at BOL for SET IDENTITY_INSERT ON/OFF. Should do what you want.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 1,876 through 1,890 (of 5,356 total)