SQL Server Newbies
-
Topics
-
How to Change SQL Server name
We are having to SQL database sever JKA and JKB. Both are running on Windows 2000 Server with SQL 2…
-
Script to apply pending logs
I am looking at the backupset view/table ; My aim is to regenerate the SQL statements to apply the …
-
JOIN issue
SELECT depositid, depositdate, batchid INTO #deposits SELECT batchid, type, amount, adj INTO #…
-
Concatenating string
Hi guys, I for one find it rather confusing when I have to concatenate string like in the query bel…
-
Create tables from flat file
Dear All, I had recieved an excel sheet from one of my clients which contains nearly 300,000 …
-
Generating Reports DYNAMICALLY in SSRS-2005
I'm Working with Asp.Net with C#.. & I'm Generating Reports in SSRS-2005.. Till …
-
Determine Missing Records
Hi guys, I hope you guys can help me out on this one. Some background before I begin. I have a tabl…
-
Working with Stored Procedures in Sqlserver-2005
I'm Using ASP.Net with C# & SqlServer-2005.. In my Sqlserver, I'm having two Databases.. …
-
how to view transaction log file
I always run the query using begin/commit transaction. But if i want to view the details of this t…
-
Query in Access works, same query in SQL doesn't workd
I am transferring a database from Access to SQL server 2005. I need to match 2 tables on a single …
-
SSN datatypes
i am trying to create a user defined data type in query anylazer so that when i enter a a SSN # i d…
-
Where are stored the stored procedures?
Where "SQL Server" save the text of a stored procedure? In a table? what's the name of this or thes…
-
Updating SQL Server Tables via .aspx built with VWD Not Working
I have SQL Server 2005 running on a server w/SBS 2003. I have created a test web application with V…
-
Need help with outer joins
I have 3 tables - User (has CityId, GroupId), City, Group. I am trying to run a query that would re…
Viewing 15 topics - 871 through 885 (of 2,871 total)
You must be logged in to create new topics.