Questions & Answers
Active Directory, AS/400, Backup, Business Intelligence, Career Development, CIO, CRM, Data Management, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Marketing, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Exchange 2003, Microsoft Exchange 2007, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2007, Microsoft Windows, Microsoft Windows 7, Microsoft Windows Server 2003, Microsoft Windows XP, Mobile, Networking, Oracle, OS, Routers, RPG, RPGLE, SAP, Servers, SQL, SQL Server, SQL Server 2005, Storage, Virtualization, Visual Basic, VoIP, VPN, Windows Server, Windows Server 2008 ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
How do I input a date for query to an SQL database from Visual Studio.
Can I make a composite key with SSMS (SQL Server Management Studio)? I need to have two INT columns that are needed to form the identity for one of my tables. Thank you so much.
Can I check if a specific login exists on SQL Server? And if it doesn't exist, I actually have to add it too. Here's the code I found to add it: CREATE LOGIN [myUsername] WITH PASSWORD=N'myPassword', DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO But how can I check if...
For my SQL Server database table, is there a way I can auto increment the primary key? I tried to go into properities but I'm not seeing anything. A co-worker told me about the identity specification property -> set it to yes but I'm not seeing that at all. Can someone help me?
Is there a way I can select data, in the same query, from two different SQL Server databases that are on two different servers? How can I do this?
I'm using SQL Server 2008. I'm looking to see all of my active connections (and their data). This includes: IP address, database connections, etc. How can I do that.
On SQL Server, I noticed that it doesn't restore my backup due to all of the active connections. Is there a way to force it through? If not, how can I disconnect all the active connections?
Actually I'm trying to analyze the requirement coverage by linking requirement with the test case but it is not showing how many test case is been failed or passed it is showing only in terms of the requirement is passed or failed.
while installing oracle9i in laptop i a getting message jrew.exe stopping program(i am using windows 7)
How much time will consumed by a pipeline processor to execute 10 instructions?
My boss asked me to empty our LDF file before I send it to one of our clients. Is there a way I can force SQL Server to truncate my log? Thank you very much.
What does the error code a6050266 mean?
Hillary Clinton is using metadata to improve her chances of winning the Presidency as Obama did in 2008 and 2012. What is metadata and how is it used in a political sense?
How do I silence the tone connected to the dial pad?
How can I open a XLA file?
Hi, I have a condition (with a parameter named @Par1=IS NOT NULL) in query like this select * from table1 where Numeric field1 IS NOT NULL. It runs okay but where numeric field1 =@Par1 it, it doesn't work. Another example: @A= '>0' and @invcode = 1 @InvCode INT, @A nvarchar(20) SELECT GoodCode,...
Would it be possible for me to change a SQL Server column from VARCHAR to a NVARCHAR? Is there a specific SQL command to do this?
In one of SQL Server 2008 table columns, I have to go ahead and rename it. How can I do that? I've tried this but it didn't work: ALTER TABLE table_name RENAME COLUMN old_name to new_name; Thanks!
I'm currently using SQL Server 2008 and here's my issue - I'm trying to move my table into a specific schema using T-SQL. I can't figure out how to do it. Can someone help me?
I can't find anything. Is there a way for me to unblock my school Chromebook?