Viewing 15 posts - 8,251 through 8,265 (of 11,678 total)
Siva Ramasamy (1/30/2012)
(CategoryId int, NameCategory varchar(245))
INSERT INTO Category ( CategoryId, NameCategory) VALUES (1,'A')
INSERT INTO Category ( CategoryId, NameCategory) VALUES (2,'B')
INSERT INTO...
January 31, 2012 at 12:03 am
Coolroof (1/30/2012)
how to configure Encryption for particular column in sql server 2008..?pls give me the step..?
How to: Encrypt a Column of Data
First google result for sql server encrypt column.
January 31, 2012 at 12:00 am
You should ask the Human Resource department.
Ok, seriously now, how are we supposed the answer the question when we have no idea what the tables are like, how the columns...
January 30, 2012 at 11:58 pm
Hmmmm, this is arguable.
MSDN says that it can only use columns for the same table.
And a computed column can't reference a column outside another table, it can reference a UDF...
January 30, 2012 at 11:28 pm
yuvipoy (1/20/2012)
Hi,Using VS.NET 2005 and SQL 2005 Windows XP SP3.
What has SP3? SQL Server or Windows XP?
January 30, 2012 at 11:11 pm
rajiv.kumarb (1/30/2012)
u can use Single For Loop,( assign the file name into variable,)and u can use scriptTask to read the fileName (from variable) and move the file to relavant location.
thanks,
rajivkumar
Why...
January 30, 2012 at 11:08 pm
Capt. Sigerson (1/30/2012)
January 30, 2012 at 11:04 am
Sri8143 (1/30/2012)
I am using ssis not ssms ....and they want to do it thru ssis ..
Use an Execute SQL Task to create a backup of the database.
Use another Execute SQL...
January 30, 2012 at 6:19 am
How to: Map Result Sets to Variables in an Execute SQL Task
(Google is a wonderful thing)
January 30, 2012 at 6:16 am
In the For Each Loop you can specify a wildcard search for which files the For Each Loop should pick up.
So you configure 5 For Each Loops. Each loop picks...
January 30, 2012 at 6:14 am
Prashant Mhaske (1/27/2012)
Hi,I can not afford 64bit operating on server at this moment .
Could you please suggest any other option ?
Thanks in advance !
Process the data in smaller chunks instead...
January 29, 2012 at 12:15 am
GSquared (1/27/2012)
Completely agreed. Didn't mean to sound like I was coming down on your answer, just wanted to clarify that IMEX won't fix the lost digits piece.
I know.
If Excel...
January 27, 2012 at 6:34 am
Brandie Tarvin (1/27/2012)
I'm...
January 27, 2012 at 5:15 am
Gianluca Sartori (1/27/2012)
SQL Kiwi (1/27/2012)
Google indexes scarily fastNot always 😀
That's because they probably censored it. Google and scary in one sentence, what did you expect?
January 27, 2012 at 5:12 am
Viewing 15 posts - 8,251 through 8,265 (of 11,678 total)