RE: DTSGlobalVariables
hi dude, thanks 4 your answer.but i need to do something like this:select * from table where fieldvalue= <dtsglobalvar1>u got it?i need to use an external parameter to find data on my db. thanks a lot. sl3
2004-08-17
2 reads
PHP
RE: Should I have Multiple data files for large DB (250GB)?
What software are you using for backups?
2004-08-16
RE: Changing Authentication Modes in SQL Server 2000
Changing to Windows Authentication Only mode won't affect the databases. For instance, when you set up a SQL Server out of the box with Windows Authentication, master, model, msdb, Northwind, pubs, and tempdb are all owned by sa. The db_owner is internal to SQL Server.... it's a mapping between sysxlogins and sysdatabases. So long as […]
2003-07-16
RE: Creating a count field in DTS/T-SQL.
Do you like this create table #pc (idno int,p varchar(8)) insert into #pc values (0,'AA1 BB1') insert into #pc values (0,'AA1 BB1') insert into #pc values (0,'AA1 BB1') insert into #pc values (0,'AA2 BB2') insert into #pc values (0,'AA2 BB2') insert into #pc values (0,'AA2 BB2') insert into #pc values (0,'AA2 BB2') insert into #pc […]
2003-07-10
1 reads
RE: Sorting of 2 columns
Actually, to produce the results: 6 4 6 2 3 7 2 3 You actually want to sort by: 64 62 37 23 so: Select * from Table order by cast(col1 as varchar) + cast(col2 as varchar) Desc
2003-06-27
RE: Stored Procedure
What is better to use the on clause exclusive for the links between tables or to add everything into the on clauses, thus making the where clause fairly small
2003-06-17
RE: AS clause/WHERE clause
quote: Hi, This query.. select distinct id, count(id) as id_counter from x where id_counter > 1 wouldnt work because you are using a aggregate in the select list - you need to use group by for it to work.. using jays example - without the derived table, here's how you do it using a having […]
2003-05-29
RE: return value from exec(string)
The example I gave was not the best in that it immediate brought up questions of why I was trying to generate the key in that way in the first place. The situation is more one of coming into a place where they keys are generated in this way, but for each table and I […]
2003-05-22
2 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers